get命令的用法GET Syntax GET file_name[.ext] [LIS[T]|NOL[IST]] Loads a host operating system file into the SQL buffer. Terms Refer to the following list for a description of each term or clause: file_name[.ext] Represents the file you wish to load (typically a command file). LIS[T] Lists the contents of the file after it is loaded. This is the default. NOL[IST] Suppresses the listing. Usage If you do not specify a file extension, SQL*Plus assumes the default command-file extension (normally SQL). For information on changing the default extension, see the SUFFIX variable of the SET command in this chapter. If the filename you specify contains the word list or the word file, the name must be in double quotes. SQL*Plus searches for the file in the current working directory. The operating system file should contain a single SQL statement or PL/SQL block. The statement should not be terminated with a semicolon. If a SQL*Plus command or more than one SQL statement or PL/SQL block is loaded into the SQL buffer from an operating system file, an error occurs when the RUN or slash (/) command is used to execute the buffer. The GET command can be used to load files created with the SAVE command. See the SAVE command in this chapter for more information. Examples To load a file called YEARENDRPT with the extension SQL into the buffer, enter GET YEARENDRPT
我对SQL语句不熟,如下语句中的get算吗? Procedure XTSP_GetAllChildItemByUpCode(sUpCode in varchar2, DCode out CharArrayType, DName out CharArrayType, Dquantity out Numarraytype, Dre out Chararraytype, DItem out Numarraytype, UpCode out Chararraytype); 或 CURSOR GetAllItems IS SELECT A.DCode,A.DName,A.Dquantity,A.Dre,A.DIt em,A.UpCode FROM temptemp1 A where not exists( select 'x' from XtdetamsAll_Det ail B where b.upcode = A.DCode ) order by A.nLevel,A.UpDItem,A.DItem;
SQL>
SP2-0423: 非法的 GET 命令
Syntax
GET file_name[.ext] [LIS[T]|NOL[IST]] Loads a host operating system file into the SQL buffer. Terms
Refer to the following list for a description of each term or clause: file_name[.ext] Represents the file you wish to load (typically a command file). LIS[T] Lists the contents of the file after it is loaded. This is the default. NOL[IST] Suppresses the listing. Usage
If you do not specify a file extension, SQL*Plus assumes the default command-file extension (normally SQL). For information on changing the default extension, see the SUFFIX variable of the SET command in this chapter. If the filename you specify contains the word list or the word file, the name must be in double quotes. SQL*Plus searches for the file in the current working directory. The operating system file should contain a single SQL statement or PL/SQL block. The statement should not be terminated with a semicolon. If a SQL*Plus command or more than one SQL statement or PL/SQL block is loaded into the SQL buffer from an operating system file, an error occurs when the RUN or slash (/) command is used to execute the buffer. The GET command can be used to load files created with the SAVE command. See the SAVE command in this chapter for more information. Examples
To load a file called YEARENDRPT with the extension SQL into the buffer, enter
GET YEARENDRPT
Procedure XTSP_GetAllChildItemByUpCode(sUpCode in varchar2,
DCode out CharArrayType,
DName out CharArrayType,
Dquantity out Numarraytype,
Dre out Chararraytype,
DItem out Numarraytype,
UpCode out Chararraytype);
或
CURSOR GetAllItems IS SELECT A.DCode,A.DName,A.Dquantity,A.Dre,A.DIt
em,A.UpCode FROM temptemp1 A where not exists( select 'x' from XtdetamsAll_Det
ail B where b.upcode = A.DCode ) order by A.nLevel,A.UpDItem,A.DItem;