Ask the Experts
Ask the Experts
-
Export error exp-00002
-
Calculate an end date from a start date
-
Bulk inserts
-
Using a WHERE... IN clause in a comma delimited field
-
Moving indexes from one tablespace to another
-
DIRECT=Y versus DIRECT=N when importing
-
Count males and females as well as total
-
Setting GLOBAL_NAMES to false to use dblink
-
Can't open dump file using IMP
-
Disabling and enabling triggers
-
Practicing Oracle commands online
-
Alphanumeric primary key
-
Composite primary keys and indexes
-
Calculating next extent size
-
OUTER JOIN instead of a NOT EXISTS subquery
-
Inserting values from one table into another, with another set of values
-
How to validate zip code, city, and state code
-
What is the file extension of an Oracle database?
-
Calculating weeks between two dates
-
What values can be deduced from sys.dual?
-
Full outer join in a many-to-many relationship, part 1
-
Migrating data from DB2 to 9i
-
Are left outer joins messing up the optimizer?
-
X$KGLOB not visible
-
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
-
Importing a SQL Server table into Oracle
-
Are hyphens allowed in standard SQL column names?
-
Trigger to update TABLE 2 with TABLE 1 updates
-
Searching with multiple keywords
-
Inserting the '&' symbol in a string
-
Adding a new NOT NULL field to an existing table
-
How to retrieve a DB2 date in Julian format
-
When does OSUSER in V$SESSION = Oracle?
-
Preventing duplicate entries on multiple columns
-
Summing across columns
-
Nested tables in MySQL
-
One query to return disjoint sets (MySQL)
-
Sort order of composite primary keys
-
Killing the session through an AFTER LOGON trigger
-
RAID and multiplexing
-
Flat file versus relational databases
-
Joining tables that have composite primary keys
-
Using SSADM and DSDM for rapid application development
-
Getting SID and SERIAL# without V_$SESSION
-
PL/SQL UTL_SMTP procedure to send e-mail
-
Getting alternate rows from a table
-
Populating the MODULE column of V$SESSION
-
Best way to restrict user access to columns in a table
-
Retrieving unique values from columns in one query
-
Character to number conversion error
-
Exporting data using a WHERE clause
-
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
-
Closing ref cursor after it's used in a Java program
-
Implementing a data warehouse: Outsource or in-house with consultants?
-
Database installation for beginners
-
How to find which stored procedure is currently running
-
Executing a procedure from a perl script
-
Comparing LDAP and OiD
-
Can't use MAX function in the WHERE clause
-
Max number of constraints, logical/physical activities, selecting duplicate rows
-
Concatenating all columns generically
-
Object-oriented versus structured methodology
-
DELETE or UPDATE, CASCADE or RESTRICT, part 1
-
Age constraint on a date column
-
COALESCE on three columns
-
Why WHERE cannot be used after GROUP BY
-
Day of the week
-
Hybrid databases explained
-
Pinning and caching
-
Getting a row number in a group
-
Query to find size of BLOB objects
-
Grouping output by week
-
Inserting multiple child rows
-
Setting up automatic e-mail notification of expiring passwords
-
Purpose of a primary key
-
What does SELECT 1 accomplish?
-
Beyond petabytes
-
Inserting a carriage return in an Oracle table
-
Finding the sequence of the last full backup
I have an Oracle database working in archive mode. Could you tell me how to find the sequence of the last full backup? Continue Reading
-
Column names in a UNION
-
Aggregates for date ranges
-
Last N rows in DB2
-
Aggregate functions in a left outer join
-
Closest date before or after a given date
-
Tools to teach normalization
-
Getting the SQL traffic byte size for session and transaction