What is different between union and minus?

7 Answers   Accenture, TCS,

---

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,

---

type type_name is table of varchar2(30) index by binary_integer for the above type you have to create a identifier... like identifier_name type_name; for the above type you can use the below methods..like first , last , prior, next , delege..etc...like this.. if you create a cursor...like cursor cursor_name is select * from scott.emp; is there any methods like above to use prior, fist , last , next , trim ,etc...

1 Answers   Satyam,

---

How to call the function and Procedure in trigger?

3 Answers   IBM,

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

Can we use ddl statements in stored procedure?

0 Answers  

---

How do I run a sql query in pgadmin 4?

0 Answers  

---

Why use stored procedures?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

Which software is used for pl sql programming?

0 Answers  

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---