Oracle SQL Developerの使い方および最新機能ご紹介

1 Oracle SQL Developer .. Oracle Java Oracle Corporation .. Copyright 2011, Oracle . All rights reserved. 2. Agenda SQL Developer . / .. DBA . Copyright 2011, Oracle . All rights reserved. 3. Oracle SQL Developer / . / . GUI SQL PL/SQL .. SQL Worksheet PL/SQL . PL/SQL .. SQL Developer Data Modeler Copyright 2011, Oracle . All rights reserved. 4. Oracle SQL Developer / .. Linux Windows Mac OS . Thin JDBC Oracle Home .. 200 . DB 11gR1, 11gR2 .. Copyright 2011, Oracle . All rights reserved. 5. SQL Developer .. RFP .. SQL Developer Data Modeler SQL Developer Enterprise Manager . CRUD .. (DDL ).. Copyright 2011, Oracle . All rights reserved. 6. SQL Developer . developer/.. Recovery Manager(rman) . Data Pump . / . Copyright 2011, Oracle . All rights reserved.

2 7. Agenda SQL Developer . / .. DBA . Copyright 2011, Oracle . All rights reserved. 8.. (Connection Navigator).. JDBC,TNS LDAP, (Bequeath).. OS Kerberos .. Copyright 2011, Oracle . All rights reserved. 9.. Exp/Imp .. Copyright 2011, Oracle . All rights reserved. 10.. ALTER TABLE . ( ) .. Copyright 2011, Oracle . All rights reserved. 11.. Copyright 2011, Oracle . All rights reserved. 12.. PL/Scope .. Copyright 2011, Oracle . All rights reserved. 13. BLOB: .. Copyright 2011, Oracle . All rights reserved. 14.. Copyright 2011, Oracle . All rights reserved. 15.. PDF .. HTML .. Excel . Copyright 2011, Oracle . All rights reserved. 16. Demonstration . Excel . Copyright 2011, Oracle . All rights reserved. 17. Agenda SQL Developer . / .. DBA . Copyright 2011, Oracle .

3 All rights reserved. 18. SQL .. SQL. Worksheet SQL .. Copyright 2011, Oracle . All rights reserved. 19.. Copyright 2011, Oracle . All rights reserved. 20. SQL .. Copyright 2011, Oracle . All rights reserved. 21. SQL . GUI . & .. WHERE .. SQL .. Copyright 2011, Oracle . All rights reserved. 22. SQL . Ctrl+Enter, F5 .. SQL Worksheet .. SELECT . Copyright 2011, Oracle . All rights reserved. 23. SQL .. Copyright 2011, Oracle . All rights reserved. 24. SQL . 25. Copyright 2011, Oracle . All rights reserved. SQL*Plus . SQL*Plus .. define . variable Show Describe set Copyright 2011, Oracle . All rights reserved. 26. PL/SQL .. Drag &Drop .. Copyright 2011, Oracle . All rights reserved. 27.. Copyright 2011, Oracle . All rights reserved. 28. PL/SQL . (refactoring).

4 Drag &Drop .. Copyright 2011, Oracle . All rights reserved. 29.. Java, PHP, C#, Visual Basic . +"SELECT ". +" , , ". +" , , ". +" , , ". +" AS MANAGER_ID1 ". +"FROM ". +" EMPLOYEES J, DEPARTMENTS I, ". +" LOCATIONS L". Java . Copyright 2011, Oracle . All rights reserved. 30.. PL/SQL . Copyright 2011, Oracle . All rights reserved. 31. PL/SQL .. 1. SET SERVEROUT ON . 2. DBMS_OUTPUT .. DBMS_OUTPUT .. Copyright 2011, Oracle . All rights reserved. 32. PL/SQL . SQL Developer .. Copyright 2011, Oracle . All rights reserved. 33.. PL/SQL.. APEX . SQL*Plus . execute ( ', 4000). Copyright 2011, Oracle . All rights reserved. 34. PL/SQL . ( ) ( ) .. SELECT .. Copyright 2011, Oracle . All rights reserved. 35. l Demonstration . PL/SQL . PL/SQL . PL/SQL . Copyright 2011, Oracle .

5 All rights reserved. 36. Agenda SQL Developer . / .. DBA . Copyright 2011, Oracle . All rights reserved. 37. DBA (DBA Navigator) #1.. ( , pfile).. / . RMAN(Recovery Manager). Copyright 2011, Oracle . All rights reserved. 38. DBA (DBA Navigator) #2. DataPump .. Copyright 2011, Oracle . All rights reserved. 39.. ALTER SYSTEM KILL SESSION. SQL . SQL .. Copyright 2011, Oracle . All rights reserved. 40.. Enterprise Manager . DDL . Copyright 2011, Oracle . All rights reserved. 41. SQL . 11gR2 . DB Tuning Option .. Copyright 2011, Oracle . All rights reserved. 42.. SELECT ( )PL/SQL .. SQL Developer Exchange Copyright 2011, Oracle . All rights reserved. 43. DBA .. Copyright 2011, Oracle . All rights reserved. 44. ASH, AWR . Copyright 2011, Oracle . All rights reserved.

6 45.. Copyright 2011, Oracle . All rights reserved. 46.. Copyright 2011, Oracle . All rights reserved. 47. SQL Developer .. Spatial . APEX . DBMS Scheduler UI. TimesTen PL/SQL . OTN DB . Copyright 2011, Oracle . All rights reserved. 48. OTN .. OTN .. / .. Copyright 2011, Oracle . All rights reserved. 49. OTN .. ( ) 100 . Database . Database . Database .. Java WebLogic Server/ .. EPM/BI . / .. OTN . Copyright 2011, Oracle . All rights reserved. 50.. etc.. SQL . etc.. Pick UP. / !? . Copyright 2011, Oracle . All rights reserved. 51. IT . / Oracle Database .. Oracle MASTER Viva! .. Developer . oracletech Copyright 2011, Oracle . All rights reserved. 52.. Oracle Direct . Oracle Direct IT . / . Web .. 0120 155 096.. 9:00 12:00 13:00 18:00.. Copyright 2011, Oracle .

7 All rights reserved. 53. Copyright 2011, Oracle . All rights reserved. Copyright 2011, Oracle . All rights reserved. 55.