Let?s say you have 100,000 records and you want to delete 95,000 at a time and keep only 5 thousand. But in local memory you don?t have enough space for 95,000 records. What do you do in this case? How do you delete without any problem with time and performance?
eBay,
3 10009I need data on eBay customers in Chicago who can did bid on certain item? I dont have access to eBay database directly. How I get the information?
1 8115With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
eBay,
2569Post New Database Management Questions
What is dbms_output put_line?
What do you mean by dml compiler?
What is db context?
What does fill factor concept mean with respect to indexes?
Enlist the types of cursor?
What are five advantages of a database?
How does index hunting help in improving query performance?
What do you understand by query optimization?
What is drivermanager getconnection?
What is concept of dbms?
What is denormalization and why would someone consider doing so?
What is atomicity in dbms?
What are the properties of a database?
What are the advantages of a database?
what is scan listener.