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



Hi, I want table structure shown below. How can i create this ? Num Name Address Add..

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

Hi, I want table structure shown below. How can i create this ? Num Name Address Add..

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

Post New Answer

More Oracle General Interview Questions

how can get like this result table A col1 col2 --- ----- a A b B C C .. .. .. ... .. ... wants result like for a single column col1 ------ a,b,c,........n of data and another is col1 ------- A B C D ........ a b b d ........

2 Answers   TCS,


How to delete a column in an existing table in oracle?

0 Answers  


What is data block in Oracle?

0 Answers   MCN Solutions,


Can a Tablespace hold objects from different Schemes ?

3 Answers  


What are advantages of dateset in datastage?

0 Answers   iGate,






How to assign a table row to a record variable?

0 Answers  


Explain the use of constraints option in exp command.

0 Answers  


What is SAVE POINT ?

5 Answers  


What are a cluster and non-cluster index?

0 Answers  


What is tns name?

0 Answers  


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

0 Answers  


How can I get column names from a table in oracle?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)