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 ?
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 is the scripts in data base?
How many categories of data types in oracle?
How do I spool in oracle?
how to find out second largest value in the table
Explain joins in oracle?
What WHERE CURRENT OF clause does in a cursor?
structural difference between bitmap and btree index ?
what is index?
How do I know if oracle client is installed on windows?
After using set unused can we enable the column again to use? Please give me some answers....
What is query image?
How to connect to a remote server?