Email Alerts
-
Doing SQL arithmetic with SELECT instead of arithmetic operations
Learn how to do simple SQL arithmetic operations without using the arithmetic operators. Answer
-
Managing SQL parent table-child table relations
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Answer
-
Using SQL SELECT and SQL UNION ALL statements to sort numbers
Expert Dan Clamage explains how to use SQL SELECT and SQL UNION ALL statements to sort and visualize a set of sales figures. Answer
-
Confusion around PL/SQL to_date and to_char functions
One reader asks expert Daniel Clamage about the PL/SQL to_date and to_char functions and how to properly convert date and string values. Answer
-
Calling stored procedures inside user-defined functions in Oracle Database
In this expert answer, Brian Peasland explains how to call a stored procedure inside user-defined functions in Oracle Database. Answer
-
Solve a PL-SQL error that creates dynamic tables
Oracle PL-SQL expert Daniel Clamage answers a question about a problem with doing an “insert” in PL-SQL to create a table dynamically. Answer
-
Inconsistent data type error in Oracle Database 9i
A reader asks SQL expert Daniel Clamage about an inconsistent data type error he's getting on a query running in Oracle Database 9i. Answer
-
Making Monday the start of the week in Oracle SQL
One reader asks how to set up a report in Oracle SQL so that Monday is the first day of the week. Answer
-
Does storing documents in a database hinder performance?
One reader asks if it is the best practice to store a document inside an Oracle database. Answer
-
Working with binary large objects (BLOBs)
One reader asks how to create and retrieve a binary large object (BLOB), and SQL expert Karen Morton gives some comprehensive advice and tips. Answer