after tell procedure whole code he asked can i write the
same way in a function

Answer Posted / sandip

Yes please correct your Question it measn we can able to
provide your Questions Answers.


Best Regards,
KR

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 the difference between nested table and varray?

529


What are the usages of sql?

571


Explain about various levels of constraint.

530


Why coalesce is used in sql?

479


How you improve the performance of sql*loader? : aql loader

584






what is the different between now() and current_date()? : Sql dba

532


How many commands are in sql?

537


First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.

1149


Explain mutating table error.

657


What is sql performance tuning?

505


What are stored procedures used for?

543


What is character functions?

562


How can triggers be used for the table auditing?

601


what is single byte over head in oracle..?

1882


What is bulk collect in pl sql?

541