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

How do I find sql profiler?

509

What are conditional predicates?

582

What are the different type of joins in sql?

540

Can a varchar be a primary key?

534

what are the different type of sql's statements ? : Sql dba

517

What is a system versioned table?

525

Why select is used in sql?

514

What is a table?

563

What is transaction control language (tcl)?

632

What is minus?

541

Can we use the cursor's to create the collection in PL/SQL?

514

Are dml statements autocommit?

548

What is sql*loader and what is it used for? : aql loader

616

how to extract a unit value from a date and time? : Sql dba

552

Explain commit, rollback and savepoint.

599