Oracle

Win7 Bit64, the 64-bit client is installed.  1. Plsql Connection Database(1) Download Instantclient-basic-win32-11.2.0.1.0.zip extract to Oracle headlines now, and create a new Network/admin/tnsnames.ora (2) to configure the Plsql Oracle directory,

If you need to write a data dictionary when the project is delivered, you can use the following method to first run the line face SQL statementSELECT a.table_name as table name, a.column_name as field name, DECODE (A.char_length,

1. View the log file location;[email protected]>select inst_id,name,value from V$diag_info;inst_id NAME VALUE---------- -------------------- --------------------------------------------------1 Diag Enabled TRUE1 ADR base/u01/app/oracle1 ADR Home/u01/

Each time a select is displayed as such:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/4B/05/wKioL1Qnug6hHeV1AAC8jV6dou0256.jpg "title=" Oracle1.png "alt=" Wkiol1qnug6hhev1aac8jv6dou0256.jpg "/>The display page size should be

1. Points of problems encounteredUsing Sqldeveloper to connect to an Oracle database, when you test the connection, you are prompted "the network adapter could not establish the connection"2, the solution processConfigure the Listener and service

Wrote a stored procedure, which used a function, the function has a section of To_date (Datefrom, ' Yyyy/mm/dd '), after the run to find data insertion error, inserted data for "0001/9/14." Feel baffled, do not know why this is the data, after

There are three types of Oracle login Identities : Normal General identitysysdba system administrator statusSysoper System Operator identityEach identity corresponds to a different permissionSYSDBA Permissions:Start and close operationsChange the

1. Write the SQL statement in PL/C, and habitually end with a semicolon (";"), but write the SQL statement without adding ";".For example:With data as (...) SELECT * from data;With a semicolon in the back, I'll report aORA-00911: Invalid

Attention:Debian recommends installing OPENJDK, which is already included in the release package.Oracle's Java needs to be installed on its own, with the following installation steps:1. First install Java-package, installation method: Apt-get

Create LPN for OracleEBSZookeeper creates LPNPROCEDURE create_lpn (errbuf OUT VARCHAR2, retcode OUT VARCHAR2, p_organization_id in number, p_lpn_prefix IN VARCHAR2, p_lpn_suffix IN VARCHAR2, p_lpn IN VARCHAR2) IS BEGIN-- InitializeStruct (errbuf =>

Use OracleDBLink to access objects between databases Oracle comes with the DBLink function. It is used to logically think of multiple oracle databases as one database, that is, one database can operate on objects in another database, for example, if

To_date errors caused by different Oracle Language Environments I wrote a stored procedure and used a function in it. The function contains a to_date (dateFrom, 'yyyy/mm/dd'). After running the function, I found that the data was inserted

Practice: shell scripts for oracle tablespace Deletion #! /Bin/bash# Ocpyang@126.com# Drop tablespace If [$ #-ne 1]; thenEcho "Usage: $0 TABLESPACE_NAME"Exit 1Fi # Configure oracle env: about oracle envs, username and password ORACLE_SID =

Practice: Create shell scripts for oracle users #! /Bin/bash # ocpyang@126.com # create userif [$ #-ne 4]; then echo-e "\ e [1; 32 m ************************************** **************************************** * ** \ e [0 m "echo-e" \ e [1; 32 m

Summary of Oracle parameter viewing Methods Oracle provides a large number of system parameters. The following is a summary of the query methods.Current System Parameter The current system parameters involve these views: v $ parameter, v $ parameter2

Plsql_performance optimization series 01_Oracle Index, plsql01_oracle 2014-06-01 BaoXinjian I. Summary In PLSQL query optimization, Index is the most widely used and exposed concept. I also think that Index selection and optimization are important

Summary of Oracle database architecture   Oracle DB ArchitectureAn Oracle DB server consists of one Oracle DB and one or more database instances. An instance consists of a memory structure and background processes. Whenever an instance is started,

IT Ninja Turtles OracleDBA common query Enumeration -1. query all objects in the systemSelect owner, object_name, object_type, created, last_ddl_time, timestamp, statusFrom dba_objectsWhere owner = upper ('Scott ') -2. view all tables in the

The end of IT Ninja Turtles's use of oraclewithas With as syntax-For an aliasWith tmp as (select * from tb_name) -For Multiple aliasesWithTmp as (select * from tb_name ),Tmp2 as (select * from tb_name2 ),Tmp3 as (select * from tb_name3 ),...

Create a tablespace in oracle and test it with the user First, describe the table space as follows: Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory, but