What is using clause and give example?
No Answer is Posted For this Question
Be the First to Post Answer
What is archive log in Oracle?
How to Select second Maximum salary in a Table ?
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 can return max date row A b c d e 1 2 1-mar-09 5 10 1 2 10-mar-09 5 10 Only using oracle predefined function. Not user defined. Output:-- A b c d e 1 2 10-mar-09 5 10
What are the uses of synonyms?
How to use fetch statement in a loop?
How would you go about verifying the network name that the local_listener is currently using?
4. Using a set operator, display the creditor number of all creditors who have ever been paid.
How to drop a tablespace?
How to use regular expression in pattern match conditions in oracle?
How are the index updates?
How can we find out the duplicate values in an oracle table?