Can we create trigger on materialized view in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
How to connect to a remote server?
What is background process in Oracle?
What are the restrictions in a oracle read only transaction?
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.
How do we represent comments in oracle?
What are the different editions of oracle?
How to import one table back from a dump file?
Query to retrieve record for a many to many relationship ?
What happens to indexes if you drop a table?
What is the usage of synonyms?
Is it possible to insert comments into sql statements return in the data model editor ?
What is Java Pool in Oracle?