What are the differences between primary key and unique key?
- 0 Answers
- 728 Views
- I also Faced
- E-Mail Answers
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
What's dateware house and what's clustor with practicle example
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
What are the Limitations of a CHECK Constraint ?
what is pragma?
how can we store any pdf file in oracle
what is the difference between substr and instr function in oracle?
what is mean by prmary key and foreign key and how can we diffrentiate that? Please answer me. Advance thanks.
How can you use check constraints for self referential integrity?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What are the components of logical database structure in oracle database?
what is the use of rank function?
Oracle General 
