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