How to assign query results to variables?
What is a table in oracle?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?
What is a nvl function? How can it be used?
Name the various constraints used in oracle?
What is rich query?
How does oracle handle read consistency?
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
Explain the use of file option in exp command.
When can Hash Cluster used ?
what is difference between DBMS and RDBMS?
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?