oracle输出书名，价格，游标的使用

 CREATE TABLE "XIAOFENG"."BOOK" 

   ( "BID" NUMBER(10,0) NOT NULL ENABLE, 

"BNAME" VARCHAR2(30 BYTE) NOT NULL ENABLE, 

"PRICE" NUMBER(8,3) NOT NULL ENABLE, 

"AUTHOR" VARCHAR2(20 BYTE) NOT NULL ENABLE, 

PRIMARY KEY ("BID")

  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

  TABLESPACE "USERS"  ENABLE

   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING

  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645

  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)

  TABLESPACE "USERS" ;

2001 java 22.5 Andy

2002 php 24.23 Jack lee

2003 JavaScript 55.6 Mark Bruce

2004 HTML 43 Mark Bruce

2005 CSS 32 Bruce lee

2006 Dolphin 42.23 Nick

2007 钢铁 32.23 奥斯特

2008 编程思想 32.23 unknown

2009 Ajax 43 unknown

2010 Office 32 Microsoft

2011 c# 32 Bell

2012 C++ 43 Hellen

2013 Oracle 43 petter

2014 MySql 43 Helly

2015 SQL server 32 Microsoft

输出语句：

set serveroutput on;

declare

 cursor cbook is select  bname,price from book;

 bookname book.bname%TYPE;

 bookprice book.price%TYPE;

 begin

 --打开光标

 open cbook;--光标名称

 loop

 fetch cbook into bookname,bookprice;--遍历光标的内容

 exit when cbook%notfound; --未找到时退出循环

 dbms_output.put_line('书名'||bookname||'价格'||bookprice);

 end loop;

 close cbook;--关闭光标

 

 end;

 /