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


Please Help Members By Posting Answers For Below Questions

What is pl/sql language case sensitive?

631


Are pl sql variables case sensitive?

590


what is the difference between truncate and drop statements? : Sql dba

552


What is record type in pl sql?

542


What is the difference between database trigger and stored procedure?

553






what are tables and fields? : Sql dba

577


What is difference between sql and oracle?

560


what are date and time functions in mysql? : Sql dba

530


What are the uses of sysdate and user keywords?

624


What are the types of sql commands?

548


what are the differences among rownum, rank and dense_rank? : Sql dba

536


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

2067


What is the use of prepared statement?

536


What is the difference between nested table and varray?

516


What is a field in a database?

566