What are the restrictions on external table columns?
No Answer is Posted For this Question
Be the First to Post Answer
Where do we use decode and case statements?
Whats the benefit of dbms_stats over analyze?
What is the diff between Oracle and SQL Server
What does a Control file Contain ?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
Does rowid change in oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What happens to the current transaction if the session is killed?
which sql command we can use to get a print out from oracle?
From the database level, how can you tell under which time zone a database is operating?
i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash
What is a shared pool?