Why do we use function in pl sql?

0 Answers  

---

Difference between table function and pipelined function?

0 Answers  

---

What is the difference between local variables and global variables?

0 Answers  

---

table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

what are properties of a transaction? : Sql dba

0 Answers  

---

Is json a nosql?

0 Answers  

---

What are the disadvantages of not performing database normalization?

0 Answers  

---

What is foreign key in sql with example?

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,

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---