Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
You can create a command file containing a WHERE clause to restrict the rows displayed. To change the condition each time the command file is run, you use substitution variables. Substitution variables can replace values in the WHERE clause, a text string, and even a column or a table name. At the end of this lesson, you should be able to Create a SELECT statement that prompts the user to enter a value at runtime. Use the SQL*Plus ACCEPT command to define a variable. Define a variable that can be automatically picked up by the SELECT statement at runtime | 7 Specifying Variables at Runtime ORACLG Objectives Create a SELECT statement that prompts the user to input a value at runtime. Define a variable that can be automatically picked up by the SELECT statement at runtime. Define a variable by using the SQL Plus ACCEPT command. Schedule Timing 35 minutes 25 minutes 60 minutes Topic Lecture Practice Total Class Management Note Files required for this lesson are Demonstration l7varno.sql l7varyes.sql l7expr.sql l7dbl.sql l7dlb2.sql l7prompt.sql l7param.sql x Practice None 7-2 Introduction to Oracle SQL and PL SQL Using Procedure Builder Objectives You can create a command file containing a WHERE clause to restrict the rows displayed. To change the condition each time the command file is run you use substitution variables. Substitution variables can replace values in the WHERE clause a text string and even a column or a table name. At the end of this lesson you should be able to Create a SELECT statement that prompts the user to enter a value at runtime. Use the SQL Plus ACCEPT command to define a variable. Define a variable that can be automatically picked up by the SELECT statement at runtime. Specifying Variables at Runtime .