can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

What is rowtype?

0 Answers  

---

what is inline command?

2 Answers  

---

wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

What is mutating error in pl sql?

0 Answers  

---

What are the advantages and disadvantages, compared to the standard SQL and SQL*plus ?

2 Answers  

---

What is sql key?

0 Answers  

---

What are the set operators in sql?

0 Answers  

---

Why is sql important?

0 Answers  

---

Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,

---