Is there a way to automate sql execution from the command-line, batch job or shell script?
No Answer is Posted For this Question
Be the First to Post Answer
HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM
what is data manipulation language? : Sql dba
write a query to delete similar records in same table
What is the difference between RDBMS and DBMS?
20 Answers Practical Viva Questions, Sapient, Stag Computers,
Can we join more than 2 tables in sql?
Can we use two order by clause in query?
In a table only one column how to update rows
How did you export data from database to excel file.
Can you call pl/sql package functions from within a fast formula?
what is data integrity? : Sql dba
What are sql functions? Describe the different types of sql functions?
Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;