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.
No Answer is Posted For this Question
Be the First to Post Answer
What would you do with an "in-doubt" distributed transaction?
Datapump backup steps?
From the database level, how can you tell under which time zone a database is operating?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.
why we use cursors
Describe what redo logs are.
Which environment variables are absolutely critical in order to run the OUI?
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
what is the purpose of catlaog in oracle rman?
How do you tell what your machine name is and what is its IP address?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)