Store procedure can invoke DDL&DML statement and can return value. 2.

what are stored procedures?

Question Posted / jyoti ranjan samal

Answer Posted / jyoti ranjan samal

Store procedure can invoke DDL&DML statement and can return
value.
2.You can also execute one procedure to another procedure.

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can Oracle users be audited?

863

what is dynamic SGA and static SGA

4071

What is hot backup and logical backup?

825

What privilege is needed for a user to create views in oracle?

811

How to insert a record into a table?

849

What are the attributes of cursor?

794

What happens if the update subquery returns multiple rows?

829

How to list all indexes in your schema?

802

What is ordinary table in oracle?

841

How to define a variable of a specific record type?

861

how to clone 9i Database on to 10g Database.

2099

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

1880

Why is oracle used?

724

How to pass a parameter to a cursor in oracle?

862

Can objects of the same schema reside in different tablespace?

806