can i use dbms_output.put_line in a function u are telling
as return statement
Answer Posted / manoj
I agree with Babu with that there is no significance of
dbms_output...in the function..
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is pl/sql language case sensitive?
Are pl sql variables case sensitive?
what is the difference between truncate and drop statements? : Sql dba
What is record type in pl sql?
What is the difference between database trigger and stored procedure?
what are tables and fields? : Sql dba
What is difference between sql and oracle?
what are date and time functions in mysql? : Sql dba
What are the uses of sysdate and user keywords?
What are the types of sql commands?
what are the differences among rownum, rank and dense_rank? : Sql dba
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
What is the use of prepared statement?
What is the difference between nested table and varray?
What is a field in a database?