How to return more than one value from a function?
Answer Posted / prajwal maloo
USING OUT AND REF PARAMETERS
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can we call stored procedure in function?
Can dml statements be used in pl/sql?
Define concurrency control. : Transact sql
What is sql trigger example?
Can I copy :old and :new pseudo-records in/to an oracle stored procedure?
What is the use of double ampersand (&&) in sql queries? Give an example
Explain the select statement in sql?
What is the usage of distinct keyword?
What is mutating error?
how do you know the version of your mysql server? : Sql dba
Can we use commit inside a trigger?
What is varray in pl sql?
what is the use of friend function? : Sql dba
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
what are the advantages of sql ? : Sql dba