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 6209why should i declare foreign key constraint as self relation instead of binary relation in tables ?
2090What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
1 4682Table1- 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 5571Table1- 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 5376Two 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 4228Post New Oracle General Questions
Briefly explain what is literal? Give an example where it can be used?
What is a data lock in oracle?
What is logical backup in oracle?
How to convert characters to times in oracle?
What is oracle datasource?
What is pragma autonomous transaction in oracle?
Can a formula column be obtained through a select statement ?
What is analyze command used for?
What are the various oracle database objects?
How to create an oracle database?
Difference between varchar and varchar2 data types?
How to drop a stored procedure in oracle?
Explain the use of rows option in exp command.
How to define a variable of a specific record type?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?