what's query optimization and without use of IN AND Exist can
we get another way data from query
No Answer is Posted For this Question
Be the First to Post Answer
What is a Temporary Segment ?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
The join defined by the default data link is an outer join yes or no ?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
How to list all user accounts in oracle?
How to count groups returned with the group by clause in oracle?
What is Database Buffers ?
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
How to insert a record into 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.
What is the difference between a primary key & a unique key?