What privilege is needed for a user to create views in oracle?
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
What is the data type of dual table?
when i run my query on yesterday it is fast but today it is slow why?
How to use like conditions in oracle?
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
What is a initialization parameter file in oracle?
How to add a new column to an existing table with a default value?
How to convert dates to characters in oracle?
How to check database size in Oracle?
What happens if variable names collide with table/column names?
What are the different types of record groups in oracle? Explain each of them
What is meant by raw datatype?