最近看到历史项目里面的很多SQL， 我已经很无语了， 一段SQL 里面层层嵌套，而且有的嵌套层还是一样的。只是稍稍一点点条件不同而已。我见到了一个让我分析了一两个小时的SQL。 因为不是很懂原来的业务，只能从SQL 去倒推，猜想业务是什么样的。

Date: 2017-09-02 View: 1520

装了个oracle 10g ，装起来，确实很简单，但在安装前要注意网络环境检查，否则到后面会有问题。如果检查没有通过，可以自己添加硬件方式，添加一个Microsoft 的 Microsoft Loopback Adapter 的网络连接，并分配一个IP地址，就好了。安装完毕，用DBCA创建了数据库，并启动。其实可以创建很多数据库，每个数据库自己的实例作为一个服务启动，如何用ORACLE的EM来管理数据库呢。关键是要得到管理地址的URL.

Date: 2011-11-16 View: 1520

如果用ORACLE 做数据库编程，对于程序猿来说，常用的就是PL/SQL, 因为程序猿一般不实际数据库管理很深的知识。但必须对PL/SQL 很熟悉，这是开发部分，与管理部分不同。

整理了部分常用的 pl /sql 以备参考，今后记不住的时候，拿出来参考下，年纪大了，知道有那么个东西，但记不住，所以特别需要整理一下。

Date: 2012-08-23 View: 1520

This article shows you how to use AFTER DELETE TRIGGER, it will fire after the delete operation is executed. In real life scenarios, it is mostly used for purposes like:

Date: 2019-08-11 View: 1520

Spring Boot JDBC + Oracle database + Commons DBCP2 example

In this article, we will show you how to create a Spring Boot JDBC application + Oracle database + Commons DBCP2 connection pool.

Date: 2019-08-11 View: 1520

Spring Boot + Spring Data JPA + Oracle example

In this article, we will show you how to create a Spring Boot + Spring Data JPA + Oracle + HikariCP connection pool example.

Date: 2019-08-11 View: 1520

This article shows you how to use ALTER TRIGGER to rename a trigger.

Date: 2019-08-11 View: 1520

A quick JPA + Oracle sequences example, for self reference.

Date: 2019-08-11 View: 1520

This article shows you how to use AFTER UPDATE TRIGGER, it will fire after the update operation is executed.

Date: 2019-08-11 View: 1520

The following SQL shows you how to get the source code for a specified trigger :

Date: 2019-08-11 View: 1520

This article shows you how to use AFTER INSERT TRIGGER, it will fire after the insert operation is executed.

Date: 2019-08-11 View: 1520

This article shows you how to use BEFORE INSERT TRIGGER, it’s fire BEFORE an INSERT operation is executed. In real life scenarios, it is mostly used for purposes like

Date: 2019-08-11 View: 1520

This article shows you how to use ALTER TRIGGER and ALTER TABLE to enable and disable triggers.

Date: 2019-08-11 View: 1520

This article shows you how to use DROP TRIGGER to delete a trigger.

Date: 2019-08-11 View: 1520

This article shows you how to use BEFORE UPDATE TRIGGER, it’s fire before the update operation is executed. In real life scenarios, it is mostly used for purposes like:

Date: 2019-08-11 View: 1520