Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle SQL Jumpstart with Examples- P15: Review "As a consultant with more than 12 years of experience working with Oracle databases on a daily basis, reviewing this book was a unique and enjoyable experience. The SQL language is without doubt one of the most critical database skills and it is best learned by example. This book addresses that crucial need. Mr. Powell does an excellent job of clarifying the concepts by using meaningful and easy to understand examples. Frankly, I have not come across any other book on SQL that is as good a compilation of SQL concepts in a single. | A.16 FACTS.SQL 621 exception when others then dbms_output.put_line PROC factGenerate SQLERRM SQLCODE rollback end create or replace procedure facts i IN integer is j integer begin for j in 1.i loop factsGenerate delay 10000000 dbms_output.put_line Facts to_char j end loop end set serveroutput on exec dbms_output.enable 10000000 set timing on truncate table sales exec facts 1000 exec dbms_output.disable set serveroutput off declare cursor cSales is select from sales order by sale_qty begin for rSales in cSales loop update sales set sale_date SYSDATE 300 - rand 500 commit end loop end SPOOL OFF J Appendix A This page intentionally left blank B Please note that these scripts should be tested before use in a production environment. B.1 Tables set wrap off linesize 132 pages 80 column tab format a20 column col format a15 column pos format 990 column typ format a10 column tbs format a25 BREAK ON tab NODUPLICATES SKIP 2 ON NAME NODUPLICATES select t.table_name Tab c.column_name Col c.column_id Pos c.data_type Typ DECODE c.nullable N NOT NULL NULL Null t.tablespace_name Tbs from user_tables t user_tab_columns c where t.table_name c.table_name order by t.table_name c.column_id B.2 Constraints set wrap off linesize 132 pages 80 column tab format a20 column key format a10 column cons format a20 column col format a10 .
