摘要: 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)
摘要: 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)
摘要: 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)
摘要: 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)
摘要: 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)
摘要: 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)
摘要: 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)
摘要: 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 / 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)
摘要: define: 存储过程(Stored Procedure )是一组为了完成特定功能的SQL 语句 集,经编译后存储在数据库中。用户通过指定存储过程的名字并给出参数(如果该存储过程带有参数)来执行它。存储过程是数据库中的一个重要对象,任何一个设计良好的数据库应用程序都应该用到存储过程。存储过程是由流 阅读全文
posted @ 2017-10-29 23:39 杨杨yang 阅读(803) 评论(0) 推荐(0)