Interested to Buy Any Domain ? << Click Here >> for more details...
What happens to the indexes if a table is recovered?
- 0 Answers
- 940 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is pragma restrict_reference in oracle 9i?When we use this?Give me one realtime scenario?
What is the usage of synonyms?
How to define a data field as not null?
How to create an oracle database?
Can a property clause itself be based on a property clause ?
How do you ensure database security?
How to delete an existing row from a table in oracle?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
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.
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are the advantages of Views ?
Oracle General 
