Programmer Group

Recently, I'm ready to start Mysql. I feel very interesting. I'm ready to study hard. I just saw the creation of mysql database, which is very different from Oracle. I feel that mysql database is similar to Oracle's schema, but there is schema in mysql. Apart from the cluster environment, Oracle has multiple databases and inst ...

All along, I think it's very easy to use the \ G parameter in MySQL to change the display mode of the output result set, especially in the command-line interface. But ORACLE database doesn't have this function. Today, when I searched a blog post of master Tom, I found that master used a stored procedure, print table, to implement such functions ...

Oracle storage functions The storage function is also a named PLSQL block. --Note: the stored procedure has no return value, but the stored function has a return value. The difference between stored procedure and stored function Generally speaking, the difference between a procedure and a function is that a function can ...

1. Install the main program and server of MariaDB database [root@fudanwuxi ~]# yum install mariadb mariadb-server.x86_64 [root@fudanwuxi ~]# systemctl restart mariadb.service [root@fudanwuxi ~]# systemctl enable mariadb.service Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/ ...

Here, we take Maven as an example to send the map first, then the text information of Maven and configuration file (easy to copy and paste); the Oracle11g database jar package is in the lib directory of Oracle database installation, which is not specifically introduced here Spring integrates Jpa configuration files: be careful, ...

Solution: ora-02199: missing datafile / tempfile clause OMF, the full name is Oracle Managed Files, that is, oracle file management. Using OMF can simplify the management of the administrator, without specifying the name, size, path of the file. Its name, size, path are automatically assigned by oracle. When deleting logs, data, ...

Configuration setting The server operating system IP address SQL SERVER Windows 2003 10.9.5.47 Oracle DB Linux 5.8 10.9.5.90 Oracle Gateways 1. Install transparent gateway After Oracle 11G, Gateways under linux ...

Recently, a problem was found when using mybatis generator to generate the entity classes corresponding to Oracle database. It is hereby recorded. Because the project uses swagger2, we want to generate the corresponding @ ApiMode and @ ApiModelProperty annotations through table annotations and field annotations when generating entity classes. H ...

Preface Apache Commons dbutils version 1.7 shows the calls that support stored procedures. Please pay attention to the version issue when using this code. 1.7 version update method int execute(String sql, Object… params) executes SQL statements, including stored procedure calls, which do not return any result sets. ...

First episode: http://www.arppinging.com/wordpress/?p=96 Table operation of oracle rookie learning 1. create table In oracle, create table is used to create a table SQL> create table student(sno number(6),sname varchar2(12),address varchar2(20)); Table created. SQL> desc student; Name Null? Type ...