Ask the Experts
Ask the Experts
-
Which normal form is used most?
SQL expert Rudy Limeback explains what normal form is used in most database projects. Continue Reading
-
Update a specific column in a field or row?
An Oracle user asks if SQL can be used to update a specific column in a field. Continue Reading
-
How to set up a job for an SQL query in Oracle 10g Grid Control
Oracle expert Brian Peasland explains when and how to set up a job in Oracle to run an SQL statement. Continue Reading
-
ORA-27101 error: shared memory realm does not exist
An Oracle user asks why their machine is abnormally terminating and they are receiving the ORA-27101 error. Continue Reading
-
Remote database administration: What to look for in a provider
Managing an Oracle shop expert Michael Hillenbrand talks about his experiences with remote database administration. Continue Reading
-
Receiving the ORA-01652 error with no specified tablespace
An Oracle user asks why they are receiving the ORA-01652 error but there is no tablespace specified in the error. Continue Reading
-
Why am I getting the ORA-03113 error when trying to refresh a materialized view?
An Oracle user asks expert Brian Peasland why they are getting the ORA-03113 error when trying to refresh a materialized view completely. Continue Reading
-
Why do I have to start my Oracle database manually?
An Oracle user asks why they are having to start their Oracle database manually using SQL plus. Continue Reading
-
ORA-06550 error when exporting a database
An Oracle user asks why they may be getting an error when exporting a database. Continue Reading
-
Hot backup when Oracle Database is up
An Oracle user asks Database Backup and Recovery expert Brian Peasland the following question: "What is the procedure for doing a hot backup when the database is up?" Continue Reading
-
SQL query for co-authored books
SQL expert Rudy Limeback gives advice for writing a query that involves a number of tables. Continue Reading
-
Connecting tables in a database
SQL Expert Rudy Limeback gives advice on finding information on primary and foreign keys to connect tables in a database. Continue Reading
-
IN list or series of OR conditions?
SQL expert Rudy Limeback explains the advantage of using the IN list in this situation. Continue Reading
-
Querying complex derived tables
An Oracle user asks SQL expert Rudy Limeback how to run a query when the inner query results come from five different tables. Continue Reading
-
Changing a NULL column to NOT NULL
An Oracle user asks SQL expert Rudy Limeback how to repopulate a table after modifying the table to NOT NULL. Continue Reading