Ask the Experts
Ask the Experts
-
Import/Export triggers
-
Table join sequence for performance
-
Executing external .sql files from stored procedures
-
Oracle vs. Microsoft Access
-
Insert statement process explanation
-
Best way to determine if an index is being used
-
Inserting a blob field in SQL*Plus
-
Selecting random rows
-
Conditional values in the SELECT list
-
An Accounts Receivable report in one query
-
How can I use INSERT INTO to copy an entire table into another?
-
Difference between clustered and non-clustered indexes
-
What is Explain Plan in Oracle, & how do we use it?
-
What does null mean?
-
What is the Boyce-Codd normal form?
-
How to speed up loading production data into test database
-
Hit an error
-
How to resize the columns in a given table
-
How to find the first 5 highest salaried employees in each department
-
Advantages and disadvantages of ndexed and hashed file access methods
-
Is it necessary for a table always to have a primary key?
-
Writing an SQL query that shows suppliers of only best shops in specific state
-
Deadlock error when a specific batch process runs in parallel
-
What does the decode function do, and how is it structured?
-
How to get the maximum value for a row
-
Query for shopping cart database
-
What is the best way to migrate data from Teradata db to Oracle/SUN?
-
What is SQL tuning?
-
Creating a weekly report by specifying a query between two dates
-
Changing a 4-digit number into 3 digits
-
How to select the highest grade from list of names and ID's