What are the built in functions of sql?

0 Answers  

---

How to improve the performance of a pl/sq stored procedures or functions or triggers and packages ?

12 Answers   IBM, TCS, UHD,

---

Give an example of any procedure.

5 Answers   Accenture, iFlex, Wipro,

---

Explain what is sql?

0 Answers  

---

what are date and time functions in mysql? : Sql dba

0 Answers  

---

---

What do you think about pl/sql?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

What are instead of triggers?

0 Answers  

---

Explain Connect by Prior?

2 Answers  

---

What is the difference between an inner join and an outer join?

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,

---

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

---