上一页 1 ··· 58 59 60 61 62 63 64 65 66 ··· 76 下一页
2013年4月21日
[bbk5160]第16集 - Chapter 07-Using Explicit cursors
摘要： Cursor For LoopsSyntax:FOR record_name IN cursor_name LOOP statement1; statement2; ... END LOOP;The cursor FOR loop is a shortcut to process explict cursors.Implict open,fetch,exit and close cursor.The record isimplicit declared.Example:DECLARE CURSOR c_emp_curs... 阅读全文
posted @ 2013-04-21 12:00 ArcerZhang 阅读(180) 评论(0) 推荐(0) 编辑
[bbk5153]第15集 - Chapter 07-Using Explicit cursors
摘要： ObjectivesAfter completing this lesson,you should be able to do the following:Distinguish between implict and explicit cursorsDiscuss the reasons for using explicti cursorsDeclare and control explicit cursorsUse simple loops and cursor FOR loops to fetch dataDeclare and use cursors with parametersLo 阅读全文
posted @ 2013-04-21 11:44 ArcerZhang 阅读(230) 评论(0) 推荐(0) 编辑
2013年4月20日
Chapter -10-Creating Functions
摘要： ObjectivesAfter completing this lesson,you should be able to to do the following:Differentate between a procedure and a functionDescribe the uses of functionsCreate stored functionsInvoke a functionRemove a functionLesson AgendaWorking with functions:-Defferentiating between a procedure and a functi 阅读全文
posted @ 2013-04-20 23:13 ArcerZhang 阅读(288) 评论(1) 推荐(0) 编辑
ORA-00257: archiver error. Connect internal only, until freed.
摘要： ORA-00257: archiver error. Connect internal only, until freed.Oracle 10g数据库物理空间管理方式与以前Oracle发生了变化，对归档日志所在的Flash_Recovery_Area空间进行了另外限制 Flash_Recovery_Area空间缺省安装时比较小，只有2GB，容易用完解决过程 根据数据库目前可用存储空间情况、FLASH_RECOVERY_AREA空间为2GB的实际情况，把FLASH_RECOVERY_AREA的空间修改为20GB()。 SQL> alter system set DB_RECOVERY_FI 阅读全文
posted @ 2013-04-20 00:20 ArcerZhang 阅读(286) 评论(0) 推荐(0) 编辑
2013年4月19日
Chapter -09 Creating Procedures 04
摘要： Exceptions Not HandledCalling PathSome Procedures Demo可参考脚本:192.168.1.200[oracle@DG1 scripts]$ pwd/u01/oracle/scripts[oracle@DG1 scripts]$ lltotal 60-rw-r--r-- 1 oracle oinstall 886 Apr 19 15:35 call_calculate_blance.sql-rw-r--r-- 1 oracle oinstall 220 Apr 19 14:26 s09_01.sql-rw-r--r-- 1 oracle oins 阅读全文
posted @ 2013-04-19 23:56 ArcerZhang 阅读(158) 评论(0) 推荐(0) 编辑
Chapter -09 Creating Procedures 03
摘要： Passing Actula Parameters:Creating the add_dept ProcedureView Code CREATE OR REPLACE PROCEDURE add_dept( p_name IN dept.department_name%TYPE, p_loc IN dept.location_id%TYPE)ISBEGIN INSERT INTO dept(department_id,department_name,location_id) VALUES(departments_seq.NEXTVAL... 阅读全文
posted @ 2013-04-19 22:31 ArcerZhang 阅读(256) 评论(0) 推荐(0) 编辑
Chapter -09 Creating Procedures 02
摘要： Using the IN、OUT、IN OUTParameter Mode:ExampleDemo 01:IN KeywordsCREATE OR REPLACE PROCEDURE raise_salary( p_id IN emp.employee_id%TYPE, p_percent IN NUMBER)ISBEGIN UPDATE emp SET salary = salary * (1 + p_percent/100) WHERE employee_id = p_id;END ra... 阅读全文
posted @ 2013-04-19 16:51 ArcerZhang 阅读(293) 评论(0) 推荐(0) 编辑
Chapter -09 Creating Procedures 01
摘要： What Are Procedures?Are a type of subprogram that perform an actionCan be stored in the database as a schema object.Promote reusability and maintainabilityCreating Procedures:OverviewCreating Procedures with the SQL CREATE OR REPLACE StatementUse the CREATE clause to create a stand-alone procedure t 阅读全文
posted @ 2013-04-19 12:52 ArcerZhang 阅读(225) 评论(0) 推荐(0) 编辑
Chapter -09 Creating Procedures 00
摘要： ObjectivesAfter competing this lesson,you should be able to do the following:Identify the benefits of modualarized and layered subprogram design.Create and call procedures.Use formal and actual parametersUse positional,named ,or mixed notation for passing parameters.Identify the available parameter- 阅读全文
posted @ 2013-04-19 11:18 ArcerZhang 阅读(225) 评论(0) 推荐(0) 编辑
Chapter -03 Writing Executable Statements 02
摘要： placeholder 阅读全文
posted @ 2013-04-19 08:52 ArcerZhang 阅读(105) 评论(0) 推荐(0) 编辑
上一页 1 ··· 58 59 60 61 62 63 64 65 66 ··· 76 下一页