Ò»¸öpl/sqlÎÊÌâ - Oracle / ¿ª·¢

ÎÒÊÇÔÚtoadÖÐÊäÈë϶Îsql
  declare
  TYPE test_rec IS record(
  code varchar(10),
  name varchar(30)
  );
  v_book test_rec;
   
  begin
  v_book.code:='1001';
  v_book.name:='java±à³Ì˼Ïë';
  dbms_output.put_line(v_book.code||v_book.name);
  end;
Ö´Ðкó±¨02:14:17 Error: ORA-00900: invalid SQL statement

  ÓÖÁíÍâÊäÈëÁËÏÂÃæµÄÕâ¶Î declare
  v_acct_id ACCOUNT.ACCT_ID%Type;
  begin
  SELECT ACCT_ID INTO v_acct_id from ACCOUNT WHERE ROWNUM<2;
  dbms_output.put_line(v_acct_id);
  end;

»¹ÊDZ¨Í¬ÑùµÄ´íÎó¡£why???ʲôµØ·½²Ù×÷´íÎóÁË£¿

---

»·¾³PL/SQL DEVELOP

---

Ææ¹Ö£¬ÎªÊ²Ã´ÎÒÔÚpl/sqlÀïÔËÐоÍûÎÊÌâ
Äã×Ðϸ¼ì²éÊÇ·ñÓÐʲôÒþ±Î×Ö·û¡£

---

TOADÀï¾Í±¨´íÁË£¿£¿
why???

---

Óï¾äûÓдíÎó
»³ÒÉÊÇtoadʹÓÃÉϵÄÎÊÌâ

---

ÎÒÔËÐÐÁËһϣ¬ÊǺÃÓõģ¬LZÊÇÔõôÔËÐеÄÄØ£¿Ó¦¸Ã²»ÊÇÓï¾äµÄÎÊÌâ¡£

---

¾Í°ÑÉÏÃæµÄÓï¾äÌùµ½¶íeditorÀïÃ棬°´Ö´Ðа¡¡£¡£¡£

---

TOADÀïÖ´ÐÐͨ¹ý.TOAD 8.5

---

ÎÒµÄÊÇToad for Oracle 9.6.1

²»»áÊÇÉèÖÃÉÏÓÐÎÊÌâ°É¡£¡£¡£

---

ÔÚÄÄÖ´Ðеģ¿toadÖÐÊDz»ÄÜÖ±½ÓÖ´ÐеÄ

---

toadÀïµÄpl/sql editor °¡

ÎÒ½øÈëtoadʱ ÓÒÏ·½ÓÐÈý¸öeditor ÆäÖÐ×îºóÒ»¸ö LDAP Editor ÊÇ»ÒÉ«µÄ¡£¡£¡£
²»ÖªµÀΪɶ£¬É¶¶¼Ã»Åª£¬¾ÍÖ±½Ó°²×°ºó¾ÍÕâÑùÁË

---

[code=SQL][/code]SQL> set serveroutput on;
S