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
- 4984 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 the recommended interval at which to run statspack snapshots, and why?
What is oracle data type?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to convert numbers to characters in oracle?
What do you mean by merge in oracle and how can we merge two tables?
select * from emp what happened internally when we write this query in the sql prompt?
I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.
Explain the use of show option in imp command.
what is reindexing?
How to use select statement to count the number of rows in oracle?
What happens in oracle commit?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Oracle General 
