Summary of Oracle Trigger

Examples of Oracle Trigger Usage Brief introduction of flip-flop The definition of a trigger means that when a condition holds, the statement defined in the trigger will be automatically executed. Therefore, triggers do not need to be called arti ...

Added by lexx on Fri, 06 Sep 2019 11:42:12 +0300

tcpdump and some default ports of linux

1. Common port number of HTTP proxy server: 80/8080/3128/8081/9098 2. Common port number of SOCKS proxy protocol server: 1080 3.FTP (File Transfer) Protocol Proxy Server Common Port Number: 21 4.Telnet (Remote Login) Protocol Proxy Server Comm ...

Added by smerny on Wed, 04 Sep 2019 06:30:27 +0300

Oracle creates partition tables and simple operations for partitions

oracle 11g supports automatic partitioning, but partitioning must be set when creating tables. If an existing table needs to be partitioned, it is necessary to rename the current table, create a new table, copy the data to the new table, and the ...

Added by sbourdon on Fri, 30 Aug 2019 11:18:29 +0300

Hotel Room Management System

Hotel Room Management System Hotel Room Management System mysql Database Creation Statement oracle database creation statement of hotel room management system SQL Server database creation statement for hotel room management system Hotel ...

Added by kalaszabi on Wed, 28 Aug 2019 08:40:13 +0300

On the problem of no scott user in Oracle12c

I am currently previewing through videos, learning that the teachers in the videos here want to log in to Scott users, but I can not log in, showing that users do not exist. Although the scott.sql file can also be found in Oracle files, but after creating users through online tutorials, I feel very troubled and unsuccessful, and finally after a ...

Added by NightFalcon90909 on Fri, 09 Aug 2019 14:03:45 +0300

Design and Implementation of Business Website for Small and Medium-sized Enterprises

Design and Implementation of Business Website for Small and Medium-sized Enterprises Design and Implementation of Business Website for Small and Medium-sized Enterprises Design and Implementation of Business Website for Small and Medium-sized Enterprises Design and implementation of business website ...

Added by lew14 on Wed, 07 Aug 2019 14:54:34 +0300

Install Java JDK 8 in CentOS 7/6.5/6.4

Original Link: http://www.cnblogs.com/cgfree/p/5397890.html This tutorial describes how to install and CentOS Configure the latest on servers 7, 6.5, and 6.4 Oracle JavaJDK for.Although these steps should also apply to other RPM-based d ...

Added by hongco on Mon, 05 Aug 2019 23:25:26 +0300

Oracle Backup and Recovery expdp/impdp Data Pump Remote Import and Export

Links to the original text: https://blog.csdn.net/imliuqun123/article/details/78624587 Oracle Backup and Recovery expdp/impdp Data Pump Remote Import and Export   Oracle has a very useful export tool expdp (data pump) at 10g. However, ...

Added by jamiefoxx on Thu, 01 Aug 2019 08:52:41 +0300

My docker essay 14: An example of MySQL operation

This article uses docker to run MySQL and do simple operations. This article uses MySQL as the official mirror, version 5.7. Download the mirror command: docker pull mysql:5.7 Run the container with the following command and set the root password to 123456. run --name hi-mysql -e MYSQL_ROOT_PASSWORD=1 ...

Added by widox on Wed, 31 Jul 2019 01:59:01 +0300

Thinking in SQL Series 6: Data Mining Apriori Association Analysis to Reproduce the Myth of Beer Diapers

When it comes to data mining machine learning, the myth about beer diapers has long been heard in my impression. This problem often appears in articles related to data warehouses, which shows how far and deep the beer diaper problem has impacted the field of data mining.Look first at the cause: The story of beer and diapers originated in Wal-Ma ...

Added by pothole_89 on Wed, 17 Jul 2019 20:37:02 +0300