How to insert a new row into a table in oracle?
which statement is running fastly ie insert or delete?
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
Which environment variables are absolutely critical in order to run the OUI?
How to put more than 1000 values into an oracle in clause?
what happened to the global index when I truncate the data in one of the partition?
what are the different types of cursors? explain?
What is the Tune Query
What is the best way to do multi-row insert in oracle?
Can the default values be assigned to actual parameters?
how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as only NN,but not other alphabets, if NN is thre means i should display , otherwise leave that blank or empty Its some urgent requirement ,thanks in advance
Explain the use of indexes option in exp command.
What is a Shared SQL pool ?