Funda 1 > Global_table
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Funda 1 > Global_table as PDF for free.
More details
- Words: 133
- Pages: 2
sql> sql> create global temporary table tx as select * from dept; table created. sql> sleect * from tx; sp2-0734: unknown command beginning "sleect * f..." - rest of line ignored. sql> select * from tx; no rows selected sql> sql> insert into tx(select * from dept); 4 rows created. sql> select * from tx; deptno ---------10 20 30 40
dname -------------accounting research sales operations
loc ------------new york dallas chicago boston
sql> commit; commit complete. sql> / commit complete. sql> select * from tx; no rows selected sql>
insert into tx(select * from dept);
4 rows created. sql> select * from tx; deptno ---------10 20 30 40 sql>
dname -------------accounting research sales operations
commit;
commit complete. sql> select * from tx; no rows selected
loc ------------new york dallas chicago boston
sql> spool off
dname -------------accounting research sales operations
loc ------------new york dallas chicago boston
sql> commit; commit complete. sql> / commit complete. sql> select * from tx; no rows selected sql>
insert into tx(select * from dept);
4 rows created. sql> select * from tx; deptno ---------10 20 30 40 sql>
dname -------------accounting research sales operations
commit;
commit complete. sql> select * from tx; no rows selected
loc ------------new york dallas chicago boston
sql> spool off
Related Documents
Funda 1 > Global_table
November 2019 4
Funda 1 > Manual_database
November 2019 2
Pretest 1- Funda
June 2020 4
Electricity Funda
May 2020 14
Funda Practicas.docx
December 2019 19