PL/SQL User’s Guide and Reference - Phần 9Usage Notes Two kinds of numeric literals can be used in arithmetic expressions: integers and reals. Numeric literals must be separated by punctuation. Spaces can be used in addition to the punctuation. A character literal is an individual character enclosed by single quotes (apostrophes). Character literals include all the printable characters in ...
76 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1936 | Lượt tải: 0
IPhone Cool ProjectsAbout the Lead Author . xi About the Technical Consultant . xiii Acknowledgments .xv Introduction xvii WOLFGANG ANTE CHAPTER 1 Designing a Simple, Frenzic-Style Puzzle Game . 3 MIKE ASH CHAPTER 2 Mike Ash’s Deep Dive Into Peer-to-Peer Networking 29 GARY BENNETT CHAPTER 3 Doing Several Things at Once: Performance Enhancements with Threading . 57 MAT...
234 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2158 | Lượt tải: 0- PL/SQL User’s Guide and Reference - Phần 8
Keyword and Parameter Description cursor_name This identifies an explicit cursor previously declared within the current scope. datatype This is a type specifier. For the syntax of datatype, see "Constants and Variables" on page 11-33. db_table_name This identifies a database table (or view) that must be accessible when the declaration is ...
48 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1825 | Lượt tải: 0 - PL/SQL User’s Guide and Reference - Phần 7
Dynamic SQL supports all the SQL datatypes. So, for example, define variables and bind arguments can be collections, LOBs, instances of an object type, and refs. As a rule, dynamic SQL does not support PL/SQL-specific types. So, for example, define variables and bind arguments cannot be Booleans or index-by tables. The only exception is that a PL/S...
60 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1886 | Lượt tải: 0 - PL/SQL User’s Guide and Reference - Phần 5
User-Defined Exceptions PL/SQL lets you define exceptions of your own. Unlike predefined exceptions, user-defined exceptions must be declared and must be raised explicitly by RAISE statements. Declaring Exceptions Exceptions can be declared only in the declarative part of a PL/SQL block, subprogram, or package. You declare an exception by introduci...
63 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1881 | Lượt tải: 0 - PL/SQL User’s Guide and Reference - Phần 4
Using Cursor FOR Loops In most situations that require an explicit cursor, you can simplify coding by using a cursor FOR loop instead of the OPEN, FETCH, and CLOSE statements. A cursor FOR loop implicitly declares its loop index as a %ROWTYPE record, opens a cursor, repeatedly fetches rows of values from the result set into fields in the record, an...
23 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1918 | Lượt tải: 0 - PL/SQL User’s Guide and Reference - Phần 3
Defining and Declaring Collections To create collections, you define a collection type, then declare collections of that type. You can define TABLE and VARRAY types in the declarative part of any PL/SQL block, subprogram, or package. For nested tables, use the syntax TYPE type_name IS TABLE OF element_type [NOT NULL]; and for varrays, use the follo...
Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1949 | Lượt tải: 0 - PL/SQL User’s Guide and Reference - Phần 2
National Character Types The widely used one-byte ASCII and EBCDIC character sets are adequate to represent the Roman alphabet, but some Asian languages, such as Japanese, contain thousands of characters. These languages require two or three bytes to represent each character. How does Oracle deal with such dissimilar languages? Oracle provides Nati...
Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 1874 | Lượt tải: 0 - PL/SQL User’s Guide and Reference - Phần 1
Contributors: Dave Alpern, Chandrasekharan Iyer, Ervan Darnell, Ken Jacobs, Sanjay Kaluskar, Sanjay Krishnamurthy, Janaki Krishnaswamy, Neil Le, Kannan Muthukkaruppan, Shirish Puranik, Chris Racicot, Ken Rudin, Usha Sangam, Ajay Sethi, Guhan Viswanathan The Programs (which include both the software and documentation) contain proprietary information...
Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2112 | Lượt tải: 0 
Introducing Windows AzureContents v ■Foreword . x ■About the Author xiii ■About the Technical Reviewer xiv ■Acknowledgments . xv ■Introduction xvi ■Chapter 1: Create Cloud Table Storage 1 ■Chapter 2: Access Cloud Table Storage . 25 ■Chapter 3: Working with Cloud Queue and Blob Storage 67 ■Chapter 4: Windows Azure Application Integration Using WCF . 113 ■Chapter 5: Azure .N...
351 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2149 | Lượt tải: 0
