Answer Posted / gourav joshi

hi,
For eg u want to insert 3 data at a same time so u can use
annonyoums block for eg emp_id,Name,Salary u want to insert
data in a table u can use this annoynomous blck

Begin
Insert into table name values(1, 'gourav',2000);
Insert into table name values(2, 'joshi',6000);
Insert into table name values(3, 'ram',4000);
end;

then execute

How to prepare for oracle pl sql certification?

1012

---

How many types of normalization are there?

901

---

What are aggregate and scalar functions?

978

---

What is rowid in sql?

909

---

what are ddl statements in mysql? : Sql dba

1114

---

how to return query output in html format? : Sql dba

1023

---

What is input buffer in sql*plus?

1127

---

how many columns can be used for creating index? : Sql dba

899

---

What is mutating sql table?

1040

---

what is normalization? : Sql dba

1018

---

When you have to use a default "rollback to" savepoint of plvlog?

1125

---

What is the maximum number of columns in sql table?

1089

---

Can we use update in sql function?

1010

---

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

949

---

What is sql exception?

915

---