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
2 6210why should i declare foreign key constraint as self relation instead of binary relation in tables ?
2092What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
1 4685Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
HCL,
3 5575Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
HCL,
2 5380Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
1 4230Post New Oracle General Questions
How to insert multiple rows with one insert statement in oracle?
what is a Nested Loop join?
How to pass parameters to procedures in oracle?
Can sub procedure/function be called recursively?
How to open a cursor variable?
How are extents allocated to a segment?
How do I connect to oracle database?
How to initialize variables with default values?
What is connection pooling in oracle?
What is a sub query? Describe its types?
How would you go about verifying the network name that the local_listener is currently using?
How to run create database statement?
What are the types of partitions in oracle?
What is a snapshot in oracle database?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?