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 a nvl function?

0 Answers  

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...

10 Answers   Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,

---

How to call a stored function with parameters?

0 Answers  

---

select * from emp what happened internally when we write this query in the sql prompt?

5 Answers  

---

What is a deadlock in SQL? How can you prevent it?

1 Answers  

---

When system tablespace is created?

0 Answers  

---

how to get the no employee in each department including the dept which has 0 employee

5 Answers  

---

What is the difference between 10g OEM and 11g OEM?

0 Answers   MCN Solutions,

---

what is the syntax of INSERT command?

7 Answers  

---

What privilege is needed for a user to delete rows from tables in another schema?

0 Answers  

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

0 Answers  

---