relation: https://beta-documents.el-una.org/id/eprint/993/
title: Oracle SQL: Tips and Tricks for Aleph and Voyager Systems Librarians
creator: Rogers, Mike
subject: General Topics
description: 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.
date: 2013-05-02
type: Conference or Workshop Item
type: NonPeerReviewed
format: application/pdf
language: en
identifier: https://beta-documents.el-una.org/id/eprint/993/1/Rogers_general.pdf
identifier: Rogers, Mike (2013) Oracle SQL: Tips and Tricks for Aleph and Voyager Systems Librarians. In: ELUNA 2013, April 30 - May 3, 2013, Athens, GA.