Interested to Buy Any Domain ? << Click Here >> for more details...
can a table has a column that has only view data and in
other columns we can change data?
- 2 Answers
- 5104 Views
- Secon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What is a data segment ?
Is there any function in oracle similar like group_concat of mysql?
How to rebuild an index in oracle?
How many types of segments in Oracle?
Explain view?
What does sharding mean?
how to find find & delete duplicate rows from two different tables?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
How to connect to oracle using service name instead of sid?
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
How to use in conditions in oracle?
How to enter a new row into a table interactively?
Oracle General 
