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
- 5085 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 |
Can a field be used in a report without it appearing in any data group ?
Draw E-R diagram for many to many relationship ?
Can multiple columns be used in group by in oracle?
How to convert characters to numbers in oracle?
Explain integrity constraints?
How to import one table back from a dump file?
How to declare a local variable?
How to load a large xml file?
What is ordinary table in oracle?
What are the general rules on data consistency?
how to handle exceptions in post production
HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT
5 Answers College School Exams Tests, DELL,
Oracle General 
