What is the difference between syntax error and runtime error?

0 Answers  

---

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

---

What is a temporal data type?

0 Answers  

---

How do I make sql search faster?

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 the difference between count 1 and count (*) in a sql query?

0 Answers  

---

Why are aggregate functions called so?

0 Answers  

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?

0 Answers   MCN Solutions,

---

What language is oracle sql developer?

0 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

how do you control the max size of a heap table? : Sql dba

0 Answers  

---