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
- 2980 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 revoke create session privilege from a user in oracle?
How to count duplicated values in a column in oracle?
Whatz the main diff between Subquery and a Join
14 Answers Oracle, Zeta Interactive,
How to create a new oracle data file?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
Is oracle an open source?
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
WHAT IS ecc 6.0
without using count(*) and rownum how can we count total record in a table
What is oracle rownum?
What is the difference between primary key and unique key and foreign key in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
Oracle General 
