1 /*The default DB instance here is ORCL, creating a permanent tablespace for ORCL, zone custom allocation, and automatic management of segments*/2 CREATEtablespace ORCLTBS01 datafile3 'D:\app\darkdog\oradata\ORCL\ORCLTBS01_1.DBF'SIZE 50M;4 5
Oracle Multi-Table Query 1 put multiple data into one fieldSelect Id,zhzxm,fzhzxm,ltrim (Max (Sys_connect_by_path (XM, ', ')), ', ') XMFrom (Select Id,zhzxm,fzhzxm,xm,row_number () over (partition by ID ORDER by LRSJ) RN--mark the same
--Use a subquery to find an indeterminate value--Sub-query and select statementSELECT e.emp_id, E.first_name, E.last_name, EP. Pay_rateFrom Employee_tbl E, Employee_pay_tbl EPWHERE e.emp_id = EP. emp_idand EP. Pay_rate (SELECT pay_rate from employee_
To view the table space status statement:Select Tablespace_name, status from Dba_tablespaces;CREATE TABLE SpaceCreate Tablespace MySpaceDataFile ' G:\app\myspace\myspace01.dbf 'Size 10m autoextend on next 5m maxsize 100m;Table Space properties are
Ha, which only monitors and manages the database at the operating system level, is generally used only for single-instance databases. The advantages are convenient management, convenient application development (developer convenience), and less
18, NCLOBYou can use a character set defined by the database international character set to store character-based data that is only Unicode type. You can store up to 4GB of data, which is larger than the maximum data that can be stored in the ORACLE1
Fortunately, I was recommended to participate in the Oracle Yep program, although compared with you, my actual experience and ability still have a lot of shortcomings, but at least a kind of encouragement to myself, adhere to the interest, adhere to
1, from the top down queryUse start with a= ' starting ID ' connect by prior a= BA is a subkey and B is the parent.Select F_ca_code,f_ca_parentcode,level from with='0' by=Query Result:Where level is the Oracle built-in functionIf you join a query,
Introduction to oracle trunc Functions
1. TRUNC (for dates)
The date value intercepted by the TRUNC function for the specified element.
The syntax format is as follows:
TRUNC (date [, fmt])
Where:
Date: A date value.
Fmt date format, which is
Oracle Data Type-4
18. NCLOBThe character set defined by the international character set of the database can be used to store character-based data of the Unicode type only. A maximum of 4 GB of data can be stored, which is larger than the maximum
Oracle Data Type-3
9. TIMESTAMP WITH TIME ZONEIt contains all fields in the TIMESTAMP data type. In addition, it also contains two additional fields: timezone_hour and timezone_minute. This data type contains information about supported time zones.
Oracle recursive queryCreate a table and a primary foreign key
CREATE TABLE SC_DISTRICT( ID NUMBER(10) NOT NULL, PARENT_ID NUMBER(10), NAME VARCHAR2(255 BYTE) NOT NULL);ALTER TABLE SC_DISTRICT ADD (
Modify the Data Type of the column corresponding to the primary key of an Oracle database table
When upgrading our product from SPC100 to SPC200, because the data type of the database table column has changed, you need to write an SQL script to
The query for a specific type of data in an oracle table is particularly slow, and no reason is found.
When I look up a table today, it is very slow to query a specific type of data in the table, but the whole table is very fast, and no reason is
Subquery 3 (use subquery in the from clause), from clause
In the FROM clause, subqueries generally return multiple rows and multiple columns, which can be treated as a data table.
Example 1,Query the number, name, location, department count, and
Oracle creation-stored procedures and functions
-- Create a stored procedure
Create or replace procedure xxxxxxxxxxx_p (-- Parameter IN indicates the input parameter, -- OUT indicates the output parameter, and the type can be of any legal type IN
How does oracleASM Add a new disk to a disk?
Applicable platform: AIX hp linux win Solaris
Applicable versions: all databases 10.1.0.2 to12.1.0.1
Applicable to rac and standalone
Take the RAC environment as an example: Assume that oracle is an
Oracle connection Query
I have learned inner join and outer join in SQL Server. outer join is divided into left outer join andRight outer join ). In Oracle, the external connection between two or more tables is represented by (+.
Code Demo: Check
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