Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I want table structure shown below. How can i create this ?
Num Name Address
Addr1 Addr2
I want Addr1 and Addr2 under Address column.
How can i achive this ? Is it possible ?
- 2 Answers
- 5017 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / begum
hi this is really work
create type addr as object (
add1 varchar2(15),
add2 varchar2(15));
/
create table nest1 (
id number(2),
name varchar2(10),
address addr);
insert into nest1 values(10,'uma',addr('10th
main','bangalore'));
/
insert into nest1 values(20,'sami',addr('77g
colony','chennai'));
SQL> select * from nest1;
ID NAME
---------- ----------
ADDRESS(ADD1, ADD2)
--------------------------------------------
10 uma
ADDR('10th main', 'bangalore')
20 sami
ADDR('77g colony', 'chennai')
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / ashok
create table emp(num number(5),name varchar2(14),address
varchar2(15));
insert into emp values('&num','&name','&address');
Enter value for num:
Enter value for name:
Enter value for address: addr1 addr2
old 1: insert into emp values('&num','&name','&address')
new 1: insert into emp values('','','addr1 addr2')
| Is This Answer Correct ? | 1 Yes | 12 No |
What are the differences between char and varchar2 in oracle?
what are the advantages of running a database in archive log mode?
What are the uses of Database Trigger ?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
What is the relation of a user account and a schema in oracle?
Define 'view' advantage ?
How to install oracle odbc drivers?
What is a sub query? What are its various types?
Explain the use of consistent option in exp command.
Is it possible to insert comments into sql statements return in the data model editor ?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
Describe the different type of Integrity Constraints supported by ORACLE ?
Oracle General 
