Rogers, Mike (2013) Oracle SQL: Tips and Tricks for Aleph and Voyager Systems Librarians. In: ELUNA 2013, April 30 - May 3, 2013, Athens, GA.
![[thumbnail of Rogers_general.pdf]](https://documents.el-una.org/style/images/fileicons/application_pdf.png) |
PDF
- Presentation
Restricted to Registered users only 3MB |
Abstract
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 By: | INVALID USER |
| Deposited On: | 28 Jun 2013 20:18 |
| Last Modified: | 27 May 2016 21:06 |
Repository Staff Only: item control page