{"articleSearchList":[{"id":175,"title":"Oracle数据库中没有scott用户","titleArray":["","Oracle","数据库中没有scott用户"],"content":"使用SYS用户登录conn sys/密码 as sysdba（默认密码123456）然后找到oracle安装目录下scott.sql的这个文件然后执行命令：@+...","userName":"aojiancc2","url":null},{"id":176,"title":"Oracle自定义函数的简单使用","titleArray":["","Oracle","自定义函数的简单使用"],"content":"一.最最最简单的返回一个数字的函数createorreplacefunctionfun_show\r\nreturnint--申明返回值\r\nas\r\nbegin\r\nreturn1;\r\nend;...","userName":"aojiancc2","url":null},{"id":177,"title":"Oracle存储过程","titleArray":["","Oracle","存储过程"],"content":"一个简单的带输入输出参数的存储过程（求两数之和）createorreplaceprocedureproc_sum(p1int,p2int,presultoutint)\r\nas\r\nbe...","userName":"aojiancc2","url":null},{"id":179,"title":"Oracle事务的简单使用","titleArray":["","Oracle","事务的简单使用"],"content":"事务：　　事务是一个整体,这些操作要么全部执行成功，要么全部不执行。使用事务的原因：保证数据的安全有效。事务的四个特...","userName":"aojiancc2","url":null},{"id":181,"title":"Oracle编程基础","titleArray":["","Oracle","编程基础"],"content":"简单介绍一下oracle中if,else,case when,循环,异常处理等用法if,elsedeclareptypeint:=2;\r\nbegin\r\nifptype=1then\r\ndbms_out...","userName":"aojiancc2","url":null},{"id":182,"title":"Oracle使用游标","titleArray":["","Oracle","使用游标"],"content":"其实游标就是把查询的结果放入游标中，然后在去游标里边读取。相当于使用游标做了一个中转，而游标是可以作为参数进行传递...","userName":"aojiancc2","url":null},{"id":183,"title":"Oracle程序包","titleArray":["","Oracle","程序包"],"content":"当项目越来越大的时候，数据库中的函数，存储过程等越来越多。为了方便管理，Oracle建议使用程序包的管理机制。实现业务模...","userName":"aojiancc2","url":null},{"id":2302,"title":"Oracle中MERGE INTO，for，start with，decode用法","titleArray":["","Oracle","中MERGE INTO，for，start with，decode用法"],"content":"1. MERGEINTO:MERGEINTOT_TD_BU_MODIFY_NOTICE_LSA\r\nUSING(\r\nselectMODIFY_NOTICE_ID,REJECT_REASONfromT_TD_BU_MODIFY_NOT...","userName":"18784842332","url":null},{"id":3075,"title":"Oracle+命令","titleArray":["","Oracle","+命令"],"content":"oracle常用命令SQLPLUS进入oracle撤销命令revoke 权限 form 用户名show user查询当前登录账户锁定账户命令Alter user 用户...","userName":"18985279985","url":null},{"id":3077,"title":"Oracle 11g数据库的安装+空间管理","titleArray":["","Oracle"," 11g数据库的安装+空间管理"],"content":"如果你在圣诞节没有收到礼物，请不要伤心也不要难过，因为接下来还有元旦，春节，还有情人节，还有元宵节......慢慢的你就...","userName":"15985459135","url":null},{"id":3078,"title":"Oracle--常用命令、条件语句、循环语句、SQL函数","titleArray":["","Oracle","--常用命令、条件语句、循环语句、SQL函数"],"content":"Oracle常用命令1、登录数据库默认账户默认密码拥有权限sys 123456 as sysdba 拥有数据库的最高权限system ...","userName":"wang_cy","url":null},{"id":3079,"title":"Oracle数据库的基本操作","titleArray":["","Oracle","数据库的基本操作"],"content":"Oracle数据库Oracle Database，又名Oracle RDBMS，或简称Oracle。是甲骨文公司的一款关系数据库管理系统。它是在数据库领域...","userName":"Eason_zh","url":null},{"id":3080,"title":"Oracle数据库的认识和基本使用","titleArray":["","Oracle","数据库的认识和基本使用"],"content":"推荐一个Oracle数据库的一个学习网站：http://www.oraclejsq.com/article/010100110.html一、对Oracle数据库的认识1、数据...","userName":"heart320","url":null},{"id":3081,"title":"Oracle操作","titleArray":["","Oracle","操作"],"content":"Oracle数据库操作1、创建数据库create database databasename2、删除数据库drop database dbname3、备份数据库完全备份exp ...","userName":"songchaojiang","url":null},{"id":3082,"title":"Oracle 安装和常用的命令","titleArray":["","Oracle"," 安装和常用的命令"],"content":"Oracle 安装如下：https://jingyan.baidu.com/article/f79b7cb32095f79144023eae.html默认账户Sys 123456 as sysdba 数据...","userName":"maxingdy","url":null},{"id":3086,"title":"Oracle数据库的同义词与视图","titleArray":["","Oracle","数据库的同义词与视图"],"content":"同义词概念：同义词顾名思义，是数据库方案对象的一个别名。这里的数据库方案对象指表、视图、序列、存储过程、包等。创建...","userName":"Eason_zh","url":null}],"preArticle":{"id":3064,"title":".net core 引进实体","titleArray":null,"content":null,"userName":"JinRonghua12","url":null},"nextArticle":{"id":3230,"title":"Office2010安装与激活过程","titleArray":null,"content":null,"userName":"JinRonghua12","url":null}}