Explain the use of file option in exp command.
No Answer is Posted For this Question
Be the First to Post Answer
How many types of cluster table in Oracle?
How to manage transaction isolation level?
What is oracle data type?
What are the oracle differences between nvl and coalesce
What is the difference between online and offline backups?
What language does oracle use?
What is program global area (pga) in oracle?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3 Answer:select length(trim('ram charan singh')) - length (replace (trim ( 'ram charan singh'),' ','')) +1 from dual The above query working properly when space between the words is only one &similar But ,If the space between the words is nonuniform. Ex:'ram charan singh is good' ans:5 i am not getting this answer using above query.
What is a subquery?
How to connect asp pages to oracle servers?
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
What is the recommended interval at which to run statspack snapshots, and why?