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
Why do we use bulk collect in oracle?
IS it possible to built the oracle database without setting the kernal parameters?
what is trigger?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How to execute a stored procedure in oracle?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
how to retrieve data from different tables ,place this data in different excel worksheets.
What is the difference between alert log file and trace file ?
Is the After report trigger fired if the report execution fails ?
Explain a segment?
SQLERRM is a a. Constraint b. Pre Defined Exception c. Pseduocolumn d. Constant e. None of Above.