Simple question on how to insert record?

[oracle newbie]

How to create a pl sql program which enable to insert record into database?

Can anyone can give details or steps in creating a pl sql program which enable to insert record into database using the Oracle SQL Developer program?

Please help me....

Thank you!!

[debasisdas]

Hi
oracle newbie
Welcome to TSDN.

You have reached the right place for knowledge shairing.

Here you will find a vast resource of related topics and code.

Feel free to post more doubts/questions in the forum.

But before that give a try from your side and if possible try to post what/how you have approached to solve the problem.

It will help Experts in the forum in solving/underestanding your problem in a better way.

Please follow the posting guidelines in every new post/reply.

Don't expect complete code here .

First u need to post what is your problem and how/what u have tried to solve it.

[oracle newbie]

Ok Thanks.

Just 1 question: Can Oracle SQL Developer be use to create a PL SQL PROGRAM to insert record?

Yes or No.

[debasisdas]

U can try this sample code to create a procedure to insert record to a table
================================================== ====

CREATE OR REPLACE PROCEDURE DEPTINS
(
DNO DEPT.DEPTNO%TYPE,
DN DEPT.DNAME%TYPE,
LC DEPT.LOC%TYPE
)
IS
BEGIN
INSERT INTO DEPT VALUES(DNO,DN,LC);
DBMS_OUTPUT.PUT_LINE('ONE ROW INSERTED......!');
COMMIT;
EXCEPTION
WHEN DUP_VAL_ON_INDEX THEN
DBMS_OUTPUT.PUT_LINE('DUPLICATE VALUE......!');
END;
 

Note:--It is also possible to insert record without writing any procedure ,on with the help of an anonymous block.

[debasisdas]

Try the sample code to get your answer.

[oracle newbie]

debasisdas Thank You for your sample code.

Can the codes be use using Oracle SQL Developer.

Because, there's a error at the DNO.

[debasisdas]

can you please post what exactly is the error that you are getting.

[oracle newbie]

PL/SQL: Compliation unit analysis is terminated at the line of Create or replace

PLS-00201: Identifier DEPT.DEPTNO must declared at the line of DEPT.DEPTNO%TYPE,


Thanks. I hope I wouldn't trouble you.

[debasisdas]

since it is a sample code

try executing in scott schema


and check for the the existance of the default DEPT table.

[oracle newbie]

I will try to do it.

Do you have any websites to recommend on creating pl sql program using Oracle sql developer ?

Once again Thanks.

[debasisdas]

You can use this link for some demo programs. That You may find useful.