Interested to Buy Any Domain ? << Click Here >> for more details...
why should i declare foreign key constraint as self relation
instead of binary relation in tables ?
- 0 Answers
- 1982 Views
- Oracle, I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
create one table to capture an employee details with a primary key.
Explain the use of compress option in exp command.
How to call a stored function with parameters?
What is an anonymous block?
Explain enable novalidate constraint.
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 would you do if a database crashes in production?
How to concatenate two text values in oracle?
How to login to the server without an instance?
What is a Shared SQL pool ?
How to create a single index for multiple columns?
How to define a record variable to store a table row?
Oracle General 
