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
Explain what are the characteristics of data files?
What are the commands youd issue to show the explain plan for select
How to install oracle database 10g xe?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
Explain what does a control file contain?
How to run queries on external tables?
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
How to find no of saturdays in a month using single sql ?
What is a named program unit?
What is SYSTEM tablespace and When is it Created?
How to define an external table with a text file?
What a SELECT FOR UPDATE cursor represent.?