How to delete all rows a table in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
What is STATSPACK tool?
what are bitmap indexes? How does they work?
How to connect to the server with user account: sys?
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
What do you know about normalization? Explain in detail?
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.
Explain the use of analyse option in exp command.
How can I see all tables in oracle?
Explain the use of owner option in exp command.
Difference between hot backup vs. Cold backup?
what is Single Byte Overhead...?
How index is implemented in oracle database?