Ask the Experts
Ask the Experts
-
Getting total number of rows inserted and updated
-
Telling EXECUTE IMMEDIATE to commit
-
Business Objects as a data warehousing tool
-
Maximun number of columns for a composite primary key
-
Resolving error ORA-06550
-
Checking if varchar2 column contains only numbers
-
Capturing errors from MERGE statement
-
Catching error code that arises in PL/SQL
-
When to use functions and stored procedures
-
Running SQL*Loader from within PL/SQL procedure
-
Resolving the "The instance Oracle VTDBS has been Terminated" error
-
Resolving the TNS-12502 error
-
Will tablespace show more free space after deleting records?
-
Sequence of user process, server process, instance and session
-
Transposing rows and columns in a SELECT statement
-
Resolving an IMP-00002 error
-
ON DELETE in a many-to-many relationship
-
Using SQLLDR, EXPORT and IMPORT from a client machine
-
Sending email from a stored procedure or trigger
-
Oracle.exe taking 99% of CPU
-
Table comparison stored procedure very slow
-
Errors when running catalog.sql and catproc.sql files
-
Format query output as header and detail lines
-
Benefits, costs of running RAC
Could you address the benefits of running RAC with Oracle database servers running on Sun clusters? Continue Reading
-
Calling a stored procedure from a trigger
-
Lookup table explained
-
Installation error: Java Runtime Environment not found
-
Data dictionary versus the data directory
-
200,000-record load taking too long with SQL*Loader
-
Getting IP address, version, server names, etc. with SQL
-
Oracle's equivalent of SQL Server's TOP command
-
Trigger that will not fire when certain column is updated
-
Extracting ddl for a view
-
Querying a system table to get primary key info about a column
-
Using dblink when defining cursor in PL/SQL routine
-
Rows with consecutive dates
-
Selecting all months even if they're missing
-
Performing a dynamic search with the "any" option in SQL
-
Does SERIAL# change during session?
-
Using trigger predicate UPDATING on a column
-
Spooling result set into file without the newline character
-
Hashing functions explained
-
Export error exp-00002
-
Calculate an end date from a start date
-
Using a WHERE... IN clause in a comma delimited field
-
Bulk inserts
-
DIRECT=Y versus DIRECT=N when importing
-
Moving indexes from one tablespace to another
-
Count males and females as well as total
-
Can't open dump file using IMP
-
Setting GLOBAL_NAMES to false to use dblink
-
Disabling and enabling triggers
-
Practicing Oracle commands online
-
Alphanumeric primary key
-
Composite primary keys and indexes
-
Calculating next extent size
-
Inserting values from one table into another, with another set of values
-
OUTER JOIN instead of a NOT EXISTS subquery
-
Calculating weeks between two dates
-
How to validate zip code, city, and state code
-
What is the file extension of an Oracle database?
-
What values can be deduced from sys.dual?
-
Full outer join in a many-to-many relationship, part 1
-
X$KGLOB not visible
-
Migrating data from DB2 to 9i
-
Are left outer joins messing up the optimizer?
-
Defragmenting a tablespace to free up contiguous space?
-
Does Oracle log disconnections?
-
Storing .pdf files inthe database
-
Writing a Java tool to analyze redo log file
-
How to retrieve a DB2 date in Julian format
-
When does OSUSER in V$SESSION = Oracle?
-
Inserting the '&' symbol in a string
-
Adding a new NOT NULL field to an existing table
-
Are hyphens allowed in standard SQL column names?
-
Trigger to update TABLE 2 with TABLE 1 updates
-
Searching with multiple keywords
-
Importing a SQL Server table into Oracle
-
Comparing two tables
-
Preventing duplicate entries on multiple columns
-
Nested tables in MySQL
-
One query to return disjoint sets (MySQL)
-
Summing across columns
-
Sort order of composite primary keys
-
What is the default tablespace?
-
RAID and multiplexing
-
Loading data from Oracle into flat files
-
Killing the session through an AFTER LOGON trigger
-
Joining tables that have composite primary keys