Example 1: PHP, no line numbers

<div id="foo">
<?php
  function foo() {
    echo "Hello World!\\n";
  }
?>
</div>

Example 2: Java, with line numbers

1
2
3
4
5

public class Hello {
  public static void main(String[] args) {
    System.out.println("Hello World!");
  }
}

Example 3: Ruby, with line numbers starting at 18

18
19
20
21
22

class Example
  def example(arg1)
    return "Hello: " + arg1.to_s
  end
end

Example 4: If your code already has html entities escaped, use escaped=”true” as an option

<xml>Hello</xml>
winks@CCDB> SELECT name,CEIL(bytes/1024/1024) MB,status FROM v$datafile;
 
NAME                                                                           MB STATUS
---------------------------------------------------------------------- ---------- --------------
/home/oracle/app/oracle/oradata/ccdb/system01.dbf                             730 SYSTEM
/home/oracle/app/oracle/oradata/ccdb/sysaux01.dbf                            1037 ONLINE
/home/oracle/app/oracle/oradata/ccdb/undotbs01.dbf                            440 ONLINE
/home/oracle/app/oracle/oradata/ccdb/users01.dbf                                5 ONLINE
/home/oracle/app/oracle/oradata/ccdb/example01.dbf                            100 ONLINE
/home/oracle/app/oracle/product/11.1.0/db_1/dbs/USER_DATA_01.DBF                5 ONLINE
/home/oracle/app/oracle/product/11.1.0/db_1/dbs/WINKS_DATA_01.DBF              62 ONLINE
/home/oracle/app/oracle/oradata/ccdb/WINKS_DATA_EN_01.DBF                      37 ONLINE
 
已选择8行。

escaped=”true”

1
2
3
4
5
6
7
8
9
10
11
12
13

winks@CCDB> SET autotrace traceonly EXPLAIN
winks@CCDB> SELECT * FROM member;
 
执行计划
----------------------------------------------------------
PLAN hash VALUE: 3441279308
 
----------------------------------------------------------------------------
| Id  | Operation         | Name   | ROWS  | Bytes | COST (%CPU)| TIME     |
----------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |        |  1358 |   224K|    13   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| MEMBER |  1358 |   224K|    13   (0)| 00:00:01 |
----------------------------------------------------------------------------
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

winks@CCDB> SET autotrace traceonly statistics
winks@CCDB> SELECT * FROM member_client;
 
已选择1363行。
 
 
统计信息
----------------------------------------------------------
          1  recursive calls
          0  db block gets
        149  consistent gets
          0  physical reads
          0  redo size
     380811  bytes sent via SQL*Net TO client
       1354  bytes received via SQL*Net FROM client
         92  SQL*Net roundtrips TO/FROM client
          0  sorts (memory)
          0  sorts (disk)
       1363  rows processed