Identifying tables or columns by their qualified object name  Omitting the owner name

Chapter 4: Expressions, Identifiers, and Wildcard Characters

Using delimited identifiers within an object name

If you use set quoted_identifier on, you can use double quotes around individual parts of a qualified object name. Use a separate pair of quotes for each qualifier that requires quotes. For example, use:

database.owner."table_name"."column_name"

Do not use:

database.owner."table_name.column_name"



Copyright © 2005. Sybase Inc. All rights reserved. Omitting the owner name

View this book as PDF