What is the implicit cursor in oracle?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
State some uses of redo log files?
What are the built-in functions used for sending Parameters to forms ?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
master table and child table performances and comparisons in Oracle ?
Give the various rollback segment states.
What are advantages of dateset in datastage?
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
how to join query for one source type is oracle another source type is sql server ?
Difference between inner join vs where ?
What are the general rules on data consistency?
Can we protect our pl/sql source code?
How to delete a user account in oracle?
Explain the use of record option in exp command.