Q&A Categories

Stored-Procedures

Why the stored functions can not be called from DML Statements? Why cant we modify the database by

Why the stored functions can not be called from DML Statements? Why cant we modify the database by function? '

Answers No Answers In: Stored-Procedures By: claire [1 Grey Star Level] Sep 7, 2010

What is the use of Ref cursor, how it is diifferent than the normal cursor.

What is the use of Ref cursor, how it is diifferent than the normal cursor. '

Answers No Answers In: Stored-Procedures By: vikas [ Grey Star Level] Aug 31, 2010

What is the difference between stored procedures and stored functions in ORACLE?

What is the difference between stored procedures and stored functions in ORACLE? '

Answers No Answers In: Stored-Procedures By: ramesh [ Grey Star Level] Aug 27, 2010

What is the difference between "IS" and "AS" while creating procedure. Ex:- create

What is the difference between "IS" and "AS" while creating procedure. Ex:- create procedure IS or AS? '

Answers No Answers In: Stored-Procedures By: shoeb [ Grey Star Level] Aug 24, 2010

What is the difference between "stored procedure" and "dynamic SQL" ?

What is the difference between "stored procedure" and "dynamic SQL" ? '

Answers No Answers In: Stored-Procedures By: claire [1 Grey Star Level] Aug 24, 2010

What is stored procedure?

What is stored procedure? A program running in the database that can take complex actions based on the inputs you send it. Using a stored procedure is faster than doing the same work on a client, because...

Answers No Answers In: Stored-Procedures By: neha [ Grey Star Level] Aug 22, 2010

What is PRAGMA AUTONOMOUS_TRANSACTION ? How to use that ?

What is PRAGMA AUTONOMOUS_TRANSACTION ? How to use that ? '

Answers No Answers In: Stored-Procedures By: @mahesh@ [1 Grey Star Level] Aug 21, 2010

What are external procedures ? Why and when they are used?

What are external procedures ? Why and when they are used? '

Answers No Answers In: Stored-Procedures By: ashok [ Grey Star Level] Aug 7, 2010

Input Parameter

Input Parameter How do we pass default value as input parameter in a store procedure?'

Answers No Answers In: Stored-Procedures By: yogesh [ Grey Star Level] Jul 28, 2010

How do you find which procedures are being used in database?

How do you find which procedures are being used in database? '

Answers No Answers In: Stored-Procedures By: yogesh [ Grey Star Level] Jul 17, 2010

Didn't find what you were looking for?

Add your Question to the site.

You must be Logged In to Add a Question.

Not a member yet? Sign Up Now »

Star Points Scale

Earn points for Asking and Answering Questions!

Grey Sta Levelr [1 - 25 Grey Star Level]
Green Star Level [26 - 50 Green Star Level]
Blue Star Level [51 - 500 Blue Star Level]
Orange Star Level [501 - 5000 Orange Star Level]
Red Star Level [5001 - 25000 Red Star Level]
Black Star Level [25001+ Black Star Level]