Can group functions be mixed with non-group selection fields?
No Answer is Posted For this Question
Be the First to Post Answer
Can we create more than one constraint to column ?
What is a dead lock in oracle?
How to view the data files in the current database?
You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.
how to find out second largest value in the table
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
Explain the use of owner option in exp command.
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
Respected sir, Please send me technical questions related to oracle apps..
How to create a new tablespace in oracle?
What is the difference between alert log file and trace file ?
How do we create privileges in oracle?