PARAMETERS <p>[(<length>)] [TYPE <type>|LIKE <obj>]

Write a simple Store procedure and pass parameter to it ?

Question Posted / krishna

3 Answers
7742 Views
Keane India Ltd, I also Faced
E-Mail Answers

Answer Posted / krishna

PARAMETERS <p>[(<length>)] [TYPE <type>|LIKE <obj>]
[DECIMALS <d>]
[DEFAULT <f>]
[MEMORY ID <pid>]
[LOWER CASE]
[OBLIGATORY]
[VALUE CHECK]
[AS CHECKBOX]
[RADIOBUTTON GROUP <radi>]
[NO-DISPLAY]
[MODIF ID <key>].

Is This Answer Correct ?

0 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is tns name?

975

How many memory layers are in the oracle shared pool?

1174

what are steps for interface? where is exchange rate defined in which table?

2148

what is a Nested Loop join?

2103

What is the difference between primary key and unique key and foreign key in oracle?

969

What are the set operators union, union all, minus & intersect meant to do?

983

What is execute immediate in oracle?

1012

How to put more than 1000 values into an oracle in clause?

1028

Can you tell me how to add new column in existing views?how?How is possible?

1432

Can we commit inside a function in oracle?

954

What is a initialization parameter file in oracle?

1029

How to export several tables together?

1046

How to drop a stored procedure in oracle?

1049

What is the data type of dual table?

990

Which environment variables are absolutely critical in order to run the OUI?

2114