Mercurial Mercurial > tips / comparison
summary | shortlog | changelog | graph | tags | bookmarks | branches | files | changeset | file | latest | revisions | annotate | diff | comparison | raw | help
Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
oracle.rst
changeset 2221 99a73de48647
parent 2220 f643c573f870
child 2226 d72d3ce66806
equal deleted inserted replaced
2220:f643c573f870 2221:99a73de48647 
     7    :local:
 
     7    :local:
 
     8 
     8 
     9 Oracle database development environment.
 
     9 Oracle database development environment.
 
    10 ========================================
 
    10 ========================================
 
    11 
    11 
    12   http://en.wikipedia.org/wiki/Oracle_SQL_Developer
 
    12 http://en.wikipedia.org/wiki/Oracle_SQL_Developer
 
    13                 Integrated development environment (IDE) for working with
 
    13   Integrated development environment (IDE) for working with
 
    14                 SQL/PLSql in Oracle databases.
 
    14   SQL/PLSql in Oracle databases.
 
    15   http://en.wikipedia.org/wiki/SQL*Plus
 
    15 http://en.wikipedia.org/wiki/SQL*Plus
 
    16                 An Oracle database client that can run SQL and PL/SQL commands
 
    16   An Oracle database client that can run SQL and PL/SQL commands
 
    17                 and display their results.
 
    17   and display their results.
 
    18   http://en.wikipedia.org/wiki/Oracle_Forms
 
    18 http://en.wikipedia.org/wiki/Oracle_Forms
 
    19                 Is a software product for creating screens that interact with an
 
    19   Is a software product for creating screens that interact with an
 
    20                 Oracle database. It has an IDE including an object navigator,
 
    20   Oracle database. It has an IDE including an object navigator,
 
    21                 property sheet and code editor that uses PL/SQL.
 
    21   property sheet and code editor that uses PL/SQL.
 
    22   http://en.wikipedia.org/wiki/Oracle_JDeveloper
 
    22 http://en.wikipedia.org/wiki/Oracle_JDeveloper
 
    23                 JDeveloper is a freeware IDE supplied by Oracle Corporation. It
 
    23   JDeveloper is a freeware IDE supplied by Oracle Corporation. It
 
    24                 offers features for development in Java, XML, SQL and PL/SQL,
 
    24   offers features for development in Java, XML, SQL and PL/SQL,
 
    25                 HTML, JavaScript, BPEL and PHP.
 
    25   HTML, JavaScript, BPEL and PHP.
 
    26   http://en.wikipedia.org/wiki/Oracle_Reports
 
    26 http://en.wikipedia.org/wiki/Oracle_Reports
 
    27                 Oracle Reports is a tool for developing reports against data
 
    27   Oracle Reports is a tool for developing reports against data
 
    28                 stored in an Oracle database.
 
    28   stored in an Oracle database.
 
    29 
    29 
    30 Useful PL/SQL stubs
 
    30 Useful PL/SQL stubs
 
    31 ===================
 
    31 ===================
 
    32 ::
 
    32 ::
 
    33 
    33 
    83   begin
 
    83   begin
 
    84     ret := MY_FUN();
 
    84     ret := MY_FUN();
 
    85   end;
 
    85   end;
 
    86   /
 
    86   /
 
    87 
    87 
    88 Database info.
 
    88 Database info
 
    89 ==============
 
    89 =============
 
    90 
    90 
    91 List of users::
 
    91 List of users::
 
    92 
    92 
    93   select distinct(OWNER) from ALL_TABLES;
 
    93   select distinct(OWNER) from ALL_TABLES;
 
    94 
    94 
   346   -- do stuff
 
   346   -- do stuff
 
   347   SET TIMING OFF;
 
   347   SET TIMING OFF;
 
   348 
   348 
   349 or::
 
   349 or::
 
   350 
   350 
   351   set serveroutput on
 
   351   set serveroutput on;
 
   352   variable n number
 
   352   variable n number;
 
   353   exec :n := dbms_utility.get_time;
 
   353   exec :n := dbms_utility.get_time;
 
   354   select ......
 
   354   select ......
 
   355   exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' );
 
   355   exec dbms_output.put_line( (dbms_utility.get_time-:n)/100) || ' seconds....' );
 
   356 
   356 
   357 In SQL Developer you get execution time in result window. By default SQL
 
   357 In SQL Developer you get execution time in result window. By default SQL
tips