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

How to create DSN..Explain?

2 Answers   Accenture, BeBo Technologies, Infosys,

---

What is Java Pool in Oracle?

0 Answers   MCN Solutions,

---

1) Does oracle have any table which contain all the exceptions and it's code internally?

0 Answers   CTS,

---

6. Display the client name and order date for all orders using the traditional method.

0 Answers   Wipro,

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

What are the basic element of Base configuration of an oracle Database ?

2 Answers  

---

Is it possible to split the print reviewer into more than one region ?

0 Answers   Oracle,

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---

What is oracle used for?

0 Answers  

---

what is the difference between data migration and production migration.

0 Answers  

---

What is an Extent ?

3 Answers  

---

select statement does not retrieve any records. what exception is raised?

2 Answers  

---