focusoracle.blogspot.com
WadeLiu Blog On Oracle: March 2009
http://focusoracle.blogspot.com/2009_03_01_archive.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Monday, March 9, 2009. Invoke the cursor valued stored function/procedure. 如果你的自定义的函数返回的是一个游标, 调用这个函数本身并不复杂, 但是怎样循环这个游标却比较诡异. 如下面的例子, FUN GET JOB INFO返回的游标不是直接来源于个表, 而是动态生成的一个recordset, 你不能将这个游标函数看作一个普通表一样,放在from从句中, 只能像普通游标一样使用它, 比如用Loop语句来遍历这个游标. 因为调用这个游标函数, 获得的其实就是一个游标. Fetch这个cursor的row时候, 不能将它直接将整个row放到你自定义的row 类型变量中, 这会引起convert错误. 你应当将这个row分解成若干个字段, 将row放到这些字段中. FETCH CURSOR1 INTO V JOB CODE, V JOB NAME;. JOB ROW ;.
focusoracle.blogspot.com
WadeLiu Blog On Oracle: Oracle explicit cursor and implicit cursor
http://focusoracle.blogspot.com/2009/04/oracle-explicit-cursor-and-implicit.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Thursday, April 2, 2009. Oracle explicit cursor and implicit cursor. 对于那些仅仅返回一行记录的SQL语句, 本身又没有显式地使用Open语句, 其实就是隐式游标. SELECT ename, sal INTO ena, esa FROM EMP WHERE EMPNO = 7844;. Note: Ename and sal are columns of the table EMP and ena and esa are the variables. Used to store ename and sal fetched by the query. 显式游标, 其实显式游标也可以分为显式打开的游标, 和隐式打开的游标, 对于前者, 应该在最后关闭游标. CURSOR trip cursor IS. SELECT bt id pk, bt hotel id. DBMS O...
focusoracle.blogspot.com
WadeLiu Blog On Oracle: use PLSQL in SQLPLUS
http://focusoracle.blogspot.com/2008/05/use-plsql-in-sqlplus.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Wednesday, May 14, 2008. Use PLSQL in SQLPLUS. 正常情况下, SqlPlus是一个行命令工具, 你只能在其中运行标准的SQL语句或者是SqlPlus特有的命令, 比如print或desc. 但有两种方法, 可以使得SqlPlus进入PL-SQL模式(可以执行诸如dbms out.output line()等PL-SQL函数). 在SqlPlus的提示符下输入begin并回车, 接下来几行输入你的代码, 然后输入end并回车, 最后一行输入/. 在SqlPlus的提示符下输入declare 然后回车, 然后声明变量(可选项), 接下来输入Begin并回车, 接下来几行输入你的代码, 然后输入end并回车, 最后一行输入/. V dname VARCHAR2(14);. V dname := 'HR';. Dbms output.put line(v dname);.
focusoracle.blogspot.com
WadeLiu Blog On Oracle: invoke the cursor valued stored function/procedure
http://focusoracle.blogspot.com/2009/03/invoke-cursor-valued-stored-function.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Monday, March 9, 2009. Invoke the cursor valued stored function/procedure. 如果你的自定义的函数返回的是一个游标, 调用这个函数本身并不复杂, 但是怎样循环这个游标却比较诡异. 如下面的例子, FUN GET JOB INFO返回的游标不是直接来源于个表, 而是动态生成的一个recordset, 你不能将这个游标函数看作一个普通表一样,放在from从句中, 只能像普通游标一样使用它, 比如用Loop语句来遍历这个游标. 因为调用这个游标函数, 获得的其实就是一个游标. Fetch这个cursor的row时候, 不能将它直接将整个row放到你自定义的row 类型变量中, 这会引起convert错误. 你应当将这个row分解成若干个字段, 将row放到这些字段中. FETCH CURSOR1 INTO V JOB CODE, V JOB NAME;. JOB ROW ;.
focusoracle.blogspot.com
WadeLiu Blog On Oracle: May 2008
http://focusoracle.blogspot.com/2008_05_01_archive.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Wednesday, May 14, 2008. Use PLSQL in SQLPLUS. 正常情况下, SqlPlus是一个行命令工具, 你只能在其中运行标准的SQL语句或者是SqlPlus特有的命令, 比如print或desc. 但有两种方法, 可以使得SqlPlus进入PL-SQL模式(可以执行诸如dbms out.output line()等PL-SQL函数). 在SqlPlus的提示符下输入begin并回车, 接下来几行输入你的代码, 然后输入end并回车, 最后一行输入/. 在SqlPlus的提示符下输入declare 然后回车, 然后声明变量(可选项), 接下来输入Begin并回车, 接下来几行输入你的代码, 然后输入end并回车, 最后一行输入/. V dname VARCHAR2(14);. V dname := 'HR';. Dbms output.put line(v dname);.
focusoracle.blogspot.com
WadeLiu Blog On Oracle: December 2007
http://focusoracle.blogspot.com/2007_12_01_archive.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Sunday, December 30, 2007. Keywords: Oracle 大牛, Guru. Http:/ Wzy25.itpub.net. Http:/ blue-prince.spaces.live.com. Http:/ www.orawh.com. Http:/ zhaolinjnu.blog.sohu.com. Http:/ www.hellodba.com. 另外, Taobao DBA Team http:/ www.taobaodba.com/. Keywords: Label, Placeholder. I add some labels in this blog. The labels will act as categories. The label list will update according to posts' categories. Keywords: DBA, Career, Oracle.
focusoracle.blogspot.com
WadeLiu Blog On Oracle: April 2009
http://focusoracle.blogspot.com/2009_04_01_archive.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Thursday, April 2, 2009. Oracle explicit cursor and implicit cursor. 对于那些仅仅返回一行记录的SQL语句, 本身又没有显式地使用Open语句, 其实就是隐式游标. SELECT ename, sal INTO ena, esa FROM EMP WHERE EMPNO = 7844;. Note: Ename and sal are columns of the table EMP and ena and esa are the variables. Used to store ename and sal fetched by the query. 显式游标, 其实显式游标也可以分为显式打开的游标, 和隐式打开的游标, 对于前者, 应该在最后关闭游标. CURSOR trip cursor IS. SELECT bt id pk, bt hotel id. DBMS O...
focusoracle.blogspot.com
WadeLiu Blog On Oracle: Oracle video and audio resource
http://focusoracle.blogspot.com/2008/01/oracle-video-and-audio-resource.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Thursday, January 24, 2008. Oracle video and audio resource. Keywords: Oracle, video, audio, resource, training, tutorials. Http:/ www.oracle.com/podcasts/index.html. Oracle Technology Network TechCasts. Http:/ feeds.feedburner.com/OTN TechCasts. Http:/ feeds.feedburner.com/OracleDatabaseInsider. Oracle Knowledge Base Podcast. Http:/ oracle.ittoolbox.com/research/podcasts/. Subscribe to: Post Comments (Atom).
focusoracle.blogspot.com
WadeLiu Blog On Oracle: July 2008
http://focusoracle.blogspot.com/2008_07_01_archive.html
WadeLiu Blog On Oracle. This blog is to record my work tips and thoughts of Oracle. Monday, July 28, 2008. One Oracle Unit Test Package- PLUTO. Pluto-test-framework ( http:/ code.google.com/p/pluto-test-framework/. PLUTO is lightweight, easy to install, and is free and open for everyone to use. Please feel free to give it a spin and comment back with any feedback that you might have. Why can not Universal Installer create Listener Service. Subscribe to: Posts (Atom). One Oracle Unit Test Package- PLUTO.