Oracle

The problem is to build a very early database in the time of the encounter, although this problem has a lot of relevant posts on the Internet, but because recently encountered many such questions, hereby simply record:1. The first problem

I. Oracle environment BUILDING 1. Installing Oracle 10gWe install the Orcale on the virtual machine and connect remotely. (1) Unzip the file 10201_database_win32.zip, and double-click the setup.exe in the extracted directory, the installation

What is a view? ）1. A view is a database object, a virtual table that is exported from one or more data tables or views, and the data corresponding to the view is not really stored in the view, but is stored in the referenced data table, and the

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"

Example 1: finding duplicate data in a table, repeating records are judged by a single field (Id), and the table is named student SELECT Id COUNT(1) from STUDENT T GROUP by having COUNT > 1Example 2: Delete redundant

Two methods of randomly fetching a record in OracleV_count int:=0;V_num INT: = 0;A continuous and unique column FID in the 1:tbl_mytable tableBEGINSELECT COUNT (*)Into V_countFrom Tbl_mytable;SELECT TRUNC (dbms_radom. VALUE (1,v_count+1)) into V_num

--Look up the name and size of the table spaceSELECT T.tablespace_name, round (SUM (Bytes/(1024x768)), 0) ts_size from Dba_tablespaces T, dba_data_files D WHERE t.ta Blespace_name = D.tablespace_name GROUP by t.tablespace_name;--Find the physical

Two methods:Method one, by backing up the table1. Create a backup tableCREATE TABLE T_bak as SELECT * FROM t2. Change the corresponding column data type after deleting the original table dataDelete from T3. Import the data from the backup table into

Sql>set Colsep '; -Field Output delimiterSql>set echo off; Displays each SQL command in the script started by the start, which defaults to onSql> set echo on//Set Run command is whether to display statementsSql> set feedback on; Set display "XX row

One: How to use a For loopTwo: How to use the stitching statement EXECUTE IMMEDIATE v_sql into v_work_orderid;Three: How to define record types as variables for storing and queryingCREATE OR REPLACE Package pkg_generatereport_biz are/*===============

1. After installing the Oracle database: Execute Dbstart and Dbshut will prompt:[Email protected] ~]$ DbstartOracle_home_listner is isn't SET, unable to auto-start Oracle Net ListenerUsage:/u01/app/oracle/oracle/product/10.2.0/db_1/bin/dbstart

1. Installing Plsql2. Download Oracle instance client, because my Plsql version is 12.1, only download 64-bit version, the old version will use 32-bit3. In the Oracle instance client build Network\admin folder, configureORCL =(DESCRIPTION

The specific installation tutorial will not write, there are many online.After the grid and Oracle are installed, the delay time of the building is several hours, permissions, monitoring what is done, is not found the problem, and then the use of

#切换到Oracle用户Su-oracle#登录sqlplusSqlplus/as SYSDBA#设置显示格式Set pagesize 300;Set Linesize 300;#查询用户列表及用户状态Select Username,password,account_status from Dba_users;#查看用户分配的权限SELECT * from Dba_role_privs order by GRANTEE;SELECT * from dba_role_privs where

1 You should start the service before each use of the database2 PL/SQL SQLPLUS is somewhat similar to the Eclipse used in JAVA development 3 Adding a table method to PL/SQL Developer :@ plus pathname (plus file name)4 security can be used in the

My system is Redhat 5.5 64 bit, Oracle is 11G R2Oracle 11g has an easy way to solve this problem with jdk1.5,jdk1.5, just build a fallback directory under $java_home/jre/lib/fonts/, Copy the fonts you want to use in Java to this directory, under

Write the SQL statement for the following query, using the EMP and dept tables of the Scott user as the query data:1. List all departments that have at least one employee.SQL statements:Select * from SCOTT. DEPTwherein(Selectdistinct from SCOTT.

Sets the method for archiving.1 sql> archive log list; #查看是不是归档方式2 sql> alter system set LOG_ARCHIVE_START=TRUE Scope=spfile; #启用主动归档Sql> alter system set log_archive_dest= "Location=/oracle/ora9/oradata/arch" scope=spfile;#设置归档路径Sql> alter system

1. After installing the Oracle database locally, it does not mean that you can connect with Plsql. If you are installing a 64-bit oracle,plsql, you cannot connect directly.2. If it is a 64-bit: You need to download an Oracle client that is not the

Error Demonstration:Sql> alter system set nls_date_format= ' Yyyy-mm-dd 24hh:mi:ss ' scope=spfile;System altered.After I changed the date format of the database, the database was not opened after the restart.Ora-01821:date format not recognized,