What are triggers in oracle?
No Answer is Posted For this Question
Be the First to Post Answer
what is difference between foreign key and reference key
How to create an oracle database manually?
1.display list of all users from ur data base.what is the query?
material view and view disadvantages?
What is Database Link ?
What are the factors causing the reparsing of SQL statements in SGA?
What is a Shared SQL pool ?
what is the exact definition for pointer?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
Explain table?
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.
Can group functions be used in the order by clause in oracle?