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 are the limitations of check constraint?
Describe varray?
What is cursor
How to drop an index?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How do we display rows from the table without duplicates?
How to pass parameters to procedures in oracle?
What is a sub query and what are the different types of subqueries?
How does oracle handle read consistency?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
what is the syntax of CREATE command?