how to create a table [message #19055] |
Wed, 27 February 2002 02:02 |
ksr
Messages: 112 Registered: January 2002
|
Senior Member |
|
|
Hi,
i want something like ..
table(col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(20) --here the oracle should automatically concatenate both the column values and insert here when ever i do an insert.
I dont want to use a trigger for this..is there any possibility that oracle will do it automatically...
I will say insert into table (col1,col2) values ('hello','world') .
At this time,i want oracle to concatenate both the column values and place the value in col3 as ('helloworld').
so when i say select * from table,i should get as
col1 col2 col3
-----------------------
hello world helloworld
How to do this..
very urgent..
any help is appreciated..
|
|
|
|
|