⟩ Explain How to do the scheduled task/jobs in Unix platform?
Use DBMS_JOB/DBMS_SCHEDULER and give the Job_type as EXECUTABLE and give the path name of the shell script to execute.
Use DBMS_JOB/DBMS_SCHEDULER and give the Job_type as EXECUTABLE and give the path name of the shell script to execute.
Please Explain Connect by Prior?
Explain What is a database link?
Explain Explicit Cursor attributes?
Explain What is a corelated subquery?
Explain How to drop the index?
What is a join in Oracle? Explain the different types of joins?
Explain What are the data types allowed in a table?
Explain How do we replace a comma (,) with a blank in a select statement?
Explain Can a view be updated/inserted/deleted?
Explain What are the different types of SQL?