sql¶à°æ±¾ÎÊÌâ - Oracle / »ù´¡ºÍ¹ÜÀí

1. ¶¯Ì¬sqlÓï¾ä±ØÐëʹÓð󶨱äÁ¿£¬·ÀÖ¹sql¶à°æ±¾µÄ³öÏÖ£¬Ó°ÏìЧÂÊ. sql¶à°æ±¾ÊÇʲôÒâ˼?¡£

2.SQL code:

SQL>set heading off
SQL>set echo off
SQL>set feedback off
SQL>set pages 10000
........



  ÀïÃæµÄheading .echo off .feedback .pages ÊÇʲôÒâ˼£¿

  ´ËÍ⻹ÓÐЩ£¬Ïñlinesize. clo<ÁÐ>for a<size>µÈµÈ£¬Ò»Ð©´°¿ÚÏÔʾÊä³ö±äÁ¿µÄÓ÷¨¡£
  ÍûÓùýµÄ¸ßÊÖ½âÊÍÏÂÓ÷¨£¬ÄÜÌṩÀý×Ó×îºÃ£¡

---

ºÙºÙ£¡³õѧÕߣ¬Â¥Ö÷Èç¹ûÄãÖªµÀÀ²£¡¿ÉÒÔ¸æËßÎÒÒ»ÏÂÂð£¿Ð»Ð»£¡

---

Âß¼­ÉÏÏàͬµÄSQL£¬µ«ÊÇÔÚд·¨Éϲ»Í¬£¨×Ö·û¼¶Ò»Ö£¬¶ÔÏóÏàͬµÈ£©£¬Ôì³ÉSQL¶à°æ±¾£¬Ö´Ðмƻ®²»Äܹ²Ïí¡£

---

set heading off ÈñêÌâ²»ÏÔʾ
SQL code:

SQL> set heading on;
SQL> select ename from emp where empno=7369;

ENAME
----------
SMITH

SQL> set heading off;
SQL> select ename from emp where empno=7369;

SMITH

---

1. Äã˵µÄ£¬ÊÇÖ¸£º

select * from v$sqlarea t where t.VERSION_COUNT > 1;
ͨ¹ýÉÏÃæµÄsql_id,¹ØÁªµ½v$sql²éѯ£º
select * from v$sql t where t.sql_id = '?';

v$sqlarea´æµÄÊÇparent_cursor, v$sqlÔòÊÇchild_cursor;

---

ÒýÓÃ

1. ¶¯Ì¬sqlÓï¾ä±ØÐëʹÓð󶨱äÁ¿£¬·ÀÖ¹sql¶à°æ±¾µÄ³öÏÖ£¬Ó°ÏìЧÂÊ. sql¶à°æ±¾ÊÇʲôÒâ˼?¡