-
Composite Primary Key
WHat is Composite Primary Key?
-
Get fieldnames from Empty Table
How to get field names from empty table by using SELECT statement;
-
Determine Number of Blocks Corrupted
You have a database. You have a datafile and some blocks are corrupted in the datafile. What statement will you issue to know how many blocks are corrupted?
-
Flash Back Query
What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).
-
DBMS_meta_data Parameter
DBMS_meta_data. This parameter is very usefull. What you infer from this parameter. What info you will find in that. explain in detail.
-
Datafile Size
What is your datafile size? How long it can go? What is the max limit to which you can extend?
-
Compression Parameter
You have a database of 2GB. Can you convert the database to 1GB. Which compression parameter will you use?
-
how to execute a sql*plus script from pl/sql block.
my script contains sql plus set commands. how to execute that script in a pl/sql block i.e. either anonymous ,procedure or function or trigger
-
Time taken by a query
What is the command to print the time taken by a query
-
-
-
-
-
-
Command to show SQL commands from buffer
Which command displays the SQL command in the SQL buffer, and then executes it?