Oracle database dmp to mysql format
The customer of the first project is oracle database, which needs to import a table data to the mysql database of the self research system. Party A has given the dmp file in oracle format! Treatment idea: ① . install Oracle database. ② Import the dmp file in Oracle format provided by Party A i ...
Added by SulleyMonstersInc on Thu, 10 Mar 2022 04:45:39 +0200
A sequence is a database object that helps tables to create automatically growing primary keys. Sequence is an object held in oracle database, which is not available in other databases.
Default syntax for creating sequences
create sequence Sequence name;
Much like creating a table
The full amount is cr ...
Added by jdeer0618 on Tue, 08 Mar 2022 06:09:20 +0200
1. Installation environment
1.1 installation of MSYS2+MinGW64
1. Download msys2, official address: http://www.msys2.org/ , select the 64 bit installer here
2. After the installation is completed, do not start msys2 first and install it in the root directory / etc / Pacman D / find mirrorlist mingw32,mirrorlist.mingw64 and mirrorlist Msys and ...
inout parameter mode of Oracle
Stored procedures and functions in Oracle can have parameters. The types of parameters can be specified as in, out and in out modes. IN: used to pass IN parameters When calling a procedure, the arguments are passed to the procedure Within a procedure, formal parameters are treated as read-only and cannot be chang ...
Added by mobile target on Tue, 01 Mar 2022 18:10:55 +0200
The customer in this case is from a provincial telecom. A large number of ORA-00600 errors in alert logs have affected the normal operation of the business.Fri Nov 19 16:07:09 2021Errors in file /u01/oracle/app/oracle/diag/rdbms/lcfa/LCFA1/trace/LCFA1_smon_5811.trc (incident=184182):
ORA-00600: internal error code, arguments: [41 ...
Added by kobayashi_one on Tue, 01 Mar 2022 12:40:45 +0200
1, Three paradigms of database
1. First paradigm (ensure that each column remains atomic)
2. Second normal form (ensure that every column in the table is related to the primary key)
3. The third paradigm (ensure that each column is directly related to the primary key column, not indirectly)
1. Relationship with c ...
Oracle connection query
Using a subquery in a where statement means adding a select statement to the where statement
Using subqueries in the from statement means adding a select statement to the from statement
Using a subquery in a select statement means adding a select statement to the select statement
Usage of ...
1, Trigger definition
Oracle trigger is a segment of PL/SQL program code that is triggered when the user makes a specific operation on the object of Oracle database. Triggered events include DML operations on tables, DDL operations of users, database events, etc.
2, Trigger classification
Triggers are divided into statement level triggers an ...
Added by morrisoner on Wed, 23 Feb 2022 05:15:51 +0200
Oracle database operation and maintenance scheme and optimization
Operation and maintenance optimization This paper explains in detail how to operate and maintain Oracle database, and explains how to operate and maintain it from all aspects.
In the last article, we talked about the performance optimization of Oracle database. In ...
I believe that ORACLE.mg is the most common database in the market As the password complexity verification script of ORACLE, SQL also plays an important role in the security of ORACLE. Probably because of my wrong search posture, I rarely find about utlpwdmg on the Internet SQL file (maybe because it's too simple???), I will analyze the file in ...
Added by frist44 on Mon, 21 Feb 2022 05:16:19 +0200