This article will install the Oracle database management software SQLDeveloper on Ubuntu14.04.
This article will install the Oracle database management software SQL Developer on Ubuntu 14.04.
This is the second article about building Oracle
The parameters can be found in the 11g Official manual booklist -- DAT -- revoke uardconceptsandadministration -- 3.1 PreparingthePrimaryDatabaseforSta.
The parameters can be in the 11g Official manual book list -- DAT -- Data Guard Concepts and
We often use ldquo; setnamesutf8rdquo; To solve the garbled problem, so why can we solve this problem by adding this code? Let's dive into setn with me.
We often use ldquo; set names utf8rdquo; To solve the garbled problem, so why can we solve this
Optimize the SQL related to the hotspot table. If the SQL Execution takes too long, it will hold latch for a long time. For statements with a small number of returned results, check whether indexes and partition conditions are used.
Optimize the
MySQL memory table: 1. Use max_heap_table_size in My. cnf to specify dynamically. 2. The table definition is stored on the disk. The extension is. frm and will not be lost after restart.
MySQL memory table: 1. Use max_heap_table_size in My. cnf to
MySQL user database creation method: Create a database linuxidc, add a user doiido, the password is linuxidc.com, and only have permissions on the linuxidc database.
MySQL user database creation method: Create a database linuxidc, add a user doiido,
Currently, as an excellent RDBMS of Microsoft, SQLServer database has very few problems when it is started. When we use it at ordinary times, we seldom pay attention to the startup process, or
Currently, as an excellent RDBMS of Microsoft, the SQL
Use the Oraclespool command to copy the output results of SQL * plus to a specified file, or send the query results to the printer, directly using spoolof
Use the Oracle spool command to copy the output results of SQL * plus to a specified file, or
The program package is mainly used to implement program modularization. The program package can combine PLSQL programs such as stored procedures, functions, variables, constants, and cursors.
The main purpose of using a package is to modularize the
I have been confused about the differences between binlog and innodblog files in mysql. I have been wondering in my mind that the binlog log file can be used for database logs.
I have been confused about the difference between bin log and innodb log
First basic usage: first according to 11g before the connassysdba; createusertestidentifedbytest; ORA-65096: public user name or role name is invalid.
First basic usage: first according to 11g before the conn/as sysdba; create user test identifed by
Conclusion: The results of columnametypenotnull and check (columnnameisnotnull) are different. Therefore: 1. You do not need to manually match the NULLABLE attribute.
Conclusion: columname type not null and check (columnname is not null) results are
If all control files are lost or damaged, you need to restore them from the backup. The restorecontrolfile command is used to restore the control file. The logarithm is required after the control file is restored.
If all control files are lost or
Merge is a very useful feature. It is similar to mergeinto in DB2 and insertintoonduplicatekey in Mysql. MERGEINTO
Merge is a very useful feature. It is similar to merge into in DB2 and insert into on duplicate key in Mysql. MERGE
1. Use of
I have a general understanding of Oracle Database Upgrade today, but there are still many things worth considering. First, a lot of work needs to be done before the upgrade: 1. Testing and preparation, mainly
I have a general understanding of Oracle
Environment Planning: Host Name and IP address management node tong3192.168.1.249 master node tong2192.168.1.248 master node tong1 & nb ..
Environment Planning: Host Name and IP address management node tong3192.168.1.249 master node tong2192.168.1.24
Although many oracledbas have been familiar with Oracle for a long time, they are used to Baidu or Google if they cannot remember the syntax or find corresponding parameters. Although you have downloaded the official documentation
Although many
[Background] at noon today, the user reported that the connection password between the database and the application needs to be modified, and the password should not be changed. Did not expect Lunch Break
[Background] at noon today, the user
In Oracle databases, you can use variables to compile general SQL statements. When running SQL statements, input values for variables will replace the variables with these values in SQL statements.
In Oracle databases, you can use variables to
Oracle problems with number type conversion to_char
Oracle problems with number type conversion to_char
Oracle problems with number type conversion to_char
Select to_char (0.1) nums from dual;
It is observed that if the integer of a
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service