Tips

Tips

• Joining tables in SQL queries

  Discusses how to join tables in SQL Server queries.  Continue Reading

• Find what each Oracle process is doing

  Here is a handy script that will correlate the operating system process with the Oracle process.  Continue Reading

• Truncate tables using PL/SQL

  This tip truncates data from tables using PL/SQL for Oracle8i.  Continue Reading

• Growing up, and out: Opportunities expand for people willing to put time and effort into learning ne

  Hot skills include knowledge of operating environments, people skills, networking smarts and Web-ifying the mainframe.  Continue Reading

• Duplicate Oracle installation

  A procedure to install a duplicate Oracle database when typical installation via CD-ROM is not possible.  Continue Reading

• Script to include users in the PRODUCT_USER_PROFILE table

  This script generates a script that includes users in the table PRODUCT_USER_PROFILE table.  Continue Reading

• Small servers to have big role in data centers of the future

  A panel of experts makes some predictions for the near future of data centers.  Continue Reading

• Refresh value of a global variable only after commit

  Refresh a value of a global variable only after a commit.  Continue Reading

• Find duplicate queries

  This query prints out duplicate queries submitted by the same user, identified by v$session.client_info.  Continue Reading

• Problems with the DUAL table

  Check the DUAL table to avoid problems with Oracle Applications.  Continue Reading

• Control users' access to Oracle objects from SQL*Plus

  The PRODUCT_USER_PROFILE table can be used to control users' access to various Oracle objects from SQL*Plus.  Continue Reading

• Tablespace monitor for autoextend

  Tablespace monitor for autoextend  Continue Reading

• Trimming a string in versions before 8i

  Here is a utility function that combines the LTRIM and RTRIM for pre-8i shops.  Continue Reading

• Secure import/export user

  Avoid the security problem of putting passwords in script files for privileged users.  Continue Reading

• Use the name of current database in queries

  Query the GLOBAL_NAME view in Oracle to get the database name on which your SQL is being executed.  Continue Reading