Oracle

I. Description of my environment1. Oracle server is installed on Win7 32-bit, Oracle version is 10.2.0.1.02, Linux for centos6.5 32-bit, installed on the Oracle VM VirtualBox virtual machine3. Win7 with FTP serviceIi. Description of function

01:23:06 [email protected]> Select name, decode (CDB, ' YES ', ' multitenant Option enabled ', ' Regular 12c Database: ' ) "Multitenant Option", Open_mode, con_id from V$database; NAME multitenant Option open_mode con_id------------------------------

The most basic Oracle database connection code (for oracle11g only):1, right-click Project, build path, configuration build path, select the third item "Library", then click "Add External Jar" and select "D:\Oracle\app\oracle\product\11.2.0\server

First, we need to differentiate what the HP processorMachinfo ViewPa-risc's product number starts with RP, and Itanium's product number starts with RxDifferent products need to go to the official website to download different media, so it needs to

The steps for Sql*net trace on the Oracle client side and the attention pointsReference article:How to Perform client-side tracing of programmatic Interfaces on Windows platforms (document ID 216912.1)My environment:Oracle database server:oel5.4

Ora-28000:the Account is locked-solution2009-11-11 18:51Ora-28000:the account is locked1th step: Use PL/SQL, login name System, database name unchanged, select type to change normal to SYSDBA;2nd step: Select Myjob, view users;3rd Step: Select

The first step: the virtual memory of the machine to 2G, otherwise reported insufficient memory.Step Two: Modify the Oraparam.ini in the Ds_windows_x86_101202_disk1\install directory.[Certified Versions] windows=5.0,5.1,5.2,6.0,6.1Step Three:

DeclareType ref_cur_variable isREFcursor; Cur_variable ref_cur_variable; V_enamevarchar2(Ten); V_deptno Number(2); V_sal Number(7,2); V_sqlvarchar2( -) := 'Select T.ename, T.deptno, t.sal from Scott.emp t';begin OpenCur_variable forV_sql;

DeclareType ref_cur_emp isREFCURSOR RETURNScott.emp%RowType; Cur_emp ref_cur_emp; Rec_emp cur_emp%RowType; V_sqlvarchar2( -) := 'SELECT * from Scott.emp t';begin --xxx Open cur_emp for v_sql; OpenCur_emp for Select * fromScott.emp t;

Because of the use of PL/SQL, we have just installed Oracle 11g 64-bit today, and after the results are turned on, PL/SQL is not automatically configured.Then find the following blog post on the Internet, follow the steps to solve. Share Next Blog

--------------Note: The following operations are performed in Rhel VNC, not in SECURECRT. --------------------------reason: If executed in SecureCRT, M3 will be shown as: M Lu, see below, what is the reason I have not studied--The following is the

Creating a table (CREATE TABLE) syntax detailed1. Types of fields commonly used by OracleOracle's Common field types areVARCHAR2 (size) variable-length string, which must be specified in lengthCHAR (size) fixed-length string, not specified length

Operating system: windows2008Database: oracle11gProblem occurs: A set of normal run a year of application system, suddenly unable to connect to the database, but another application can be normal link, data storage normal.Database server-side

Oracle SQL Date Comparison:Before today:SELECT * from up_date where update SELECT * from up_date where update After today only:SELECT * from up_date where update > To_date (' 2007-09-07 00:00:00 ', ' yyyy-mm-dd hh24:mi:ss ')SELECT * from up_date

Databases and instances=============================================Jdbc:oracle:thin:@127.0.0.1:1521:orclListening:Start monitoring: Lsnrctl startStop listening: Lsnrctl stop ORCLView listening status: Lsnrctl statusNET Start OracleservicenameNET

The "Check operating system version: must be 5.1 or 5.2" encountered when installing Oracle DB 10.2.0.4 under Widows x64bit R2. The actual 6.1 failed "Special Note: Widows X64bit R2 The installation of Oracle DB 10.2.0.4 is only the first step, then

Oracle 11g ClientResourcesDownload resources, direct decompression for configuration Oracle Official resources: http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html since Plsql developer is a 32-bit software, 32-bit

Numeric type functions:Absolute:ABS (x) "function" returns the absolute value of x "parameter" x, numeric Expression "return" number "example" Select ABS (+), ABS ( -100) from dual;--------------------------------------------------------------------

A little familiar with Oracle knows that if we want an SQL statement to insert multiple values into a table, if insert into a table values (each value), values (values),.....; This will cause an error because Oracle does not support this notation if

When Oracle 11g is exported using EXP, empty tables cannot be exported, and 11 gexp I. cause:There is a new feature in 11G. When the table has no data, no segment is allocated to save space.1. insert a row and then roll back to generate a