Q&A Categories

SQL

Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()?

Why do i get "Invalid Cursor State" errors when I insert/update/delete data with execute Query()? '

Answers No Answers In: SQL By: ramesh [ Grey Star Level] Sep 6, 2010

Why does the following command give a compilation error?

Why does the following command give a compilation error? DROP TABLE &TABLE_NAME;Variable names should start with an alphabet. Here the table name starts with an '&' symbol.'

Answers No Answers In: SQL By: ramesh [ Grey Star Level] Sep 6, 2010

Which system table contains information on constraints on all the tables created?

Which system table contains information on constraints on all the tables created? USER_CONSTRAINTS'

Answers No Answers In: SQL By: sunil [ Grey Star Level] Sep 5, 2010

Which system tables contain information on privileges granted and privileges obtained?

Which system tables contain information on privileges granted and privileges obtained? USER_TAB_PRIVS_MADE, USER_TAB_PRIVS_RECD'

Answers No Answers In: SQL By: samir [ Grey Star Level] Sep 5, 2010

Which is more efficient('WHERE" or "HAVING") in SQL ?

Which is more efficient('WHERE" or "HAVING") in SQL ? '

Answers No Answers In: SQL By: ashok [ Grey Star Level] Sep 4, 2010

Which is more faster – IN or EXISTS?

Which is more faster - IN or EXISTS? EXISTS is more faster than IN because EXISTS returns a Boolean value whereas IN returns a value.'

Answers No Answers In: SQL By: priyanka [ Grey Star Level] Sep 4, 2010

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables? Data Definition Language (DDL) '

Answers No Answers In: SQL By: bipin [ Grey Star Level] Sep 4, 2010

Which command displays the SQL command in the SQL buffer, and then executes it?

Which command displays the SQL command in the SQL buffer, and then executes it? RUN'

Answers No Answers In: SQL By: bipin [ Grey Star Level] Sep 4, 2010

Which command executes the contents of a specified file?

Which command executes the contents of a specified file? START or @'

Answers No Answers In: SQL By: faiz [ Grey Star Level] Sep 4, 2010

Which datatype is used for storing graphics and images?

Which datatype is used for storing graphics and images? LONG RAW data type is used for storing BLOB's (binary large objects).'

Answers No Answers In: SQL By: raju1587 [1 Grey Star Level] Sep 4, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]