Why do we need oracle client?
No Answer is Posted For this Question
Be the First to Post Answer
How to join two tables in a single query using oracle?
What are the different pseudo commands? Explain in general?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
How do we create privileges in oracle?
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
Differentiate between function and procedure in oracle.
What are the execution control statements?
What is Trace File ?
What is a sub query? Describe its types?
Explain drop constraint oracle?
How to manage transaction isolation level?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me