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

Post New Answer

More Oracle General Interview Questions

What is set verify off in oracle?

0 Answers  


dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

3 Answers  


List the types of joins used in writing subqueries?

0 Answers  


How to apply filtering criteria at group level in oracle?

0 Answers  


How to put more than 1000 values into an oracle in clause?

0 Answers  






What will be the syntax to find current date and time in format "yyyy-mm-dd"?

0 Answers  


List the various oracle database objects?

0 Answers  


How to create additional tablespaces for an new database?

0 Answers  


How to select some rows from a table in oracle?

0 Answers  


How would you best determine why your MVIEW couldnt FAST REFRESH?

0 Answers  


Tell me New Feature of Oracle 10g?

5 Answers   Thermotech,


what is the difference between simple view and complex view?

13 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)