Can group functions be used in the order by clause in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
does the query needs a hint to access a materialized view?
Hi how Can I Add A Foreign key that references a table that has composit primary key ? example i had costumer table that has C_Id and SSN Both as PK and another table has C_Id that must refernece C_Id in Customers i done the usual way and got oracle error message about uniqeness any ideas plz
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
How to convert the date format from dd/mm/yyyy to mm/dd/yyyy. (for eg). 22/05/2008 to 05/22/2008. when u use to_char(), it tells the month is invalid. how to resolve this problem.tel with eg.
What is RULE-based approach to optimization ?
What is raw datatype?
What is system tablespace?
Explain the difference between sql and oracle?
How to add a new column to an existing table with a default value?
select * from emp what happened internally when we write this query in the sql prompt?
How to create a table index in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.