What are the components of logical database structure in oracle database?
Explain index?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
Differentiate between TRUNCATE and DELETE?
Ho to insert no. of records at a time..i mean i want to insert 100 records at a time into a table
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
How to delete an existing row from a table in oracle?
What is the quickest way to fetch the data from a table?
Can we call a trigger inside a function and function inside a trigger? Give example.
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
What is the purpose of a cluster?
How to get maxsal , minsal, ename department wise in single query
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?