Oracle

This stage, has been learning Oracle, feel a lot of harvest. I worked in the company, at that time to do client development, every day in the PL/SQL statement, modify SQL statements, do statistics to do query, at that time used very skilled, check

First, the preparatory workTo create a table space:Create temporary tablespace yangwen_tempTempfile ' D:\oracle\oradata\orcl\yangwen_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local;Create Tablespace

1, check the user's proifle is which, is generally default:SQL>SELECT from Dba_users;2. View the password expiration settings for the specified profile (such as default):SQL>SELECT*fromWHERE s.profile='DEFAULT ' and

Start monitoring: Lsnrctl startView monitoring: Lsnrctl statusStop listening: Lsnrctl stop1. Oracle data Server includes: instance process and database;Instance processes include: Memory structure (SGA) and background process (Pmon (process

(1) The concept of table space and partitioned tableTable Space:is a collection of one or more data files, all of which are stored in the specified table space, but are primarily tables, so called table spaces.Partition table:When the amount of data

First, install the ODAC and configure the environment variablesAdd Reference "Oracle.dataaccess" to your projectCodeUsing Oracle.DataAccess.Client;public void Execute (){OracleConnection conn = new OracleConnection (connstring);Try{Conn. Open

1. Solve the ORA-12505 problem of oracle11gStart the Oraclehome92tnslistener service and start oracleservicexxxx,xxxx is your database SID. (Sid_desc =(Global_dbname = ORCL)(Oracle_home = D:\Oracle\product\11.2.0\dbhome_1)(Sid_name =

There are a variety of problems in the use of Long types, and it is not recommended& && Use (for command mode only)& for specifying variable,&& for outputting existing variablesDescritpion Display object information (for command mode only)For

Why do I have to turn on additional logs when goldengate is in use? People think, if I do update on the source side, how does the target know what row of data I am modifying? So what do we use to identify this line of data that we've modified? ROWID?

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

How Oracle can update newly inserted data with trigger implementationCreate or Replace Trigger Tr_nameBefore insertOn tableFor each rowBegin: New. A field = ' newly value ';EndModify a field of a table of data AA (this field is specified), after

To modify the maximum number of Oracle connections1. Ways to modify the maximum number of connections for OracleA, landing in SYSDBA status of PL/SQL or WorksheetB, query the current number of connectionsShow parameter processes;C, change the number

1, the table has the following data Name Subjects January February March Tom Chinese 30 40 50 Tom Mathematical 56 65 78

Oracle inspection script #!/bin/sh# Get HostnameHOSTNAME=`hostname`logfile=xunjian_`date +%y%m%d`.loghostinfodir=/home/oracle/xunjianif [[ ! -d $hostinfodir ]]thenmkdir -p $hostinfodirfidate >> $hostinfodir/$logfileecho " hostname " >> $hostinfodir/$

Oracle Database creation process Since there is already a database instance in the current environment, this does not affect the creation of a new instance sun Current System instance [oracle@DBA2 dbs]$ env |grep ORACLEORACLE_SID=orcl1ORACLE_BASE=/u/

The setting of INITIAL Parameter causes the truncate table to fail to reduce the case of the high water level line, and the truncate water level line Using the following SQL statement in a database, I found a batch of tables that need to reduce the

PL/SQL webpage access (get or post), plsql When we develop a plsql program, it is inevitable that we sometimes access data from some external websites. At this time, we need to use the utl_http package.   Before using the utl_http package, check

Oracle converts score rows into columns 1. The table contains the following data: Name Subject January February March Zhang San Chinese 30 40 50 Zhang San Mathematics 56 65 78

Oracle expdp and impdp commands-- Create a remote data connectionCreate database link DB_MZDB11 connect to YTMZTWO identified by YTMZTWO909 using 'mzdb11 ';-- Create a local directoryCreate directory db_mz as 'C :';-- Authorize the user to read and

Oracle set command, oracleset SQL> set colsep ''; //-domain output SeparatorSQL> set echo off; // displays each SQL command in the start script. The default value is on.SQL> set echo on // set whether to display the statement when running the