I want a table like,
no name address
addr1 addr2
So i want columns like addr1,addr2 under address column.
Can one please answer me.
Advance Thanks.
- 1 Answers
- 2256 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answer / reddy
create type obj1 as object(addr1 varchar2(30),addr2 varchar2(30)); create type bbb as table of obj1; create tableemployee(no number(9),name varchar2(19), address bbb);
| Is This Answer Correct ? | 1 Yes | 0 No |
What is PL/SQL ?
What is a snapshot in oracle database?
Use of an integrity constraint is better to validate data. Explain
What is the relationship among database, tablespace and data file?
What are joins, explain all types of joins?
How to define a data source name (dsn) in odbc manager?
What are the uses of synonyms?
What is a table index?
what is the syntax of UPDATE command?
What privilege is needed for a user to create indexes in oracle?
How remove data files before opening a database?
State some uses of redo log files?
Oracle General 
