Oracle

After a 64-bit Oracle 10g Database is installed on the 64-bit win2003 operating system, you can connect to the database using PLSQL over the network, but the server cannot connect to the database.Solve the problem as follows:1. Install the 32-bit

Update content: 1. Add large text import (originally only datareader is supported) 2. Data can be imported from row X. 3. Decide whether to save the data row number. 4. The column ing is case insensitive. 5. Constant columns can be

Simple Oracle Stored Procedure -- The salary is increased by 500, old. SAL> 2500 not added, new. SAL> 2500 is changed to 2500; Select * from EMP -- before salary increase Create or replace procedure sp_add (add in number) is -- add parameter

Create or replace procedure p_pagination(Pindex in number, -- the page number starts from 1Psql in varchar2, -- query statementPsize in number, -- number of rows per pagePcount out number, -- total number of pagesV_cur out sys_refcursor -- return

I have been using sqlserver and have no chance to access Oracle. In the past few days, I have installed Oracle 9i and installed it in my previous notebook, today, I installed it on my desktop again. An error was reported when the installation was

Basic update statements Update all records Update Set = Create Table TestSelect object_name, object_typeFrom all_objs;Select distinct object_nameFrom test;Update TestSet object_name = 'opops ';Select distinct

1. Length and lengthb Both of the above functions are used to obtain the length of the string, but the returned results may be different. The length units returned by lengthb are bytes rather than characters. Length indicates the number of

  SQL code Select mc | 'id' as Alias, nl + 20 as age from student;   In SQL, strings and dates must be enclosed by single quotation marks. You can add, subtract, multiply, and divide (+,-, *,/) numbers and dates in SQL ,-,*,/). SQL strings can be

You can use the profile file to define user attributes. For example, you can create a profile file for the product user.SQL codeCreate profile product_profile limit SESSIONS_PER_USER 1; -- Only one user can be setSQL codeSession profile alter user

-- Deadlock query statement The Code is as follows: Copy code SELECT bs. username "Blocking User", bs. username "DB User ",Ws. username "Waiting User", bs. SID "SID", ws. SID "WSID ",Bs. serial # "Serial #", bs. SQL _address "

The following describes how to write SQL statements for mysql/Oracle/mssql to retrieve the first few pieces of data. If you need them, refer to them. If you use this statement in ms sqlserver: The Code is as follows: Copy code

During the project transformation, the paging data written by the original colleague is to query all records from the database and then to the paging data. Now, the paging data is transformed to dynamically querying the split pages and the number of

1. Obtain the scn Number of the current database Select current_scn from v $ database; (switch to sys user or system user query) The queried scn number is 1499223. 2. query the scn before the current scn number Select * from table name as of scn

: All departments.Select dept. deptno, dept. dnameFrom dept, empWhere dept. deptno = emp. deptno2. List all employees with higher salaries than SMITH.Select * from empWhere sal> (select sal from emp where ename = 'Smith ')3. List the names of all

The following are all Oracle database connection strings. The summary is very detailed, but I did not summarize them. I just learned from Oracle. Paste it out. First, it is convenient for you to search for it later, and second, it also provides

1. nvl ('A', 'B') if A is null, B is displayed. 2. DECODE (value, if1, then1, if2, then2, if3, then3,... else) 3. grouping function usage, with a parameter. The parameter is the field name. If the result is obtained from this field, 1 is returned.

The processing process of an explicit cursor includes: Declare the cursor, open the cursor, search the cursor, and close the cursor. Declared cursor CURSOR c_cursor_name IS statement; A cursor is equivalent to a query result set. The query result is

  Run tkprof in the system to convert the trace file into a format that can be read by humans.(I personally don't feel very good. I don't need to get a good format when the trace file is output) Syntax:Tkprof tracefile

1. Create an External table directory Create directory extdir as 'e: appextdir '; 2. Define External tables Create table ext_test ( Rt date, Rtype char (1) ) Organization external ( Type oracle_loader Default directory extdir Access parameters

Concept: Database: a warehouse that organizes, stores, and operates data in batches. Data Warehouse is a basic term in the database field. Here it refers to its conventional meaning. Database Management System (DBMS): A software module used to