Ask the Experts

What is the difference between a database engineer, architect and administrator?

Expert Michael Hillenbrand explains the difference between a database engineer, a database architect and a database administrator. Continue Reading
Using BETWEEN with DATETIMEs in SQL

Expert Rudy Limeback is asked if SQL can be used to retrieve data between two dates, including the two dates. Continue Reading
LOB tables missing with exp/imp move of schema

I have a problem when moving a schema using exp/imp. After import, the tables with LOBs are missing. Continue Reading
How to increase SGA_MAX_SIZE in Oracle

How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup. Continue Reading
Employees with the same first and last names in SQL

How do I SELECT a list of employees who have the same last and first name in SQL? Continue Reading

When will support for Oracle 9i be discontinued?

When will general support for Oracle 9i be discontinued? Continue Reading
Sorting a clob column

I'm trying to sort a column type asc as well as desc. I'm able to sort the clob column desc but not able to sort it asc. Can you please help me out? Continue Reading
Steps to implement RAC

How can I implement a RAC application in Oracle Database in my system? Continue Reading
ON DELETE RESTRICT

I would like to know where we use DELETE RESTRICT? Continue Reading
Difference between function, procedure and trigger

What is the difference between a function, a procedure and a trigger? I know the basic differences, but I would like to know the answers based on the performance tuning aspect. Continue Reading
Multiple instances on a single database

Is it possible for Oracle to have parallel servers (single database, multiple instances)? Is it impossible to have the inverse (that is, multiple databases, single instance)? Continue Reading