While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?
Answers were Sorted based on User's Feedback
Answer / hairreddy
by using cursor attribute cursorname%rowcount we can find how many records fetched
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a join?Explain the different types of joins?
6 Answers Bank Of India, CitiGroup, Google, ICICI, Saama Tech, SkyTech, TCS,
How do you copy a table in sql?
Can we insert in sql function?
Can we enter data in a table in design view?
Does a primary key have to be a number?
Can I learn sql in a week?
Can I join the same table twice?
write a query to remove null following table are id name 101 dinesh null jyothi null bharathi 102 suresh null shilpha 103 prakesh null suma i want the output format like id name 101 dinesh 102 suresh 103 prakesh
What is the difference between the sql*loader and import utilities? : aql loader
If there are 1 to 100 numbers in a table and in that 100 numbers some 10 numbers are deleted.I want to find out the missing numbers between 1 to 100 by pl/sql how?
What are the types of views in sql?
Explain the savepoint statement.
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)