Oracle

Create or Replace package Tx_pkg_pagepackage are type tx_resultlist is REF CURSOR; Procedure Tx_prc_pagination (tx_resultlist out Tx_resultlist,insql in Varchar2,currentpage in Number,pagecount in number ); End;create or Replace package body

1, Win+r, run regedit, enter the Registry Editor.650) this.width=650; "Src=" https://s4.51cto.com/wyfs02/M02/00/05/wKiom1mU_ZTw-bDjAAAwxumrmls450.png-wh_500x0-wm_ 3-wmp_4-s_1093241014.png "title=" 20170817101937.png "alt="

First, Oracle downloadOfficial Next AddressHttp://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html Win 32-bit operating system:/HTTP

Backup RecoveryConfigure RecoverabilityRedundancyControl file (mirror)Sql> Show Parameter Control_filesSql> select * from V$controlfile;To modify a path:$ cd $ORACLE _home/dbs$ CP Spfileorcl.ora Spfileorcl.ora.bakSql> alter system set control_files=

Title There are several places to be aware of when installing Oracle on Linux Systems 1. Select the System version 650) this.width=650; "src="%5c "title=" \ "1.png\"/"alt=" wkiol1mq6dmtvd4zaad0ygvy21k144.png\ "/>

Original: http://www.cnblogs.com/lambertwe/p/6116402.htmlToday in the project query process related information, found in the date of the word Gencun information is very strange, is a string of values, later found to be a long type or integer type

Revocation ManagementWhat is undo data:1. Transaction fallback: No transaction submitted can be rollback2. Transaction recovery: When the database crashes, the incorrect data of the disk is restored to the pre-transaction3. Read consistency: The

For example, now there's a table ID (number) StartTime (date) Name (VARCHAR2) 1 2017-08-13 Zhangsan 2 2017-08-14 Zhangsan Need to BULK Insert name Zhangsan, date

Deadlock:Session1:Sql> select * from T1;X----------12sql> Update T1 set x=11 where x=1;Session2:sql> Update T1 set x=22 where x=2;Session1:sql> Update T1 set x=222 where x=2; BlockingSession2:sql> Update T1 set x=111 where x=1; Dead lockERROR at

  Configuring Monitoring (1) Oracleoradb11g_home1tnslistener: Indicates the listener service, which must be turned on if the client wants to connect to the database. The service also has to work in the development of the program. (2)

Export from source database:exp user1/pwd@server1file=c:\temp\exp.dmp tables=(table1, table2)Import to target database:imp user2/pwd@server2file=c:\temp\exp.dmp tables=(table1, table2)Oracle has the advantage of being able to export remote data

Error deleting database table resolution methodSql> ALTER TABLE test1 enable row movement;//The line move function must be started before flash back otherwise an error is reported: ORA-08189: Cannot flash back to table because the line move feature

---Statistical invalidation index select SUM (A.AA) from (Select COUNT (*) AA from dba_indexes where status= ' unusable 'UNION ALLSelect COUNT (*) AA from dba_ind_partitions where status= ' unusable 'UNION ALLSelect COUNT (*) AA from

Sometimes this is a problem, we need to query a table, and to sort by business, for example, I need the following results:Area Date fee Product number user number290 201202 258 1 s1290 201202 1 S5290 201202 1 S100290 201202 2 S7290 201202 2 S9290 201

Today I ran into a SQL Error and communicated with my DBA colleague for a long time.The reason is that I added two field to a table in Dev, which is supposed to be nothing error,dev and sit without any problems, but Uat reported the wrong, so it is

ORACLE detailed installation and uninstallation stepsOracle Installation Steps1, the Win32_11gr2_database_1of2.zip and win32_11gr2_database_1of2.zip extracted to the current directory (PS: Select two compressed Package right-click Extract to the

B-tree and the B+treeat present, most database systems and file systems are used B-tree or its variants B+tree as the index structure. first, for a single node, it is a Key Value structure, Key is the column that makes the citation, value There are

1. View /u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.oraCat/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora# Tnsnames.ora Network Configuration File:/u01/app/oracle/product/11.2.0/db_1/network/admin/tnsnames.ora#

Data Dictionary/Dynamic Performance ViewSql> Conn Hr/hrsql> desc user_tables All tables in the current user nameSql> Select table_name from User_tables;Sql> desc user_viewsSql> select view_name from User_views;Sql> desc user_indexesSql> Select Index_

Instance ManagementMonitorStart monitoring:$ NETSTAT-TLNP | grep 1521$ lsnrctlLsnrctl> Help$ LSNRCTL Status$ lsnrctl Stop$ netstat-tln | grep 1521Fast Dynamic registration: (optional)$ sqlplus/as SYSDBASql> alter system register;$ LSNRCTL