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 ?
2044What 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 5444Table1- 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 5264Two 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 4140Post New Oracle General Questions
What are data pump export and import modes?
Can we write dml statement in function in oracle?
What is format trigger?
How to use "in" parameter properly?
How to compare dates in oracle sql?
Explain the difference between replace() and translate() functions in oracle?
What are the extensions used by oracle reports?
What is BBED in Oracle?
Explain rename?
How to rename an existing table?
How to filter out duplications in the returning rows using oracle?
Explain compound trigger in oracle?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is backup in Oracle?
What is an oracle cursor variable?