Oracle

1, check the user's proifle is which, is generally default:Sql>select username,profile from Dba_users;2. View the password expiration settings for the specified profile (such as default):Sql>select * from Dba_profiles s WHERE s.profile= ' DEFAULT '

Go home every day to play until 9:30 to say ...Today, another class in NetEase Cloud class, from a simple query began to talk about1, distinct to heavy, as if no difference2, alias, there is no difference3, arithmetic, same4, the connector, has seen

Sometimes write Oracle in the use of information such as cursors to loop processing logic, the exit, RETURN, continue is easy to confuse, the web search information is not very clear, so I wrote a small piece of code to test the three usage. The

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the select * from table where Id in (the Select ID from table group Byid having count (ID) > 1

--row to column custom function, only for TABLE1 table--Paramtype is a parameter type that is used to determine that param1 and param2 are condition parametersCreate or Replace functionMy_concat (Paramtypeinch integer, param1inch varchar2,

One: Start Oracle[Email protected] ~]# su-l Oracle[Email protected] ~]$ Sqlplus/nologSql*plus:release 10.2.0.4.0-production on Mon June 13 14:11:16 2016Copyright (c) 1982, Oracle. All rights Reserved.Sql> Conn/as SYSDBA Connected to an idle instance.

1. Copy table structure and table dataCREATE TABLE Table_new as SELECT * from Table_old2. Duplicate table structureCREATE TABLE Table_new as SELECT * from Table_old where 1<>13. Copying the specified fields of a tableCREATE TABLE Table_new as select

Prior to the online search by the order in the specified sequence of methods, according to Charindex to deal with the sorting, but the Oracle found no, because Oracle has no charindex function, and then use InStr instead of charindex, and then on

/*** Copy any row in the Oracle table and change the corresponding sequence* /DeclareCursor Dept_cursor is a select * from Scene_pic WHERE picid= ' 63563908576556815641 ';BeginFor Dept_rs in Dept_cursorLoopDept_rs. picid:= ' 63563908576556815642

Main content: User and table space; tables and constraints; Query statements.I. OverviewOracle Installation: Visit the website, downloadSecond, the User and table spaceYou can log in to Oracle with SQL Puls in the Start menu when you install Oracle.1

1. Modify the host name:# sed-i "s/hostname=localhost.localdomain/hostname=oracledb/"/etc/sysconfig/network# hostname OracleDB2. Add resolution host name record# vi/etc/hosts192.168.1.11 OracleDB3. Installing dependent Packages# yum-y Install glibc*

Java programs Packagecom.test;Importjava.sql.CallableStatement;Importjava.sql.Connection;ImportJava.sql.ResultSet;Importjava.sql.SQLException;Importjava.sql.Types;ImportCom.jdbc.BaseJdbcDAO;Importoracle.jdbc.OracleTypes; Public classTest {/***

[Email protected] ~]# su-oracle[Email protected] ~]$ Sqlplus/nologSql> Conn/as sysdba;Sql> Show user;USER is "SYS"Sql> select name from V$datafile;Create a temporary table spaceCreate temporary tablespace xsgj_tempTempfile

Today's study of Oracle encountered this problem ora-01033:oracle initialization or shutdown in progress, after the analysis of the study finally solved, write down a memorial. My library is Oracle 9i, specifically 90.First of all: the cause of the

--Create TableCreate TableCOURSE (CNOVARCHAR2(5) not NULL, CNAMEVARCHAR2( -) not NULL, TNO Number not NULL) tablespace USERS pctfreeTenInitrans1Maxtrans255Storage (initial 64KNext1M minextents1Maxextents Unlimited);--Add comments to the

In a paged query, you need to use pseudo-column rownum, the code is as follows:SELECT * FROM (select RowNum RN, name from cost where rownum 3;But the first time with RowNum, the second use RN, position can not change, otherwise error, the first time

1. Create a temporary table spaceCreate Temporary tablespace appstemptsp ' /oracle/app/oracle/oradata/orcl/appstemp01.dbf ' onnext 32m maxsize 2048mextent management local;2. Create a table

Archive Log (Archive log) a non-active redo log backup. By using the archive log, you can keep all the redo history, when the database is in Archivelog mode and log-switched, and the background process arch will save the contents of the redo log to

The database was queried and modified by Hibernate + MySQL, because MySQL database is simpler than Oracle database, recently read Oracle's book, this afternoon tried the next Hibernate framework to operate the Oracle database:1. Create a new WEB

DECLARE CURSOR city_cur isSelect t.new_customer_id,t.old_customer_id fromCITSONLINE.CRM_CUSTOMER_TMP6 Twhere t.new_customer_id!=t.old_customer_idOrder BY new_customer_id;BeginFor my_cur in City_cur loopUpdate Platform.crm_service_customer_bak SSet s.