can a table has a column that has only view data and in other columns we can c

can a table has a column that has only view data and in
other columns we can change data?

Question Posted / subhakanta.senapati

2 Answers
4159 Views
Secon, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

can a table has a column that has only view data and in other columns we can change data?..

Answer / thiru

Yes. We can build a sequence generator value to a column in
a table then next columns can be handled with SQL queries.

Is This Answer Correct ?

1 Yes

2 No

can a table has a column that has only view data and in other columns we can change data?..

Answer / 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

Is This Answer Correct ?

0 Yes

1 No

Post New Answer