Ask The Oracle Expert: Questions & Answers
SQL
Karen Morton can solve your toughest SQL problems. Have a question for Karen? Send an e-mail to editor@searchoracle.com
.
Display in sets of :
-
Making Monday the start of the week in Oracle SQL
Answer - One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week. 08 February 2012 -
Does storing documents in a database hinder performance
Answer - One reader asks if it is the best practice to store a document inside an Oracle database. 01 February 2012 -
Creating and retrieving a binary large object (BLOB)
Answer - One reader asks how to create and retrieve a binary large object (BLOB), and SQL expert Karen Morton gives some comprehensive advice and tips. 15 January 2012 -
Creating a virtual SQL table for date values
Answer - One reader asks how to use SQL to track his company employees' absentee days, and expert Dan Clamage suggests creating a virtual table. 09 January 2012 -
Oracle SQL: Using the analytic rank function
Answer - Expert Karen Morton explains how to use a simple analytic rank function to sort through a group of golf scores. 14 December 2011 -
SQL query for sorting through ID columns
Answer - A reader asks Oracle expert Karen Morton how to query a group of rows based on their text columns. 14 October 2011 -
Replacing text strings in an employee name column
Answer - One reader asks how he can change occurrences of "LL" to "LX" in an employee name column. 11 October 2011 -
Avoiding and fixing mutating table errors
Answer - PL/SQL expert Daniel Clamage tells one reader why her merge statement is creating a mutating table error. 26 September 2011 -
Problems with row-by-row processing in Oracle Database
Answer - One reader asks what's wrong with his script, and Oracle expert Karen Morton explains the problem with row-by-row processing. 14 February 2011 -
Pulling data from a text file to query
Answer - In this SQL tip, expert Karen Morton explains how one can pull data from a text file into a usable format so that it's available for an SQL query. 07 January 2011