| |
GeekInterview.com > Interview Questions > Oracle > General
| Print | |
Question: hi how to place different column in on column
eg:if we have address column in that we have to place addr1,addr2,addr3.
|
| March 03, 2009 08:21:20 |
#6 |
| siva14329 |
Member Since: March 2009 Total Comments: 1 |
RE: hi how to place different column in on columneg:if we have address column in that we have to place addr1,addr2,addr3.
|
That time use Abstract Data Type i.e.,
first step create type.
SQL>create type full_add
SQL>( addr1 varchar2(15), addr2 varchar2(15),addr3 varchar2(15));
Second step
Now full_add is abstract type, then add to your table.
SQL>alter table
SQL>add column ( addr full_add);
| |
(Variable) (data type)
If any comments welcome.
|
| |
Back To Question | |
