Give an example of any procedure.
Answer Posted / nagendra
put_line is an example of procedure
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what is the use of set statement in tsql? : Transact sql
Is primary key clustered index?
Explain what is an index?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Can we rollback delete command?
What are sql injection vulnerabilities?
is it possible to pass an object or table to a procedure as an argument?
how to convert numeric values to character strings? : Sql dba
How to use sql*plus built-in timers?
What are the triggers associated with image items?
Are sql connections encrypted?
What is count * in sql?
When is a declare statement required?
What is a behavioral trigger?
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