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.
- 0 Answers
- 1508 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Explain the concept of the DUAL table.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
why we use cursors
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
by issuing "alter tablespace begin backup;" what happens to tablespace?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what are the performance views in an oracle rac environment?
what is the use of ocr?
Which environment variables are absolutely critical in order to run the OUI?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
