Interested to Buy Any Domain ? << Click Here >> for more details...
What is rowid and rownum in oracle?
- 0 Answers
- 1068 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What are the commands youd issue to show the explain plan for select
State the difference between a primary key and foreign key?
Why do we need integrity constraints in a database?
What is the difference between an Oracle Schema and an Oracle Instance?
What is the difference between truncate & delete command?
How can I introduce multiple conditions in like operator?
Explain what are clusters?
What is an Integrity Constrains ?
Explain overloading. Can functions be overloaded?
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.
Differnce between view and index
What is the difference between implicit index and explicit index?
Oracle General 
