Answer Posted / pavan_1981

sql is a universally accepeted query language whic acts an
interface to the relational databases to fetch,insert and
manipulate the data existing in the database.
sql encompasses of five parts
1.Data Retrieval Language:the commands used to select data
from the database.this includes
a.select
2.Data manipulation Language:commands to manipulate the
data existing in the database.commands in this are
a.insert
b.update
c.delete
d.merge
3.Data Definition Language:commands to define and create
the database ojects like tables ,views etc.commands in this
are
a.create
b.truncate
c.alter
d.drop
e.describe
f.rename
4.Tranaction control Language:the commands in this are
a.grant
b.revoke
5.Data Control Language:the commands in this are
a.Commit
b.Rollback
c.Savepoint.

how to handle exceptions in post production

1429

---

What is the maximum limit on the number of columns in a table?

1089

---

What are the parameters that we can pass through a stored procedure?

1067

---

How to convert raw data type into text in oracle? Explain

994

---

Explain coalesce function?

1207

---

How to find out what oracle odbc drivers are installed?

1043

---

Explain what are the different type of segments?

969

---

How do you store pictures in a database?

1008

---

How to experiment a data lock in oracle?

1057

---

Explain oracle left join with an example?

1018

---

various types of hints and their usage

2699

---

How to use null as conditions in oracle?

1084

---

How do I recompile a procedure in oracle?

964

---

What are internal user account in oracle?

1011

---

What do you mean by merge in oracle and how can you merge two tables?

949

---