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.
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 are the uses of Database Trigger ?
What is oracle sid?
What is a proxy class?
What is hash cluster in oracle?
What is the meaning of recursive hints in oracle?
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
Will you be able to store pictures in the database?explain.
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
How to enter a new row into a table interactively?
How to find the date and time of last updated table?
Explain the family trees and connection by clause
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,