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: 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
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
‘ Comb Sort an array of any type” CombSort is faster than all but QuickSort and close to it.’ On the other hand, the code is much simpler than QuickSort’