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
- 5199 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 we create more than one index on particular column?
What is the difference between an Oracle Schema and an Oracle Instance?
What is the implicit cursor in oracle?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How view is different from a table?
how the indexes are stored in the Oracle Database?
what is primary key and foreign key when and where have to use
ABOUT IDENTITY?
What is the difference between a user and a schema in oracle?
Can we create trigger on materialized view in oracle?
How many types of database triggers exist?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
Oracle General 
