Provide an example of a shell script which logs into SQLPLUS
as SYS, determines the current date, changes the date format
to include minutes & seconds, issues a drop table command,
displays the date again, and finally exits.
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
What is a Database instance ? Explain?
how to see the data (in unix) using dataset in datastage?
How to load data through external tables?
what is integrity constrains?
How to calculate date and time differences in oracle?
What is blob datatype?
How to view the dropped tables in your recycle bin?
How do you tell what your machine name is and what is its IP address?
In which language oracle has been developed?
How do you store pictures in a database?
Point out the difference between user tables and data dictionary?