Tag:oracle

  • Linux Oracle 9i graphic installation method I

    Time:2021-12-25

    Copyright notice: original works are allowed to be reprinted. When reprinting, please be sure to indicate the original source, author information and this notice in the form of hyperlink. Otherwise, legal responsibility will be investigated.http://waringid.blog.51cto.com/65148/47655It’s not easy for beginners to install Oracle database software under Linux. This rookie successfully installed it after tossing for a […]

  • Linux Oracle 9i graphic installation tutorial II

    Time:2021-12-24

    Preliminary work:Connected to Oracle 9i graphic installation I under Linux in the previous issue(https://www.jb51.net/os/RedHat/9918.html), the first point in the preparation for Oracle installation is to complete the installation of LinuxCD is required for installation Replace the disc as required during installation Complete the installation and restart the computer Login initial interface Set date and time […]

  • Linux Oracle 9i graphic installation tutorial III

    Time:2021-12-23

    Copyright notice:Original works are allowed to be reprinted. Please indicate the article in the form of hyperlink when reprintingOriginal source, author information and this statement. Otherwise, legal responsibility will be investigated.Preliminary work:The installation of Linux system and loading of corresponding software packages have been mentioned earlier. The reference address is as follows:Oracle 9i graphic installation […]

  • Linux Oracle 9i graphic installation tutorial IV

    Time:2021-12-22

    Preliminary work:The installation of Linux system and loading of corresponding software packages have been mentioned earlier. The reference address is as follows:Linux Oracle 9i graphic installation tutorial I(https://www.jb51.net/os/RedHat/9918.html), Linux Oracle 9i graphic installation tutorial II(https://www.jb51.net/os/RedHat/9919.html)Linux Oracle 9i graphic installation tutorial III(https://www.jb51.net/os/RedHat/9920.html)This section will start Oracle installation, including changing the path of Oracle’s default JRE and […]

  • Linux Oracle 9i graphic installation tutorial V

    Time:2021-12-21

    Copyright notice:Original works are allowed to be reprinted. Please indicate the article in the form of hyperlink when reprintingOriginal source, author information and this statement. Otherwise, legal responsibility will be investigated.Preliminary work:The installation of Linux system and loading of corresponding software packages have been mentioned earlier. The reference address is as follows:Linux Oracle 9i graphic […]

  • Linux Oracle 9i graphic installation tutorial 6 concluded

    Time:2021-12-20

    Copyright notice:Original works are allowed to be reprinted. Please indicate the article in the form of hyperlink when reprintingOriginal source, author information and this statement. Otherwise, legal responsibility will be investigated.Preliminary work:The installation of Linux system and loading of corresponding software packages have been mentioned earlier. The reference address is as follows:Linux Oracle 9i graphic […]

  • Sqlserver implements a before trigger example similar to Oracle

    Time:2021-10-7

    1. Before inserting data, judge whether the data exists SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO — ============================================= — Author: <Author,,Name> — Create date: <Create Date,,> — Description: <Description,,> — ============================================= alter TRIGGER CategoryExistTrigger ON ProductCategory instead of insert AS declare @categoryName varchar(50); BEGIN — SET NOCOUNT ON added to prevent extra result sets […]

  • Using Oracle stored procedures under Java (detailed explanation) page 1 of 3

    Time:2021-9-26

    Any reprint, please respect the copyright. (by iihero on CSDN)1、 How to create a Java stored procedure?There are usually three ways to create Java stored procedures.1. Use Oracle SQL statement to create:e. G. use create or replace and compile java source named “< name >” asFollow the Java source program. It is required that the […]

  • Oracle database 12C Chinese configuration installation tutorial (detailed installation steps)

    Time:2021-9-20

    Oracle database (also known as Oracle database)It is a large relational database designed by Oracle based on advanced structured query language (SQL). Generally speaking, it uses a language convenient for logical management to manipulate a large set of regular data. This article will introduce the installation and configuration tutorial of Oracle database 12C, for your […]

  • JSP connection method to MySQL / MS SQL Server / Oracle database [sorting]

    Time:2021-9-14

    Method of connecting JSP to MySQL databaseFirst, copy the MySQL database connection driver to the Tomcat / common / lib packageDownload mysql-connector-java-5.1.6.ziphttp://mysql.cs.pu.edu.tw/Downloads/Connector-J/mysql-connector-java-5.1.6.zip Configure Tomcat’s virtual directory – omittedCreate a JDBC mysql.jsp pageThe page code is as follows: Copy codeThe code is as follows: <%@ page contentType=”text/html;charset=gb2312″%> <%@ page import=”java.sql.*”%> <% final String MYSQLDBDRIVER=”org.gjt.mm.mysql.Driver”; final String […]

  • Oracle 11g installation tutorial under RedHat Linux 5.5

    Time:2021-9-2

    The best way to install Oracle system under Linux is 1G memory, 2G swap space, and at least 4.5g hard disk space. At least the environment is above Linux server release 5.3 For Linux server release 5.1, modify Oracle 10.2g 1、 View Linux version [[email protected] ~]# cat /etc/issueRed Hat Enterprise Linux Server release 5.5 (Tikanga) […]

  • The misunderstanding between MySQL and Oracle

    Time:2021-6-30

    Essential difference Oracle database is an object relational database management system MySQL is an open source relational database management system (free) The security of database MySQL uses three parameters to authenticate users, namely user name, password and location Oracle uses more security functions, such as user name, password, configuration file, local authentication, external authentication, advanced […]