Murach's Oracle SQL and PL/SQL
How to work with data types and functions

This chapter describes the data types that are available with Oracle, and it teaches you how to use built-in scalar functions to work with data of various types.
Chapter 8 How to work with data types and functions
The built-in data types 230
Data type overview 230
The character data types 232
The numeric data types 234
The temporal data types 236
The large object data types 238
How to convert data from one type to another 240
How to convert characters, numbers, and dates 240
Common number format elements 242
Common date/time format elements 244
How to convert characters to and from their numeric codes 246
How to work with character data 248
How to use the common character functions 248
How to parse a string 252
How to sort a string in numerical sequence 254
How to sort mixed-case columns in alphabetical sequence 254
How to work with numeric data 256
How to use the common numeric functions 256
How to search for floating-point numbers 258
How to work with date/time data 260
How to use the common date/time functions 260
How to parse dates and times 262
How to perform a date search 264
How to perform a time search

266
Other functions you should know about 268
How to use the CASE function 268
How to use the COALESCE, NVL, and NVL2 functions 270
How to use the GROUPING function 272
How to use the ranking functions 274


© Copyright 1998-2009 Mike Murach & Associates, Inc.  All rights reserved.

Murach's Oracle SQL and PL/SQL

Learn more about this book

View the table of contents

Add this book to your cart



Our Ironclad Guarantee

First, try our books for 90 days. Then, if you aren't completely convinced that our books are the best ones you've ever used, you can return them for a full refund...no questions asked.