摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
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)
摘要:
FUNCTION: DEFINE:函数一般用于计算和返回一个值,可以将经常需要使用的计算或功能写成一个函数。 1.basic syntax create [or replace] function fun_name [(parameter1[,parameter2])...] return data
阅读全文
posted @ 2017-10-30 22:32
杨杨yang
阅读(199)
推荐(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)
摘要:
define: 存储过程(Stored Procedure )是一组为了完成特定功能的SQL 语句 集,经编译后存储在数据库中。用户通过指定存储过程的名字并给出参数(如果该存储过程带有参数)来执行它。存储过程是数据库中的一个重要对象,任何一个设计良好的数据库应用程序都应该用到存储过程。存储过程是由流
阅读全文
posted @ 2017-10-29 23:39
杨杨yang
阅读(803)
推荐(0)