Answer Posted / chandra shekhar

Dear Pushkar, SQL*PLUS commands are not used to manipulate the data in tables. Its DML commands in SQL are used to manipulate the date in the table like INSERT, UPDATE, DELETE, MERGE.

Table definition commands comes under DDL commands like CREATE, ALTER, DROP, TRUNCATE.

Some of the Attributes of SQL*PLUS commands are
1. It need not be terminated by semi colon
2. It can be abbreviated
Eg:- DESCRIBE can be written as DESC
APPEND can be written as a
RUN can be written as r

regards
j

Give the order of sql select?

1179

---

What does count (*) mean?

981

---

Can you have a foreign key without a primary key?

995

---

How many types of index are there?

1098

---

Why is the cursor important?

1076

---

Which command is used to call a stored procedure?

1047

---

differentiate between float and double. : Sql dba

1104

---

What is structural independence and why is it important?

1071

---

Show code of a cursor for loop.

1104

---

What is sql profiling in oracle?

1125

---

how would you enter characters as hex numbers? : Sql dba

1031

---

hi,i plan to put experience on PLSQL ,can anyone suggest me for any institutes in bangalore or how to prepare for interviews

2056

---

Define implicit and explicit cursors.

1202

---

What are sql functions? Describe the different types of sql functions?

1206

---

Can we create index on primary key?

1016

---