杨杨yang - 博客园

2017年11月2日

PL/SQL Developer import and export database method and illustrate

摘要： PL/SQL Developer import and export database method and illustrate HOW WELL DO YOU KNOW THE APPLE UNIVERSE? In 2015, Apple became the first company wor 阅读全文

posted @ 2017-11-02 23:23 杨杨yang 阅读(260) 评论(0) 推荐(0)

ORACLE_TRIGGER

摘要： PL/SQL TRIGGER Statement PL/SQL TRIGGER Statement The trigger statemet is a especially stored procedure.It define some event about database(such as,IN 阅读全文

posted @ 2017-11-02 23:08 杨杨yang 阅读(199) 评论(0) 推荐(0)

2017年11月1日

oracle_union_operator

摘要： SQL: UNION Operator This SQL tutorial explains how to use the SQL UNION operator with syntax and examples. SQL: UNION Operator This SQL tutorial expla 阅读全文

posted @ 2017-11-01 23:46 杨杨yang 阅读(418) 评论(0) 推荐(0)

how to determint wether two column equals

摘要： question: How to determint wether two column equals? Answer: Table one:RecordId = 1,CommonId = 5,Approved = 1. RecordId = 2,CommonId = 5 Approved = 0. 阅读全文

posted @ 2017-11-01 23:24 杨杨yang 阅读(244) 评论(0) 推荐(0)

how to create folders in batches

摘要： you need be good at thinking when you see problem. Work experience:when you need to copy web chinese,but web can't copy you can press F12 and find cor 阅读全文

posted @ 2017-11-01 21:14 杨杨yang 阅读(160) 评论(0) 推荐(0)

oracle_How to Recover Data (Without a Backup!）

摘要： How to Recover Data (Without a Backup!） It's the classic career-limiting maneuver(职业限制机动): accidentally deleting data you weren't meant to. It's easy 阅读全文

posted @ 2017-11-01 01:14 杨杨yang 阅读(245) 评论(0) 推荐(0)

2017年10月31日

ORACLE_DELETE

摘要： SQL DELETE Statement The SQL DELETE Statement The DELETE statement is used to delete existing records in a table. DELETE Syntax DELETE FROM table_name 阅读全文

posted @ 2017-10-31 23:41 杨杨yang 阅读(289) 评论(0) 推荐(0)

2017年10月30日

ORACLE_FUNCTION

摘要： FUNCTION: DEFINE：函数一般用于计算和返回一个值，可以将经常需要使用的计算或功能写成一个函数。 1.basic syntax create [or replace] function fun_name [(parameter1[,parameter2])...] return data 阅读全文

posted @ 2017-10-30 22:32 杨杨yang 阅读(199) 评论(0) 推荐(0)

ORACLE_ALIAS

摘要： Oracle / PLSQL: ALIASES website：https://www.techonthenet.com/oracle/alias.php This Oracle tutorial explains how to use Oracle ALIASES (temporary names 阅读全文

posted @ 2017-10-30 19:50 杨杨yang 阅读(353) 评论(0) 推荐(0)

2017年10月29日

oracle_procedure

摘要： define：存储过程（Stored Procedure ）是一组为了完成特定功能的SQL 语句集，经编译后存储在数据库中。用户通过指定存储过程的名字并给出参数（如果该存储过程带有参数）来执行它。存储过程是数据库中的一个重要对象，任何一个设计良好的数据库应用程序都应该用到存储过程。存储过程是由流阅读全文

posted @ 2017-10-29 23:39 杨杨yang 阅读(803) 评论(0) 推荐(0)