Can we write insert statement in function in oracle?
how to create a new database in oracle?
what diffrence between function and procedure?
Shall I get Pro*C Compiler in Oracle-10g release ?
How to get a list of all user accounts in the database?
How to export data with a field delimiter?
what is the syntax of DELETE command?
I have query like this. select dept_id, max_mark from stude_dept where min_mark= (select min(mini_mark) from stud_dept); How can i optimize this query. Can anyone help me with it
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
How do we know whether an index is created on a table ???
What is the difference between alert log file and tarce file ?
What is dictionary cache ?
17. Display the order number and average item cost for each order.