Interested to Buy Any Domain ? << Click Here >> for more details...
How to drop an index in oracle?
- 0 Answers
- 1052 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
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
How to check the server version in oracle?
How to turn on or off recycle bin for the instance?
What are different Oracle database objects?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
How to select the name of employee who is getting maximum sal with out using subquery
How you open and close a cursor variable.Why it is required?
What do you mean by cdb and pdb in oracle 12c?
How to drop an existing table in oracle?
What is a select query statement in oracle?
How can I combine multiple rows into a comma-delimited list in oracle?
What happens to the data files if a tablespace is dropped?
Oracle General 
