What is materialized view in sql?

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 online transaction processing (oltp)? : Sql dba

0 Answers  

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

using comand prompt how can import table data and table space with example

2 Answers  

---

What is dba in sql? : SQL DBA

0 Answers  

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

How many triggers can be applied to a table?

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

Why do you partition data?

0 Answers  

---

What is difference between joins and union?

0 Answers  

---

What are Global Temporary tables

3 Answers   IBM, TCS,

---