Modify the field type of existing data in Oracle

Modify the field type of existing data in Oracle [SQL] www.2cto.com create table t_person (id varchar2 (200) primary key, name varchar2 (200), address varchar2 (200 )); [SQL] insert into t_person (id, name, address) values (sys_guid (), 'hangsan',

Check whether the number of existing processes in the database has reached the processes parameter size.

Check whether the number of existing processes in the database has reached the processes parameter -- select count (*) from v $ process; to obtain the current number of processes in the database. -- Select value from v $ parameter where name =

Oracle over partition

Oracle over partition by select * from test data: a B c 1 1 1 1 2 2 3 3 2 5 3 4 6 --- add the corresponding C column values with the same B column values to the total select a, B, c, SUM (C) OVER (partition by B) c_Sumfrom test a B C C_SUM 1 1 1 1 1

Sort query results by in content

Sort the query results according to the in content. Today, the customer sends an excel table with a small amount of content. There are two columns: the license plate number and the device number, let me help export the information about the device

[Oracle] the difference between a stored Procedure (Procedure) and a (custom) Function

[Oracle] the difference between a stored Procedure (Procedure) and a (custom) Function (Function) the Stored Procedure (custom) Function needs to be executed independently, and there is not necessarily a return value; functions can be called

Query statistical reports without keywords

Create or replace procedure P_114_SEARCHNT (o_Cursor Out sequence, I _Begindate In varchar2, -- start time I _Enddate In varchar2, -- end time I _citycode In varchar2 -- Address Code) /*************************************** * *** function: author:

Considerations for Oracle Silent Installation

Brief considerations for Oracle Silent Installation the environment configuration for Silent Installation is the same as that for graphical installation. Here we will not repeat the main points: ① The response files are mainly used in the downloaded

Group by usage in Oracle

In Oracle, the group by clause can be used in select statements to divide rows into smaller groups, and then the grouping function is used to return the summary information of each group. In addition, you can use the having clause to limit the

Oracle sequence creation and cyclic auto-increment values

Use sys to log on to Oracle SQL> conn sys/root as sysdba for sequence creation and auto-increment of loops; create sequence SQL> create sequence test_seq maxvalue 9 increment by 2 start with 1 cache 2 cycle; create corresponding test table SQL>

Oracle left and right connections

The left and right connections in oracle saves the complex join statements (left join and right join) in SQL server, which are represented by a "(+. In the following experiment, query 1 and query 2 are equivalent, and query 3 and query 4 are

Alter table parallel operations

Alter table open parallel operation use alter table open parallel first create a table create table a_test (name varchar2 (10) insert into a_test values ('aaa'); select * from a_test; NAME ---- aaa add an age and then use the parallel alter table

Oracle searches for and deletes duplicate records in a table

Oracle searches for and deletes repeated records in a table: a field in an application table is a primary key. when inserting data into a table, the data is first placed in a temporary table (without a primary key) then insert the application table.

Oracle tablespace (2)-View table space usage

Oracle tablespace (II)-view tablespace usage SQL code SELECT UPPER (F. TABLESPACE_NAME) "tablespace name", D. TOT_GROOTTE_MB "tablespace size (M)", D. TOT_GROOTTE_MB-F. TOTAL_BYTES "used space (M)", TO_CHAR (ROUND (D. TOT_GROOTTE_MB-F.

Oracle user operations

Oracle user related operations currently orcl databases use sys as sysdba to create users: create user epa_dev identified by epa_dev default tablespace NNC_DATA01 temporary tablespace temp; grant create session to epa_dev; grant create table to

Oracle application records

Oracle Application Record 1. Delete the data in the oracle recyclebin table purge recyclebin 2. Enable and stop recyclebin alter system set recyclebin = off; the system has changed alter session set recyclebin = off; session has changed. 3. The

Rman backup error Message file RMAN & lt; lang & gt;. msb not found

Rman backup error Message file RMAN . msb not found problem linux rman backup error message is obviously unable to find the rman command, path has a problem, or the environment variable [oracle @ redhat/] $ mailMail version 8.1 6/6/93. type? For

Partition Table Partitioning with a large granularity

The partition table partition granularity is too large to solve the oracle database. performance problems occur in the afternoon. 1. Check the cpu, memory, io, and other performance parameters of the two servers and find that the CPU usage is close

ORACLE library cache lock Query

ORACLE library cache lock query select Distinct/* + ordered */w1.sid waiting_session, h1.sid holding_session, w. kgllktype lock_or_pin, od. to_owner object_owner, od. to_name object_name, oc. type, decode (h. kgllkmod, 0, 'none', 1, 'null', 2,

DML statement and table connection

DML statement and table join Cartesian Product: (1992) SQL> select ename, dname from emp, dept; (1999) SQL> select ename, dname from emp cross join dept; query the same number in the middle of emp and dept: SQL> select ename, dname from emp, dept

Common Oracle Optimization Methods

Oracle common tuning methods Oracle database application system optimization mainly includes ten aspects: (1) optimizing database memory; (2) fixed application code in the Oracle shared pool; (3) optimizing data storage; (4) optimizing data sorting;

Total Pages: 2147 1 .... 2086 2087 2088 2089 2090 .... 2147 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.