Oracle

1 definition: Runtime variables allow us to interact with SQL statements, allowing us to dynamically pass parameters when executing SQL statements2. Syntax:&varname3. run-time variables can appear in any locationFor example:Select &colname1,&colname2

Step one: Unzip the two Oracle database package and click Setup.exe to run the Setup programStep two: Wait for the installer to detect if the system meets the minimum configuration requirementsStep three: Install the interface directly click Next to

There are many ways to implement paging, but it is common to display paging through SQL.Here is the introduction of MyBatis to implement the Oracle paging: (PS: Different database of the wording of the difference)One, paging data :1

The current summary of the statement, in view of the data connection is very useful, after writing the program while testing the code side to see the release of database connections to help optimize the analysis of a robust system program.1.SQL code1

In Oralce, a SQL statement generates a lot of information when it executes: SQL Unique Identity SQL text Information Binding variable Information Execution plan and cursor information Statistical information Performance

Oracle Import Chinese garbled solution One, ensure that the encoding of each client character set is consistent with the server character set encoding1-Determines the sqlplus character set encoding, if Windows sets environment variables.2-Ensure

Three major types and implicit data type conversions in Oracle(1) varchar2 variable length/char fixed length-->number, for example: ' 123 '->123(2) Varchar2/char-->date, for example: ' 2 May-April -15 ', ' 2 May-April-15 '(3)

Processing method for Oracle 11g cannot export empty table with EXPExecute the following SQL query in Plsql Dev:Select ' '| | table_name| | ' allocate extent; ' from where num_rows=0Then you can export the empty table in the oracle11g after you

Classification of parameter files:Spfile:server parameter fileBinary format, out of file system bondageCan only be placed on server sideBetter consistencyOnly use SQL commands to modifySPFile priority is higher than pfileNaming rules: Spfile.ora &

The dual table is a virtual table that is used with the SELECT statement.1. View Current UserSelect User from Dual2. Used to call system functionsSelect To_char (sysdate, ' Yyyy-mm-dd hh24:mi:ss ') from dual----get current system timeSelect

1. Delete from T2. TRUNCATE TABLE TDifference:1. Delete is a DML operation; Truncate is a DDL operation and DDL Implicit commits cannot be rolled back2, delete from T can be rolled back, TRUNCATE TABLE t can not be rolled back3. TRUNCATE TABLE T

In Oracle, this is not unfamiliar with the LOGMNR tool analysis log, which is often used for data recovery scenarios, where it is convenient to analyze archived logs;Of course, there is a LOGMNR interface tool on the Internet; the download requires

Delete Nameless PRIMARY KEY statement:SELECT * from WHERE = ' Table name ' ; ALTER TABLE DROP CONSTRAINT primary Key name;The above statement needs to be manual, how to do it automatically? See below:CREATE OR REPLACE FUNCTIONDel_table_constraint

Zysong.ttf Download is an Oracle font garbled resolution tool, in essence, the lack of Chinese font package!01 Examples of the situation02 Examples of the situation01, in the beginning of the installation of garbledDownload Zysong.ttf,unzip

Oracle Database transactions1. What is a transactionIn a database, a transaction is a logical unit of work, a transaction consists of one or more SQL statements that complete a set of related behaviors, ensuring that the operations of this set of

Run cmd as follows input command sqlplus/as SYSDBA---------with sys login Super User (SYSDBA) ALTER user username account unlock; ---------unlocked (must be with ";" Alter user username identified password;  -------------Change your password and log

There are two simple examples to illustrate the efficiency issues of "exists" and "in"1. Select * from T1 where exists (select 1 from T2 where t1.a=t2.a);When the T1 data is small and the T2 data is very large, the exists query efficiency is high

Using node to connect Oracle It takes a little time to install the environment for those of you who have just started the node project or used MySQL

Oracle Basic data types:Oracle's basic data types are categorized by type: String type, data type, date type, LOB type, and so on.1. String Type:①char: fixed-length string that stores up to 2k bytes, and defaults to a length of 1 bytes without

Data source 1BeanID= "DataSource1"class= "Org.apache.commons.dbcp.BasicDataSource"> Propertyname= "Driverclassname"value= "Oracle.jdbc.OracleDriver" /> Propertyname= "url"value= "JDBC:ORACLE:THIN:@//IP address 1:1521/database name 1"