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]
Answers were Sorted based on User's Feedback
What is meant by raw datatype?
What are the numeric comparison operations?
what is the output of select * from emp where null=null & select * from emp where 1=1
What is the oracle implicit cursor?
Explain index?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.
5 Answers Microsoft, Oracle, TCS,
How many types of database triggers exist?
How to get execution statistics reports on query statements?
How to connect to a remote server?
What happens to the indexes if a table is recovered?
What is the difference between alert log file and tarce file ?