Ask the Experts
Ask the Experts
-
Steps for copying a database or schema
Follow these steps to copy an entire database or a schema using Oracle's export and import utilities. Continue Reading
-
SQL query for parent/child relationship
-
Indexed vs. non-indexed database
-
Accessing an ODBC data source, part 1
-
Subquery or join?
-
ON DELETE in a many-to-many relationship
-
DIRECT=Y versus DIRECT=N when importing
-
How to validate zip code, city, and state code
-
What is the file extension of an Oracle database?
-
Trigger to update TABLE 2 with TABLE 1 updates
-
Inserting the '&' symbol in a string
-
Database installation for beginners
-
FIRST N rows, TOP N rows, LAST N rows, BOTTOM N rows...
-
Age constraint on a date column
-
COALESCE on three columns
-
Day of the week
-
Getting a row number in a group
-
Setting up automatic e-mail notification of expiring passwords
-
What does SELECT 1 accomplish?
-
Purpose of a primary key
-
Column names in a UNION
-
Closest date before or after a given date
-
Why use a "business key" and a "primary key"?
-
Checking if row is locked before using it in a procedure
-
AVG() function on a date field
-
Assignment operators explained
-
Changing a varchar2 field to uppercase
-
SUM() and MAX() at the same time
-
Searching on CLOB columns
-
Working with dates where year, month and day are separate columns
-
Grouping by hour
-
Data type for telephone numbers
-
Using the WHEN_TAB_PAGE_CHANGED trigger
-
Sorting the days of the week with Monday first
-
Sequences and indexes explained
-
How does WHERE EXISTS ( SELECT NULL... ) work?
-
Returning records where column has carriage return line feed
-
Getting the 10th row of a table
-
How can I use INSERT INTO to copy an entire table into another?
-
How to select the highest grade from list of names and ID's