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 6111why should i declare foreign key constraint as self relation instead of binary relation in tables ?
2043What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
1 4595Table1- 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 5443Table1- 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 5263Two 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 4139Post New Oracle General Questions
What are the advantages of oracle?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What to do if the startbd.bat failed to start the xe instance?
Is java required for oracle client?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is the exact use of Collections?
How to put more than 1000 values into an oracle in clause?
What is blob data type in oracle?
Whats the benefit of dbms_stats over analyze?
What happens to indexes if you drop a table?
What is Redo Log Buffer in Oracle?
How to invoke the data pump import utility?
How are extents allocated to a segment?
What is concurrency in oracle?
How different is ms access and oracle?