I had a similar issue on my WordPress site. It was hosted on a shared host. The host limits the connections per user to 25000 every hour. I see two possible solutions for this to get fixed. First Solution:- TheContinue reading… MySQL error – has exceeded the ‘max_questions’ resource in database
Category: Pl/SQL
SQL + Pl/Sql
ORA-01194: file 1 needs more recovery to be consistent
Solution that worked for me. SQL> shutdown immediate ORA-01109: database not open Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 530288640 bytes Fixed Size 2131120 bytes Variable Size 310381392 bytes Database Buffers Continue reading… ORA-01194: file 1 needs more recovery to be consistent
MySQL error – has exceeded the ‘max_questions’ resource in database
I had a similar issue on my WordPress site. It was hosted on a shared host. The host limits the connections per user to 25000 every hour. I see two possible solutions for this to get fixed. First Solution:- TheContinue reading… MySQL error – has exceeded the ‘max_questions’ resource in database
SQL Loader: Import CSV to Oracle table
One of the very common task in oracle environment is export/import of CSV files to Oracle database. Export is pretty straight forward as many of oracle clients provide this as standard functionality for any query. But for import, we canContinue reading… SQL Loader: Import CSV to Oracle table
MySQL Error Number 1005 Can’t create table ‘.mydb#sql-328_45.frm’ (errno: 150)
If you get this error while trying to create a foreign key, it can be pretty frustrating. The error about not being able to create a .frm file seems like it would be some kind of OS file permission errorContinue reading… MySQL Error Number 1005 Can’t create table ‘.mydb#sql-328_45.frm’ (errno: 150)
Dealing with newline, n or even r in PL/SQL
In my PL/SQL procedure I had to add a text including newline (n in java, ascii #10) in a text to be read by a java application. Tried with the code l_text := ‘hellonworld’; This did not work, the nContinue reading… Dealing with newline, n or even r in PL/SQL
java.sql.SQLException: Non supported SQL92 token at position: 1
Seems like this is very common error in pl/sql programming. I know there are many last minute frustrations just because of this error which is no where related to any logic. This seems to be some format error in theContinue reading… java.sql.SQLException: Non supported SQL92 token at position: 1
MySQL error 1067 (42000): Invalid default value for ‘ban_id’
# # Table structure for table ‘phpbb_banlist’ # CREATE TABLE phpbb_banlist ( ban_id mediumint(8) unsigned DEFAULT ‘0’ NOT NULL auto_increment, ban_userid mediumint(8) DEFAULT ‘0’ NOT NULL, ban_ip varchar(8) DEFAULT ” NOT NULL, ban_email varchar(255), PRIMARY KEY (ban_id), KEY ban_ip_user_id (ban_ip,ban_userid)Continue reading… MySQL error 1067 (42000): Invalid default value for ‘ban_id’
Oracle Specific SQL Concepts – Part 1
Some of the new concepts introduced as a part of Oracle new releases are: Analytical Functions In addition to the normal aggregate function like Max() etc. Oracle came up with some more commonly useful analytical functions, which can be implementedContinue reading… Oracle Specific SQL Concepts – Part 1
How to pass a list of values or array to SQL Server stored procedure?
Note: Information & code samples from this article are tested on SQL Server 2005 RTM (Yukon) and found to be working. Will update the article in case of any compatibility issues. unfortunately, there is no built-in support for arrays inContinue reading… How to pass a list of values or array to SQL Server stored procedure?