How to execute multiple sql statements in a single annonymous
block irrespective of the sql statement result?
Answers were Sorted based on User's Feedback
Answer / krina
we can execute multiple sql statement inside the procedure
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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
| Is This Answer Correct ? | 0 Yes | 1 No |
I WANT INFORMATION ABOUT SAS SOFTWARE USING FINANCIAL COMPANIES LIST, PLESE GIVE ME DETAILS ABOUT
What are data types in pl sql?
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What is crud stand for?
What does data normalization mean?
Which software is used for pl sql programming?
how to create a new view in mysql? : Sql dba
What is a database trigger?
what is “go” in t-sql? : Transact sql
What is Referential Integrity?
I need a function for a train ticket reservation please answer it thanks in advance
What is sqlexception in java?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)