Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2979 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 |
How to see the table columns used in an index?
How to convert character types to numeric types?
I know that i can create a table without a primary key.But is there any significance for that table???? while creating an application.
How to connect to the server with user account: sys?
How many types of cluster table in Oracle?
Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table
What are the four Oracle system processes that must always be up and running for the database to be useable?
What is the quickest way to export a table to a flat file?
Explain what are the characteristics of data files?
5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.
What are the Limitations of a CHECK Constraint ?
How to revoke create session privilege from a user in oracle?
Oracle General 
