Answer Posted / rocky-455
1. Store procedure may or may not return a value. If we want to return a value then we need to pass the parameters like INPUT & OUTPUT parameters
2. It can allowed SELECT/INSERT/UPDATE/DELETE Statements. It can be change state of table.
3. It can call Functions, Views, and Procedures inside procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to create tables for odbc connection testing?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to handle a single quote in oracle sql?
Explain the use of record length option in exp command.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
interview questions with answer for cts
what is the difference between functional dependecy and multilevel dependency?
What are the arithmetic operations?
What is Data Dictionary Cache in Oracle?
Explain cascading triggers.
why dont we assign not null constraint as table level constraint.
What are the differences between lov and list item?
How do we get field detail of a table?
What is a nested table and how is it different from a normal table?
