what is the difernece between named and anonymous pl/sql
blocks??
Answer Posted / amarnath
Yes, above and r correct, here one point to observe evry
one, what is the important of annonimous block, y oracle
provide us.
is any one provide correct ans for this??
| Is This Answer Correct ? | 3 Yes | 5 No |
Post New Answer View All Answers
Why do you partition data?
What is sql and how does it work?
Why partition by is used in sql?
What is pivot in sql?
Why functions are used in sql?
What is the difference between delete, truncate and drop command?
Explain what is sql*plus?
Hi how to import oracle sequence in Informatica? Please write stored procedure code that will import oracle sequence in Informatica SP transformation as per below scenario Oracle table product list Pro_id, pro_name 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights Now a new flat file with new product list needs to be added to oracle table product list with oracle sequence. flat file product Prono,pro_name, 1, 20 watt tube light 2, 30 watt tube light & target should be like 101, LED Lights. 102, 20watt CFL Lights. 103, 30 watt CFL lights. 104, 20 watt tube light 105, 30 watt tube light thks reg suvarna joshi suvarnaatsuvarna@rediffmail.com
How do I save the results of sql query in a file?
Explain the the delete statements in sql?
What is sorting in sql?
What is the difference between union and union all command?
What is t sql in sql server?
Which is better join or subquery?
what is union, minus and interact commands? : Sql dba