Answer Posted / animesh

SQL IS A STRUCTURED QUERY LANGUAGE THROUGH WHICH WE CAN
COMMUNICATE WITH THE ORACLE SERVER AND SQL STATEMENTS ARE
DIVIDED INTO FIVE STATEMENTS i:e. Data defintion language
(DDL) which is used in creating the tables,views. In DDL
create,
Alter,
Drop,
Rename,
Trucate comes.
where as Data Manipulation Language(DML)command is used to
manipulate the data.In DML
Insert,
Update,
Delete,
Merge.
the third one is Data retrieval i:e. the select command
the fourth one is Transcation control i:e.
commit,Rollback,savepoint.
the fifth one is data control language(DCL) i:e.
grant,revoke

How to display employee records who gets more salary than the average salary in the department?

998

---

Name the three major set of files on disk that compose a database in Oracle?

1063

---

Explain the function of optimizer in oracle?

1053

---

How to assign data of the deleted row to variables?

1012

---

Explain the use of rows option in imp command.

1040

---

Can we use bind variables in oracle stored procedure?

897

---

How can we delete duplicate rows in a table?

925

---

What is raw datatype?

1077

---

What is oracle instant client?

969

---

Explain compound trigger in oracle?

985

---

How to drop an index in oracle?

1018

---

What is the difference between Delete, Truncate and Drop in Oracle?

1064

---

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1996

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2412

---

What is the difference between translate and replace in oracle?

1112

---