TAILIEUCHUNG - Chapter 27: An Introduction to PL/SQLThe Exception Handling section of a PL/SQL block is

Chapter 27: An Introduction to PL/SQL The Exception Handling section of a PL/SQL block is optional—none of the PL/SQL blocks shown previously in this chapter included an Exception Handling section. However, the examples shown in this chapter have been based on a very small set of known input values with very limited processing performed. In the following listing, the simple loop for calculating the area of a circle is shown, with two modifications (shown in bold). A new variable named some_variable is declared in the Declarations section, and a calculation to determine the variable’s value is created in the Executable Commands. | Chapter 27 An Introduction to PL SQL 507 The Exception Handling section of a PL SQL block is optional none of the PL SQL blocks shown previously in this chapter included an Exception Handling section. However the examples shown in this chapter have been based on a very small set of known input values with very limited processing performed. In the following listing the simple loop for calculating the area of a circle is shown with two modifications shown in bold . A new variable named some_variable is declared in the Declarations section and a calculation to determine the variable s value is created in the Executable Commands section. t declare pi constant NUMBER 9 7 radius INTEGER 5 area NUMBER 14 2 some_variable NUMBER 14 2 begin radius 3 loop some_variable 1 radius-4 area pi power radius 2 insert into AREAS values radius area radius radius 1 exit when area 100 end loop end Because the calculation for some_variable involves division you may encounter a situation in which the calculation attempts to divide by zero an error condition. The first time through the loop the Radius variable with an initial value of 3 is processed and a record is inserted into the AREAS table. The second time through the loop the Radius variable has a value of 4 and the calculation for some_variable encounters an error t declare ERROR at line 1 ORA-01476 divisor is equal to zero ORA-06512 at line 9 Since an error was encountered the first row inserted into AREAS is rolled back and the PL SQL block terminates. You can modify the processing of the error condition by adding an Exception Handling section to the PL SQL block as shown in the following listing. I declare pi constant NUMBER 9 7 radius INTEGER 5 area NUMBER 14 2 some_variable NUMBER 14 2 begin radius 3 508 Part III PL SQL loop some_variable 1 radius-4 area pi power radius 2 insert into AREAS values radius area radius radius 1 exit when area 100 end loop exception when ZERO_DIVIDE then insert into AREAS values 0

• Cơ sở dữ liệu
• Carthaginians
• Assyrians
• Macedonians
• Babylonians
• Medes
• Persians
• Huckleberry Finn
• Chapter fifteen
• Chapter sixteen
• Chapter seventeen
• Chapter eighteen
• Chapter nineteen
• Chapter 1 Attitudes
• Chapter 2 money
• Chapter 3 health
• Chapter 4 education
• Communication 2
• Lesson Communication 2
• Maximum Security
• Guide to Protecting
• Internet Site
• network security
• programming languages​​
• computer networks
• information security
• IDS systems
• Macs For Dummies
• Apple’s seismic
• For Dummies
• Mac Daily Dealings
• Drag and Drop Tech Chapter 1 Adventuring into the Mac World Chapter 2 The Nuts and Bolts of Your Mac Chapter 3 Getting to the Core of the Apple
• Chapter 8 Expansion valve
• Lectures Chapter 8 Expansion valve
• Thermostatic expansion valve
• Electronic expansion valve
• Low pressure float valve
• High pressure float valves
• Exercises chapter 8 Drawing
• Chapter 8 Drawing
• Exercises drawing
• Drawing review
• Homework drawing
• Painting competitions wen
• Exercises chapter 8 Extra drawing
• Exercises extra drawing
• Chapter 8 Extra drawing
• Extra drawing
• Exercises chapter 8 Extra
• Exercises Extra
• Chapter 8 Extra
• Extra exercise
• Review extra
• Extra question
• Chapter 16 Long term liabilities
• In this chapter
• the learning objectives are Describe the major characteristics of bonds
• explain how to account for bond transactions
• explain how to account for long term notes payable
• discuss how long term liabilities are reported and analyzed
• Chapter 16 Long term liabilities In this chapter
• the learning objectives are: Describe the major characteristics of bonds
• Drive systems with induction motors
• Control of induction motors
• Chapter 1 background
• Chapter 1 induction motors
• Characterization of induction motors
• AC drive systems
• Use in AC drive systems
• Dynamic model of the induction motor
• The induction motor
• Chapter 6 dynamic model
• Chapter 6 dynamic model of the induction motor
• Space vectors of motor variables
• Revolving reference frame
• công nghệ thông tin
• hệ điều hành
• windows
• windows Xp
• Xp
• windows vista
• vista
• OReilly
• Mac
• OSX
• Leopard
• The Missing Manual
• Chapter 19
• Mail and Address Book Email is a fast
• cheap
• convenient communication medium
• The Complete Guide to Buying and Selling Apartment Buildings
• bất động sản
• mua bán nhà chung cư
• Chapter 1 2
• Chapter 3 4
• Chapter 7 8
• Chapter 11 12
• Enchanta
• Jay Dubya
• luyện đọc tiếng anh
• Superstitious Rock
• truyện tiếng anh
• physics
• vật lý
• khoa học tự nhiên
• CHAPTER XI Electromagnetic Induction
• bài giảng vật lý bậc đại học
• chapter
• cursed
• story
• fun
• Georgia Ho
• Dodo Press
• sản phẩm mới
• quản lý sản phẩm mới
• chiến lược quảng cáo
• phân phối sản phẩm
• chiến lược bán hàng
• Cost Based
• Oracle Fundamentals
• Bitmap Indexes CHAPTER
• Bitmap Indexes CHAPTER 9 Query Transformation
• Query Transformation
• giáo trình kiểm toán
• kiểm toán căn bản
• sai sót trong kiểm toán
• trách nhiệm kiểm toán
• tài chính kiểm toán
• rủi ro sinh học
• công nghệ sinh học
• kiểm soát môi trường
• nhiễm trùng
• khử trùng