ELUNA Document Repository

Oracle SQL: Tips and Tricks for Aleph and Voyager Systems Librarians

Rogers, Mike (2013) Oracle SQL: Tips and Tricks for Aleph and Voyager Systems Librarians. In: ELUNA 2013, April 30 - May 3, 2013, Athens, GA.

[img] PDF - Presentation
Restricted to Registered users only



Abstract: This presentation will cover a number of useful tips and tricks for using Oracle SQL to report and manage data. I will quickly cover some SQL basics and then present a number of helpful functions and techniques to extract and manipulate data. Some of these include SUBSTR, INSTR, DECODE, UNION, REPLACE, COMPUTE, “successive” queries, the use of TEMP tables, Oracle SQL Loader, Oracle Database Links, and so forth. There will be time for attendees to share their own SQL tips and tricks as well as ask any questions they might have. An electronic copy of my SQL documentation will be e-mailed to all attendees who request it.

Item Type:Conference or Workshop Item (Lecture)
Event Title:ELUNA 2013
Subjects:General Topics
Divisions:ELUNA Conference Proceedings
ID Code:993
Deposited On:28 Jun 2013 20:18
Last Modified:27 May 2016 21:06

Repository Staff Only: item control page