What is procedure function?

0 Answers  

---

declare lowerl number:= 1; upperl number:= 3; num varchar2(10); begin for i into lowerl..upperl loop num:=num||to_char(lowerl); if i=3 then upperl:=5; end loop; message(num); What will be the output ?

3 Answers   Oracle,

---

what is a view? : Sql dba

0 Answers  

---

What is linq to sql?

0 Answers  

---

What is full join in sql?

0 Answers  

---

---

What is a trigger word?

0 Answers  

---

What are joins in sql?

0 Answers  

---

What are the types of join in sql?

0 Answers  

---

Can a view be updated/inserted/deleted?If Yes under what conditions?

3 Answers  

---

What is replication id?

0 Answers  

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

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,

---