?? ch12_xml02.sql
字號:
/* Extract and display the URL for Munising Falls */
<<demo_block>>
DECLARE
fall SYS.XMLType;
url VARCHAR2(80);
BEGIN
--Retrieve XML for Munising Falls
SELECT fall INTO demo_block.fall
FROM falls f
WHERE f.fall_id = 1;
--Extract and display the URL for Munising Falls
url := fall.extract('/fall/url/text()').getStringVal;
DBMS_OUTPUT.PUT_LINE(url);
END;
/
/*======================================================================
| Supplement to the third edition of Oracle PL/SQL Programming by Steven
| Feuerstein with Bill Pribyl, Copyright (c) 1997-2002 O'Reilly &
| Associates, Inc. To submit corrections or find more code samples visit
| http://www.oreilly.com/catalog/oraclep3/
*/
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -