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)
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
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)
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
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
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
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
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,
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
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.
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
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
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
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
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
--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
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