Oracle line-to-row

such as SQL:Select Zyxdm from table where bindid=2265254The result of the query is: 1|4|8| 9|10Turn this query result into multiple rows, and the result is as follows:ID148910SQL to convert:With CTE1 as (select Zyxdm from table where bindid=2265254)

Oracle built-in function (iii) DATE function

Summary of date functions: System time Date operation First, the system timeSysdate: Or Western format, we generally need to_char (date, ' Yyyy-mm-dd hh24:mi:ss ')Next_day: The date of the next week of the current dateExample: the date of

Two ways Oracle modifies the order of fields

Category: OracleIf you want to modify the order of the fields, you can generally use the following steps:--(1) Backing up the target table dataCREATE TABLE Temp table as SELECT * from target table;--(2) Drop target tabledrop table target table;--(3)

Basic command management and operation of Oracle database

Basic command management and operation of Oracle databaseStart the database650) this.width=650; "src=" https://s3.51cto.com/wyfs02/M02/97/53/wKioL1ktT9jRlsYbAAVEvLNNTas771.jpg "style=" float : none; "title=" 1.jpg "alt=" Wkiol1ktt9jrlsybaavevlnntas77

Oracle Foundation Analysis Table

Analyze table TableName compute statistics;Analyze index IndexName compute statistics;(Analyze does not rebuild the index)When you encounter a query or other performance that is not good for the current table, you can analyze the corresponding table

[Oracle] Row and column transformations (line merge and Split)

implementing a row merge using Wmsys.wm_concatIn Oracle, multiple rows of data from one field are converted to a comma-styled line. Can be achieved using function Wmsys.wm_concat.This one in the previous articleOracle Built-in function

Oracle Small Test

ORACLE10I,ORACLE11G,ORACLE12C, other i,g,c What do you mean?I (Internet) internetg (GRID) gridC (Cloud) cloudWhat does sqlplus mean?is an Oracle-brought client-side tool that is designed to connect to the server for SQL operations through a

Oracle Pctfree and pctused detailed

First, when establishing the table, pay attention to the role of pctfree parametersPCTFREE: The percentage of space reserved for a block, indicating when the data block can be insert, the default is 10, indicating that when the free space of the

Oracle--sqldeveloper

1. Database Creation UserReference blog: Connect to a database using Oracle Sqldeveloper and create usersReference Blog: Oracle database-Build library, build table space, build users2. Table SpaceView Table SpacesSelect * from

When does Oracle commit???

This is my third blog ~Today, we mainly talk about the impact of database commit on execution efficiency.Congo: When you write 800W of data, the period of commit and final commit time difference of one hours. Specific is not so I do not research,

Oracle Rights Management

Authorization principle: Principle of least privilegeEmpower users with roles to simplify administrator administrative privilegesBusiness account creation:To create a specific table space:CREATE tablespace TBS1 datafile '/U01/APP/ORACLE/ORADATA/PROD4

Oracle Lock Table Unlock

Select substr (object_name,1,30), substr (os_user_name,1,20) from v$locked_object,user_objectswhere v$locked_object.object_id = user_objects.object_idSelect B.owner,b.object_name,a.session_id,a.locked_modeFrom V$locked_object a,dba_objects bwhere

Description of ORACLE Reference file

After the ORACLE database is started. This statement enables you to see all the parameters used by the Oracle database using the SELECT * from V$parameter . For Oracle 's parameter files, it is divided into spfile binaries and pfile text files.

Oracle Database Maintenance Operations 2

--Analysis TableDbms_stats.gather_table_stats--stored procedures for statistical tables(Ownnamevarchar2, TabNamevarchar2, PartNamevarchar2 default NULL, Estimate_percent Number defaultTo_estimate_percent_type (Get_param ('estimate_percent')),

Simple comparison of MySQL and Oracle

Ora-27101:shared Memory Realm does not exist workaround:1. Use cmd to enter the command line2, Sqlplus/nolog3, Conn/as SYSDBA4. StartupFirst, introduce the four categories of SQL92/99 standardDML (Data Manipulation

Oracle database Common keywords and notation

Database Common keywords:CREATE TABLE --- Create a tableCreate a table with table name (column name type of column, column name Type of column ... )CREATE TABLE Z_course (ID number, Cour_code VARCHAR2 (), Cour_name VARCHAR2 (), p_cour_code VARCHAR2

Processing of Oracle Timestamp

public class Test {private static final SimpleDateFormat FORMAT = new SimpleDateFormat ("Yyyy-mm-dd HH:mm:dd");public static void Main (string[] args) throws SQLException {Oracle.sql.TIMESTAMP temp = new Oracle.sql.TIMESTAMP ();SYSTEM.OUT.PRINTLN

Oracle Database Maintenance Operations

Select File#,name from V$datafile;Select File#,name from V$tempfile;SELECT NAME from v$controlfile;--control fileSelect Group#,sequence#,status from v$log;--redo log fileShow parameter spfile;--database initialization fileSelect

Oracle tablespace, user, authorization management

1. query Table Space LocationSELECT * from Dba_data_files;-d:\app\administrator\oradata\orcl\***.dbf2. View Temporary tablespace locationsSELECT * FROM V$tempfile-d:\app\administrator\oradata\orcl\***_tmp.dbf3. Create a temporary table spaceCreate

Oracle User Rights related

--View all users under the database:Select from Dba_users;--View the user roles for the current connected databaseSELECT * from User_role_privs;--Create UserCREATE User by test;--Assigning authorizationGrant to -- assign permissions to allow

Total Pages: 2147 1 .... 2113 2114 2115 2116 2117 .... 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.