How to drop an existing table in oracle?
structural difference between bitmap and btree index ?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
What suggestions do you have to reduce the network traffic?
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
Can multiple columns be used in group by in oracle?
What is using clause and give example?
Explain an exception?
What is an Extent ?
What WHERE CURRENT OF clause does in a cursor?
How to check the server version in oracle?
Why do we need oracle client?
what is the difference between substr and instr function in oracle?