Answer Posted / durgarao k

Create table Employee
(
Employee_Id varchar2(8) Constraint emp_id_pk primary key,
FirstName varchar2(50),
LastName varchar2(50),
DeptID Number(5),
Constraint dept_id_fk Foreign Key(DeptId)
References Department(DeptId)
)

How to omit columns with default values in insert statement in oracle?

1035

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1028

---

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

1034

---

what is the difference between functional dependecy and multilevel dependency?

2444

---

Difference between the “verify” and “feedback” command?

1342

---

Can we insert data in view oracle?

996

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

2099

---

What is the exact use of Collections?

2130

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2333

---

how to do daily transactions with out sql* loader control file regesterd in apps?

1665

---

how do u setup a replication site?

1962

---

What is blob datatype?

1097

---

what happened to the global index when I truncate the data in one of the partition?

2008

---

How to end the current transaction in oracle?

1011

---

How can we find out the duplicate values in an oracle table?

1032

---