可以的。
select_into_statement
SELECT
[DISTINCT | ALL]
{* | select_item[, select_item]...}
INTO
{variable_name[, variable_name]... | record_name}
FROM
{table_reference | (subquery)}
[alias]
[, {table_reference | (subquery)}
[alias] ]...
rest_of_select_statement; select_item
{ function_name[(parameter_name[, parameter_name]...)]
| NULL
| numeric_literal
| [schema_name.]{table_name | view_name}.*
| [[schema_name.]{table_name. | view_name.}]column_name
| sequence_name.{CURRVAL | NEXTVAL}
| 'text'}
[ [AS] alias ]table_reference
[schema_name.]{table_name | view_name}[@dblink_name]
select_into_statement
SELECT
[DISTINCT | ALL]
{* | select_item[, select_item]...}
INTO
{variable_name[, variable_name]... | record_name}
FROM
{table_reference | (subquery)}
[alias]
[, {table_reference | (subquery)}
[alias] ]...
rest_of_select_statement; select_item
{ function_name[(parameter_name[, parameter_name]...)]
| NULL
| numeric_literal
| [schema_name.]{table_name | view_name}.*
| [[schema_name.]{table_name. | view_name.}]column_name
| sequence_name.{CURRVAL | NEXTVAL}
| 'text'}
[ [AS] alias ]table_reference
[schema_name.]{table_name | view_name}[@dblink_name]
解决方案 »
- ORACLE数据库UNIX服务器WAIT很大,怎么查询和处理
- 急求一oracle函数!源码
- 很感谢昨下午各位高手指点,那个汇总SQL的要求有些变化,那个帖子已经给分。
- oracle 9i 怎么备份数据库的的?进来告诉我一下吧
- 面试题 -- 取分组后的最新两条记录. 有请大家一齐讨论一下.[转]
- 大哥救命呀,一天了
- 糟了,装ias把o9i给破坏了。。
- 实现一个功能,请高手帮助!!
- 怎么查看一条SQL语句的执行情况,如有没有执行成功??在SQL/PL里
- oracle服务停止,报ntdll.dll错误。是什么引起的呢?
- 就问这是什么错误 java.sql.SQLException: ORA-04031: 无法分配 8192 字节的共享内存 ("large pool","unknown object","sort subheap"
在sybase和mssql中是成功的