Why are cursors used?

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,

---

What is multiple columns?

0 Answers  

---

What is the difference between unique and primary key constraints?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

---

Is mariadb a nosql database?

0 Answers  

---

What is sql profiling in oracle?

0 Answers  

---

what does it mean to have quoted_identifier on? : Sql dba

0 Answers  

---

What is the difference between left and left outer join?

0 Answers  

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

How many types of relationship are there?

0 Answers  

---

how would you get the current date in mysql? : Sql dba

0 Answers  

---