CREATE OR REPLACE PROCEDURE pro_name AS --We cna write AS/IS BEGIN DBMS

Give an example of any procedure.

Question Posted / sharath

Answer Posted / sharath

CREATE OR REPLACE PROCEDURE pro_name
AS --We cna write AS/IS
BEGIN
DBMS_OUTPUT.PUT_LINE(’Hello World’);
END;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you rollback after commit?

717

Show the cursor attributes of pl/sql.

775

What is a sql*loader control file?

790

How you improve the performance of sql*loader? : aql loader

752

What are the main features of cursor?

825

When should I use nosql database?

728

Why do we use function in pl sql?

755

What is the most common sql injection tool?

736

What is sql comments?

813

Can a primary key be a foreign key?

750

what is data manipulation language? : Sql dba

702

What is form and report?

712

Why do we use %rowtype & %type in plsql?

786

Can a varchar be a primary key?

697

What is the difference between delete and truncate commands?

691