Answer Posted / hari kanth

ya,we can create trigger on that table
like as follows
CREATE OR REPLACE TRIGGER key_gen
BEFORE INSERT ON <table_name>
FOR EACH ROW
DECLARE
v_num NUMBER(5);
BEGIN
SELECT seq.nextval INTO v_num from dual;
:new.id:=SAM||LPAD(v_num,3,0);
END;

the <table_name> structure like as follows
(id VARCHAR2(20),
name VARCHAR2(15)
)
now you can just add the records like as follows
INSERT INTO <table_name>
(
name
)
VALUES
(
'&Name'
);
then trigger will fires and automatically it will inserts
into that table with out our knowledge.

NOTE:here "seq" is forward sequence.if it start with 1 and
incremented by 1 then the output will be like as follows

select * from <table_name>

id name

SAM001 TV
SAM002 LCD

How can you use check constraints for self referential integrity?

1017

---

How to get maxsal , minsal, ename department wise in single query

1603

---

What are the attributes of the cursor?

1057

---

How do I know if oracle is installed on windows?

984

---

what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

2234

---

How to view the tablespaces in the current database?

1026

---

What happens if you lost a data file?

1080

---

How to create a table index in oracle?

1184

---

What happens in oracle commit?

1079

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1993

---

What is an oracle and why it is used?

1213

---

What is SQL access advisor in Oracle?

1230

---

What is Undo Management Advisor in Oracle?

1151

---

Give the various rollback segment states.

1089

---

Explain about your project and its relation to the current job position you are applying to?

1075

---