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.
- 1 Answers
- 2085 Views
- I also Faced
- E-Mail Answers
Answer Posted / Durg Singh
Here's an example shell script that does what you asked:nn```bashn#!/bin/shnexport ORACLE_SID=your_database_namenecho 'Connecting to database as SYS...' ; sqlplus / as sysdba << EOFndatenALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY HH24:MI:SS';ndrop table your_table_name cascade;ndatenEOFnecho 'Exiting...' ; exit" Replace 'your_database_name' and 'your_table_name' with the actual database name and table name, respectively.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
