Interested to Buy Any Domain ? << Click Here >> for more details...
What is rowid and rownum in oracle?
- 0 Answers
- 954 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
How oracle handles dead locks?
What is merge in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the attributes that are found in a cursor?
Explain the use of tables option in exp command.
How to assign query results to variables?
Explain the concept of the DUAL table.
What happens if you use a wrong connect identifier?
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 what are the uses of rollback segment?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
Oracle General 
