what is the difference between stored procedure and packaged procedure

1 Answers   Google, Infosys,

---

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 tsql statements can be written and submitted to the database engine? : Transact sql

0 Answers  

---

what is autonomouse transaction?

3 Answers   Oracle,

---

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

4 Answers  

---

---

Which table is left in join?

0 Answers  

---

what is a stored procedure? : Sql dba

0 Answers  

---

what is a relationship and what are they? : Sql dba

0 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

how to write date and time literals? : Sql dba

0 Answers  

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---