Đang chuẩn bị liên kết để tải về tài liệu:
Oracle PL/SQL by Example- P2

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

Tham khảo tài liệu 'oracle pl/sql by example- p2', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | LAB 2.1 22 LAB 2.1 PL SQL Programming Fundamentals LAB OBJECTIVES After completing this lab you will be able to Make use of PL SQL language components Make use of PL SQL variables Handle PL SQL reserved words Make use of identifiers in PL SQL Make use of anchored datatypes Declare and initialize variables Understand the scope of a block nested blocks and labels Most languages have only two sets of characters numbers and letters. Some languages such as Hebrew and Tibetan have specific characters for vowels that are not placed inline with consonants. Other languages such as Japanese have three character types one for words originally taken from the Chinese language another set for native Japanese words and a third for other foreign words. To speak any foreign language you have to begin by learning these character types. Then you learn how to make words from these character types. Finally you learn the parts of speech and you can begin talking. You can think of PL SQL as being a more-complex language because it has many character types and many types of words or lexical units that are made from these character types. As soon as you learn these you can begin learning the structure of the PL SQL language. CHARACTERTYPES The PL SQL engine accepts four types of characters letters digits symbols - and so on and white space. When elements from one or more of these character types are joined they create a lexical unit these lexical units can be a combination of character types . The lexical units are the words of the PL SQL language. First you need to learn the PL SQL vocabulary and then you will move on to the syntax or grammar. Soon you can start talking in PL SQL. Please purchase PDF Split-Merge on www.verypdf.com to remove this watermark. Lab 2.1 Exercises LAB 2.1 23 BY THE WAY Although PL SQL can be considered a language don t try talking to your fellow programmers in PL SQL. For example at a dinner table of programmers if you say BEGIN LOOP FOR PEAS IN PLATE EXECUTE .