specifying variables at runtime

Chia sẻ: Ba Toan | Ngày: | Loại File: PDF | Số trang:28

lượt xem

specifying variables at runtime

Mô tả tài liệu
  Download Vui lòng tải xuống để xem tài liệu đầy đủ

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....

Chủ đề:

Nội dung Text: specifying variables at runtime

Đồng bộ tài khoản