C 公司小王因业务需要,需要将 SQL 语句执行结果输出到操作系统的文件中去。因此,小王执行如下 SPOOL 命令:SQL> SPOOL ./spool.txt;SQL> create table COUNTRY(Code int,Name varchar(20),Population;SQL> select Code,Name,Population from
COUNTRY ;SQL> select ‘This SQL will be output into ./spool.txt’ from SYS_DUMMY;where Population > 1000000; int);SQL> SPOOL OFF;SQL> select ‘This SQL will not be output into ./spool.txt’
FROM SYS_DUMMY;那么 spool.txt 文件中内容应该是:SQL> create table COUNTRY(Code int,Name varchar(20),Population int);Succeed.SQL>
Select Code,Name,Population from COUNTRY where Population > 1000000;CODE NAME POPULATION 0 rows fetched.SQL> select 'This SQL will be output into ./spool.txt'from SYS_DUMMY;'THIS SQL WILL BE OUTPUT INTO ./SPOOL.TXT'This SQL will be output into ./spool.txt 1 rows fetched.SQL> SPOOL OFF;
A.正确 B.错误正确答案A