Oracle

EnvironmentOperating system: Win8.1 Enterprise Oracle Development tools: PL/SQL Developer 7.0.1.1066 (MBCS)Steps to download instantclientOracle Instant Client download is available in downloads in http://www.oracle.com/cn/downloads/index.html

Solution for Oracle installation prerequisite Check Failure[Java] installation environment: Win7-64bit Pro, Memory 6G, hard disk space enough to install the version: Oracle Database 11g Release 2 (11.2.0.1.0) for Microsoft Windows (x64) installation

The dba_free_space shows a tablespace with free space, and if a tablespace is not contiguous, then there is a record in dba_free_space for each space. If a tablespace has several records indicating that the tablespace is fragmented, the tablespace

Original blog: http://blog.itpub.net/519536/viewspace-614893/Today, in the process of deploying a set of 10g Oracle (10.2.0.3 versions), ora-00600:internal error code, arguments: [Keltnfy-ldminit], [46], [1], [], [], [], [ ], [] error.Take this

Reference article:Http://blog.chinaunix.net/uid-26446098-id-3344813.htmlThe error message is as follows:From the wrong angle can be introduced: it should be insufficient table spaceDepending on the usage of the view tablespace, the command is as

I. Modification of/ETC/ORATAB#orcl:/u01/app/oracle/product/11gr2:norcl:/u01/app/oracle/product/11gr2:y change "N" to "Y"Second, modify the/u01/app/oracle/product/11gr2/bin directory Dbstart and DbshutRemove a commentOratab=/etc/oratabChange

Oracle DB allows external tables to be queried in read-only form. The external table can be stored in any storage device that can be read by Oracle DB, its contents are not saved in db, the DB only saves external table metadata,db can query (join,

Stones installation of OracleDatabase: is to put some records or call items, in the database application or software to manage. What are the benefits of such management? It can quickly retrieve a certain bar!Our common Excel can be seen as a simple

Previously used Oracle+extjs for project development, may have little contact with the SQL Server database is similar,As far as I am concerned, many projects are generally based on the ado.net+sqlserver2008 R2 (The Used Entity Framework (ORM)

Look at a SQLSelectQ.*, R.goods_name from(SelectNVL (T.goods_code, S.goods_code) Goods_code, T.buy_open_price, T.buy_position_price, T.buy_position_amount, S.sale_open_price, S.sale_position_price, S.sale _position_amount, (NVL

The core is the following two statements, tested Redhat 5 and Redhat 6, the statement of B C D for the SDB SDC SDD, etc., to be modified according to the actual situationRedhat 5For i in B c D E F g h i j k l m n o p; --Make adjustments according to

Today try to adjust the performance of the database, due to negligence did not do a good backup (Spfile.ora), directly modified the memory_target parameters,alter system set memory_target=4096m;Unable to connect to Oracle times when restarting

This article will show you how to generate a new collection and add data to it if you need to.Procedure Insert_object (d in Dept_array, D2 out Dept_array) isBegin --first to insert the data into a new array. SELECT CAST (MULTISET

Use a stored procedure to determine whether a person has stayed longer than the specified time in the travel track of a day.The stored procedure is used to determine whether a person has stayed for more than the specified time in the travel track of

An Oracle Database knows a table and queries a table with a primary foreign key relationship. -- Check whether the foreign key table NC56.CSCI has a corresponding primary key table SELECT. owner,. TABLE_NAME primary_table_name,. CONSTRAINT_NAME

ORA-00911: invalid character Error, I usually use pl SQL and golden32 to query database software. If I use golden32, it is no problem to alias it as Chinese when I use it. Until I want to convert PL SQL (use Chinese package chinese.exe ), after the

ORACLE Stored Procedure Prelude: 1: A Necessary concept: ORACLE provides the ability to store PL/SQL programs in databases and run them anywhere. In this way, stored procedures or functions are called. Procedures and functions are collectively

Oracle cursor: Query and print employee name and salary -- Query and print employee name and salary -- set serveroutput on/* 1. cursor attribute % found: true if the record is obtained; otherwise false; % notfound: */declare -- Define a cursor cemp

[Oracle] RAC shared storage udevThe core lies in the following two statements. The redhat 5 and redhat 6 are tested. The B c d in the statement represents sdb sdc sdd, which should be modified according to the actual situation.Redhat 5For I in B c d

[01] Oracle Database introduction, 01oracle database Introduction Oracle relational database: built on the relational model. Oracle10g: g (grid) Grid technology. grid Computing connects a large number of computers through network sharing and