How to use "if" statements on multiple conditions?
No Answer is Posted For this Question
Be the First to Post Answer
How to use "if" statements on multiple conditions?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
does the query needs a hint to access a materialized view?
What do you understand by a database object? Can you list a few of them?
Can a primary key contain more than one columns?
What is control file used for?
What is meant by recursive hints ?
What do you mean by group by clause?
Whats the benefit of dbms_stats over analyze?
Explain what are the characteristics of data files?