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?
- 2 Answers
- 7401 Views
- HSBC, I also Faced
- E-Mail Answers
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 |
how to get a list of indexes of an existing table? : Sql dba
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is dml and ddl?
What is an invalid partition table?
What are field types?
what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba
What is the criteria while applying index to any column on any table.
How would you convert date into julian date format?
What is rank function in sql?
If the base table structure is changed what will happen to join index????
What is the need of merge statement?
How does sql store data?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
