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')

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')

What is oracle sid?

0 Answers  

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

0 Answers  

---

What are the different types of modules in oracle forms?

0 Answers  

---

Is oracle a relational database?

0 Answers  

---

create one table to capture an employee details with a primary key.

1 Answers   CTS,

---

What is an Index ?

2 Answers  

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

0 Answers   NIC,

---

Why does oracle 9i treat an empty string as null?

0 Answers  

---

What is the recommended interval at which to run statspack snapshots, and why?

0 Answers  

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

3 Answers  

---

what is the scripts in data base?

0 Answers  

---

I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??

1 Answers  

---