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

What is raw datatype in oracle?

1061

---

How to generate query output in html format?

1047

---

What are the execution control statements in oracle?

1036

---

When do I need to use a semicolon vs a slash in oracle sql?

1031

---

i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)

2266

---

What do you know about normalization? Explain in detail?

888

---

How to run the anonymous block again?

1072

---

What is the oracle implicit cursor?

1010

---

What happens if you lost a data file?

987

---

What is merge in oracle?

1002

---

Can you create a synonym without having a table?

989

---

Explain the use of grant option in exp command.

1012

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

1707

---

what is port in oracle? how is it related to database application.

1897

---

What is columnar storage what is the advantage?

995

---