How do we get field detail of a table?
No Answer is Posted For this Question
Be the First to Post Answer
What are a collation and state the different types of collation sensitivity?
What is parameterized cursor in oracle?
What is SYSTEM tablespace and When is it Created?
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.
find the second highest salary of the emp table
What is autonomous transaction?
Explain the characteristics of oracle dba?
How to resolve the ORA-39133 error in Oracle?
How to create an oracle database?
Explain table?
Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.