Oracle

First, login issues1, forget the user name password:(1) Default User name password:System/manager Sys/change_on_install Scott/tiger(2) CMD log in as a system administrator:C:\users\samsung>sqlplus System/manager as SysdbaView all User:Sql> select

Original url:http://www.2cto.com/database/201203/122387.htmlOracle Cursor Concepts Explained What is a cursor?      ① retrieves the result set from the table, and the mechanism from which each point points to a record for interaction.   The

 Reproduced1. For ' 1 ', ' 2 ', ' 3 ', ' 4 ', ' 5 ' (comma outside the string) sql> SELECT column_value from TABLE (SYS.  Odcivarchar2list (' 1 ',' 2 ',' 3 ',' 4 ',' 5 ')); Column_value -----------------------------------------

There are many kinds of database processing models for hierarchy, which can be designed according to their own requirements. Of course, the simplest and easiest model is the so-called adjacency model. In this regard, other databases, such as Oracle,

Reprint: http://blog.csdn.net/jojo52013145/article/details/6758279In an actual application, in order for the PL/SQL function to return multiple rows of data, it must be done by returning a REF CURSOR or a data collection. This case of REF CURSOR is

BackgroundBecause the Oracle database has an archive mode turned on, often because the archive log file is too large to connect to the database, it is necessary to manually clean up the archive log after the problem is discovered, and it may have

The following examples illustrate:Sql> Set Linesize 200Sql> Show Parameter Nls_date_languageNAME TYPE VALUE------------------------------------ ---------------------- ------------------------------Nls_date_language string AMERICANSql> Show Parameter

Configure Oracle 11g Green client and PLSQL environmentThis approach is done by using the Oracle-provided lite client, which is a green, free-to-install client. There are many versions of the Instant client: primarily basic and basic Lite. The basic

Query all table names:Select T.table_name from User_tables t;Query all field names:Select T.column_name from User_col_comments t;Query all field names for the specified table:Select T.column_name from user_col_comments t where T.table_name = '

Transfer from http://www.51testing.com/html/99/478599-842622.htmlToday, after the installation of Oracle , start monitoring, error is as follows:Start Tnslsnr: Please wait ... Tnslsnr for 32-bitWindows: Version 10.2.0.1.0-production writes to

Stored procedures:Create or Replace procedure my_procedure (In_no in Number,in_name on VARCHAR2) isBeginINSERT into EMP (empno,ename) values (in_no,in_name);EndJava Program Demo:Import java.sql.CallableStatement;Import java.sql.Connection;Import

Data Block Overview Oracle manages the storage space in a database data file (datafile) as a data block. A data block is the smallest (logical) unit of data in a database. Corresponding to the data block, the smallest physical storage unit of all

1. The difference between Oracle's OCI Driver and Thin Driver①JDBC OCI:OCI is the abbreviation for Oracle call interface, which is similar to the traditional ODBC driver. Because it requires the Oracle call Interface and NET8, it needs to install

After installing the server with VirtualBox , you need to set up the network, if you have IP, you can directly connect to the physical network, if not, you can use the NAT network directly. Quick and easy to set up.Set up the network in the virtual

In project development, we often have some complex business logic. With Oracle's stored procedures, you can greatly reduce the amount of Java program code written, and the stored procedures are executed on the database, which can take advantage of

PL/SQL notes (1)-process control, loop, exception, block, plsqlProcess control 1.If, then, else, elsif (not elseif) if a='1' then null;endif; 2. Simple Case expression: search-type case expression: 3. goto statement beginif true then goto

An example of the row-to-column and column-to-Row Operations in Oracle Data Tables. Row-to-ColumnOne table The query result is -- Row-to-column Conversion select years,(select amount from Tb_Amount as A where month=1 and A.years=Tb_Amount.years)as

Oracle learning notes first knowledge Oracle, oracle learning notes first KnowledgeDatabase Introduction A Database is a warehouse that organizes, stores, and manages data according to the data structure. SQL is the acronym of Structured Query

Detailed introduction to services and services required for Oracle 11gAfter successfully installing the Oracle 11g Database, you will find that your computer runs slowly, and your computer with low configuration may even experience very bad

Oracle SQL Developer Connection error (ORA-12505)I had a problem with my Oracle database, and I finally got it done. Today I have created another DBA administrator connection method, and I will share my solution with you, I hope it will be useful to