what is meant by magic query
No Answer is Posted For this Question
Be the First to Post Answer
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
Can a field be used in a report without it appearing in any data group ?
How to connect ms access to oracle servers?
Can we call a trigger inside a function and function inside a trigger? Give example.
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
What are the different types of trigger and explain its various uses and functions?
find the second highest salary of the emp table
Give the Types of modules in a form?
Can a formula column be obtained through a select statement ?
Explain index?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
Table E: Name dept month sal 1 A JAN 800 2 B APR 1000 3 A JAN 300 4 A JAN 600 5 C JUN 400 1) SELECT HIGHEST SAL PAID DEPT IN JAN MONTH? 2) WRITE QUERY GET MAX SAL DEPT NO?