Tip Bank

Question: When should you use reference to pointers like those found in function arguments (class_name * & )? Answer: When you want the callee to change the pointer itself, not

Oracle 8I gives developers a new feature to allow execution of native dynamic SQL. This is an alternative to the DBMS_SQL package previously required. Now developers can use dynamic SQL

The sp_who internal procedure allows users to view current activity on the database. This command provides a view into several system tables (e.g., syslocks, sysprocesses, etc.). The sp_who command returns

Question: What is the SQL command for retrieving the current date? Answer: The GETDATE() function returns the current date and time. Write it like this: SELECT GETDATE() AS CurrentDateCurrentDate —————————

Question: The table I am using stores date values as strings due to conversion data. The format is 2000-07-01 for July 1, 2000. I need to be able to age

Question: I need a container of different objects. I have made all derived classes of the same base class and pushed them onto the container. The problem then arises in

Question: I am writing a SQL statement in Access that is a union query. I am getting an error saying “The number of columns in the two selected tables or

Question: Can I use computed values from a select list in a WHERE clause? For example: select age + 10 as AGE_10 from employee where AGE_10 > 50 Answer: This

Question: How do I delete a column, and all the values in it? Truncating will delete only the values, not the column itself. And I don’t want to drop the