PL/SQL User’s Guide and Reference - Phần 8Keyword 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: 1729 | 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: 1785 | 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: 1784 | 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: 1812 | 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: 1860 | 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: 1772 | 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: 2020 | 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: 2053 | Lượt tải: 0
Introducing Silverlight 4Contents . iv About the Author . xvii About the Technical Reviewer . xviii Acknowledgments . xix Introduction xx PART 1 Introduction to Silverlight .1 Chapter 1: Introducing Silverlight 3 Cross-Platform Frameworks 4 Qt 4 The Java Platform . 4 Adobe Flash/Flex/AIR 5 Microsoft ASP.NET AJAX 5 Microsoft Silverlight . 5 The History of Si...
745 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2243 | Lượt tải: 0
Intel Museum - Education Program DescriptionsBelow are descriptions of the Intel Museum’s tour and class offerings. Please note that the number of students in a class is limited to 18 because of the available seating in our learning lab. Groups of more than 18 students that schedule a museum class in conjunction with a tour will be split into two groups. One group will participate in a guided...
12 trang | Chia sẻ: tlsuongmuoi | Ngày: 18/04/2013 | Lượt xem: 2500 | Lượt tải: 0
