Có 20+ tài liệu thuộc chủ đề "Oracle cơ bản"
tailieu.vn Xem trực tuyến Tải xuống
CH ƯƠ NG 1. C S D LI U TH C HÀNH. CH ƯƠ NG 2. Câu l nh truy v n c b n. Giá tr NULL. Câu l nh t ệ ươ ng tác c a SQL*Plus. CH ƯƠ NG 3. CH ƯƠ NG 4. Câu l nh case. CH ƯƠ NG 5. M i liên k t...
tailieu.vn Xem trực tuyến Tải xuống
Search the text of Oracle PL/SQL Language Pocket Reference.. Chapter 1: Oracle PL/SQL Language Pocket Reference. 1.4: PL/SQL Language Fundamentals 1.5: Variables and Program Data. 1.8: Database Interaction and Cursors 1.9: Cursors in PL/SQL. 1.10: Exception Handling 1.11: Records in PL/SQL 1.12: Named Program Units 1.13: Triggers. 1.15: Calling PL/SQL Functions in SQL 1.16: Oracle8 Objects. The Oracle PL/SQL CD...
tailieu.vn Xem trực tuyến Tải xuống
Oracle PL/SQL Language Pocket Reference. Previous: 1.11 Records in PL/SQL. A procedure is called as a standalone executable PL/SQL statement:. A function must have at least one RETURN statement in the execution section. The RETURN clause in the function header specifies the datatype of the returned value.. See the Section Compiling stored PL/SQL programs". See the Section Privileges and stored...
tailieu.vn Xem trực tuyến Tải xuống
routines can now call the JSP as if it were another PL/SQL module.. 1.19.2 Publishing Java to PL/SQL. For example, here is the complete syntax for creating JSPs as PL/SQL-callable functions or procedures:. Note that Java functions typically map to PL/SQL functions, but Java functions declared void map to PL/SQL procedures. Also, you will quickly learn that mistakes in mapping...
tailieu.vn Xem trực tuyến Tải xuống
Target labels and PL/SQL blocks utility : C.16. Characteristics of PL/SQL Tables nested. The Anonymous PL/SQL Block 15.3.4. The PL/SQL Character Set. NULLs in PL/SQL. PL/SQL usage. Characteristics of PL/SQL Tables OODBs (object-oriented databases. how PL/SQL fits in : 1.1. What Is PL/SQL?. Restrictions on PL/SQL Functions in SQL packages. Passing PL/SQL Tables as Parameters. Partitioning a PL/SQL table to...
tailieu.vn Xem trực tuyến Tải xuống
later in this chapter.) The specification for this procedure is as follows:. Previous: 8.2 The Exception Section. Chapter 8 Next: 8.2 The Exception Section. Next: 8.2 The Exception Section. 7.7 Tips for PL/SQL Loops Book Index 8.2 The Exception Section The Oracle Library. The syntax of the FOR loop states your intent explicitly and should only be a FOR loop...
tailieu.vn Xem trực tuyến Tải xuống
SQL and don't expect any of the cursor attributes to be available for your cursor variables.. The following example declares a cursor type (called a REF CURSOR type) for the company table, then opens, fetches from, and closes the cursor:. Create the cursor type. Open the cursor variable, associating with it a SQL statement. Fetch from the cursor variable. Close...
tailieu.vn Xem trực tuyến Tải xuống
Unless you deliberately plan to handle this scenario, use of the implicit cursor is a declaration of faith. If the nature of the data ever changes, however, you may find that the SELECT statement which formerly. You can't get inside the separate operations of the cursor, such as the open and close stages. You can't examine the attributes of the...
tailieu.vn Xem trực tuyến Tải xuống
Oracle PL/SQL. This section describes the use of the %TYPE declaration attribute to anchor the datatype of one variable to another data structure, such as a PL/SQL variable or a column in a table. When you anchor a datatype, you tell PL/SQL to set the datatype of one variable from the datatype of another element.. Previously declared PL/SQL variable name....
tailieu.vn Xem trực tuyến Tải xuống
The second example uses a multiline comment to explain the purpose of the FOR loop. What do you think of the comments in the following Oracle Forms trigger code?. Inform the user of the problem.. None of these comments add anything to the comprehension of the code. Does the following comment explain the purpose of the code or simply restate...
tailieu.vn Xem trực tuyến Tải xuống
You should center all your PL/SQL development effort around packages. 1.7.4 Standardize Your PL/SQL Development Environment. This is done for you implicitly by the PL/SQL runtime engine.. Oracle PL/SQL. PL/SQL Language Fundamentals. PL/SQL Language. Introduction to PL/SQL. Next: 1.7 Best Practices for PL/SQL Excellence. PL/SQL is a powerful, many-featured product. The cursor FOR loop is one of my favorite PL/SQL...
tailieu.vn Xem trực tuyến Tải xuống
Previous: About the Disk Oracle PL/SQL. This disk contains the Companion Utilities Guide for Oracle PL/SQL. Oracle PL/SQL. see Section 1.4, "PL/SQL Versions". In code examples, indicates PL/SQL keywords.. Previous: Audience Oracle PL/SQL. This book was designed to be used by anyone who needs to develop Oracle-based applications using the PL/SQL programming language. particular attention to Part 4, for the...
tailieu.vn Xem trực tuyến Tải xuống
The function convert_date that follows illustrates the full PL/SQL version of the preceding. Oracle PL/SQL. Records in PL/SQL. The exception section of a PL/SQL block only handles exceptions raised in the execution section of that block.. An exception raised in the declaration section of a PL/SQL block is handled by the exception section of the enclosing block, if it exists.....
tailieu.vn Xem trực tuyến Tải xuống
10.5.3 Nonsequential Use of PL/SQL Table. The following example illustrates filling a PL/SQL table's rows randomly rather than sequentially:. "Data-Smart Row Numbers in PL/SQL Tables". 10.5.4 Passing PL/SQL Tables as Parameters. You can also pass a PL/SQL table as a parameter in a procedure or function. Declare a PL/SQL table based on the packaged type.. PL/SQL table of company IDs.....
tailieu.vn Xem trực tuyến Tải xuống
INSTR Returns the location in a string of the specified substring.. The following sections briefly describe each of the PL/SQL character functions.. 11.1.1 The ASCII function. The specification of the ASCII function is:. 11.1.2 The CHR function. The specification of the CHR function is:. 11.1.3 The CONCAT function. The specification of the CONCAT function is:. 11.1.4 The INITCAP function. 11.1.5...
tailieu.vn Xem trực tuyến Tải xuống
Get the last day of the month three months after being hired:. Tell me the number of days until the end of the month:. 12.1.3 The MONTHS_BETWEEN function. Here are some examples of the uses of MONTHS_BETWEEN:. 12.1.4 The NEW_TIME function. 12.1.5 The NEXT_DAY function. The NEXT_DAY function returns the date of the first day after the specified date which...
tailieu.vn Xem trực tuyến Tải xuống
RR The last two digits of the year. Q The quarter of the year, from 1 through 4. MM The number of the month in the year, from 01 through 12.. J The Julian day format of the date (counted as the number of days since January 1, 4712 B.C., the earliest date supported by the Oracle RDBMS).. MI The...
tailieu.vn Xem trực tuyến Tải xuống
15.3.4 Nested Blocks. A PL/SQL block nested within another PL/SQL block may be called by any of the following: nested. Each of the two SELECT-UPDATE combinations is embedded in its own anonymous PL/SQL block.. Suppose that the procedure update_management did not make use of the embedded blocks. Two of the most important concepts related to a PL/SQL block are those...
tailieu.vn Xem trực tuyến Tải xuống
The Benefits of Packages Overview of Package Structure The Package Specification The Package Body. That is a shame, because the package structure is also one of the most useful constructs for building well- designed PL/SQL-based applications. Oracle Corporation itself uses the package construct to extend the PL/SQL language. You can spend days and weeks, however, uncovering all the nuances and...
tailieu.vn Xem trực tuyến Tải xuống
Oracle PL/SQL. Functions in SQL. Previous: 17.4 Restrictions on PL/SQL Functions in SQL. Calling PL/SQL Functions in SQL. Yet it is the contents of the package body which determine whether that function is valid for execution in SQL.. You assert a purity level for a function with the RESTRICT_REFERENCES pragma, explored in the next section.. 17.5.1 The RESTRICT_REFERENCES Pragma. In...