Which sql statement is used to delete data from a database?

0 Answers  

---

What is $$ 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 a schema? How is it useful in sql servers?

0 Answers  

---

1) Synonyms 2) Co-related Subquery 3) Different Jobs in Plsql 4) Explain Plan 5) Wrap 6) Query Optimization Technique 7) Bulk Collect 8) Types of index 9) IF primary key is created then the index created ? 10) Foreign Key 11) Exception Handling 12) Difference Between Delete and Trunc 13) Procedure Overloading 14) Grant Revoke 15) Procedure Argument types. 16) Functions. 17) Joins

0 Answers   CTS,

---

when a procedure /package is getting invalidated?

4 Answers   TCS,

---

Can we have two clustered index on a table?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---

How many rows can sqlite handle?

0 Answers  

---

I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?

2 Answers  

---