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

Why do you create or replace procedures rather that drop and recreate.

1006

Can the query output be sorted by multiple columns in oracle?

992

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

953

How to create id with auto_increment on oracle?

990

How does Oracle guarantee data integrity of data changes?

2388

What are the uses of synonyms?

1138

How does the on-delete-cascade statement work?

1104

What do you know about normalization? Explain in detail?

951

How to generate query output in html format?

1118

What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.

979

How to use select statement to count the number of rows in oracle?

1044

Explain the use of compress option in exp command.

1021

Explain what are the type of synonyms?

1112

What do you mean by a tablespace?

1039

How to create a table index in oracle?

1134