Tip Bank

Question: Is there a way to use an INSERT statement inside of a view? If it is not possible through a view, how do I use an INSERT statement? I

Question: I am converting a database from Access to SQL. It is a large database?some 4.5GB large. I get a timeout (1 minute) before I get my response back. Can

Question: As a novice SQL Loader user, I have imported a comma-delimited ASCII file into an Oracle database (Unix) using >sqlldr and specifying the delimiter as a comma. I now

Question: I need a text (or char) field that can hold more than 255 characters. Something like a Memo field to hold almost unlimited character data. Is this possible? Answer:

Question: If a table has a primary key on columns A, B, and C, is there any advantage to also defining an index on columns A and B? Wouldn’t the

Question: We currently have two contact databases in ACT. One of them is growing exponentially and at 70,000 records we are already experiencing problems. We are considering switching to MS

Question: We use Dunn & Bradstreet’s Smart Streem System with a subledger that has a high volume of data, and as of this point has to be identified manually and

Question: My question is simple, yet I can’t seem to find any help on it. I cannot add records to any of the tables in my SQL database. All the

Question: Once a table has been created, is there any way of deleting it in SQL? Answer: Try: DROP TableName