Home » SQL & PL/SQL » SQL & PL/SQL » how to create a table
how to create a table [message #19055] Wed, 27 February 2002 02:02 Go to next message
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..
Re: how to create a table [message #19057 is a reply to message #19055] Wed, 27 February 2002 02:08 Go to previous messageGo to next message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
u got to write trigger
Re: how to create a table [message #19087 is a reply to message #19057] Wed, 27 February 2002 23:08 Go to previous message
slamt
Messages: 3
Registered: February 2002
Junior Member
loe nggak ada kerjaan (nganggur) kerja cuman ngejawab mail orang... norak loe
Previous Topic: Restrict SQL connection from Client
Next Topic: Update lasting a very long and unasual time
Goto Forum:
  


Current Time: Thu Mar 28 19:02:56 CDT 2024