Query Oracle Space Occupation

ALTER DATABASE datafile ' C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM. DBF ' Resize 4096M; SELECT used. Tablespace_name, used. Used_bytes as "used SPACE (in GB)", free. Free_bytes as "Free SPACE (in GB)" from (SELECT Tablespace_name,to_char (SUM (NVL

Oracle--dual Table

1.dual is the smallest worksheet provided by Oracle, with a single row and special features.The table structure of the 2.dual is as follows3. It is an internal table under the SYS user, all users can access it, whenever this table exists.4. Use:1>

Oracle User and table space

There is a concept of table space in Oracle. To create an Oracle database in a system, you first need to create a user, then assign a table space to the user, and the table space stores the underlying elements such as tables. If you do not

Oracle SGA Optimization

Oracle's SGA: The system global area of a database, the SGA consists mainly of three parts: a shared pool, a data buffer, and a log buffer. A shared pool is made up of two parts: a shared SQL area and a data dictionary buffer.the shared SQL zone

Oracle Full-text retrieval implementation

1 ----1 prepare to unlock ctxsys users and authorize-----2 3 --Unlock Ctxsys4 Alter Userctxsys account unlock;5 --Modify the Ctxsys password (if the Ctxsys user expires, you need to reset the password)6 Alter UserCtxsys identified byCtxsys;7 8

Oracle Self-Growth ID

In Oracle, you can create a separate sequence for the primary key of each table, and then get an automatically incremented identifier from the sequence and assign it to the primary key. For example, the statement creates a sequence named Customer_id_

Oracle Tutorial-Query (ii)

EMP Employee TableWhether the field name data type is empty remarks--------   -----------   --------   -------- EMPNO Number (4) Employee IDEname VARCHAR2 (Ten) Y employee nameJob VARCHAR2 (9) Y JobMGR Number (4) Y of the SuperiorHireDate Date Y

Oracle Array type

Oracle Array type oracle array type, example: SQL code  create or replace function my_test (p_str varchar2)  return number  as - -Common variable  v_var varchar2 (1000);  --fixed-length array  type v_ar is Varray (30) of VARCHAR2;   my_ar V_ar:=v_ar

Oracle Database Learning

Database (DB)A database is a collection of large amounts of data that are stored in a computer, organized, and shared over a long period of time. The data in the database is organized, described and stored according to a certain data model. With a

Export data from Oracle using the spool command

The company's website uses an Oracle database, and recently exported the data inside, using the MySQL databasespool d:\db\{file name}.sqlSetHeadingoff;SetEchooff;SetFeedbackoff;SetPages0;SetTermoutoff;SetPageSize0;SelectCONCAT (CONCAT ('INSERT into

Oracle recursive query

First, recursive query1. Table Agency sql> desc comm_org_subjection Name Null? Type-----------------------------------------------------------------------------org_subjection_id Not null VARCHAR2 (3

About Oracle 10g's schedule Job

-- Job PermissionsGrant CreateJob tosomebody;--Job CreationbeginDbms_scheduler.create_job (Job_name= 'Agent_liquidation_job',Job_type= 'stored_procedure',Job_action= 'agent_liquidation. Liquidation', --Stored Procedure

ADO Call Oracle Stored procedure

The purpose of writing this is because EF directly executes the stored procedure varchar type return parameter direct throw exception mode 1 can be normal execution mode 2 does not use varchar return parameters can be appliedWay 1:ado.net

ORACLE uses SCN to recover mistakenly delete tables

--KG is a mistakenly deleted table Sql> select COUNT (*) fromkg; COUNT (*)----------820861sql> Delete from kg;820861 rows deletedsql> commit;  Commit completesql> Select COUNT (*) from kg; COUNT (*)----------0sql> rollback;  Rollback completesql>

Usage of rownum in Oracle

There is a product list, if you are asked to inquire about the first 5 items of the latest listed date. How do you write your SQL statement? First, judge the condition and order again? Wrong.The idea is very simple, is to first order, and then take

Oracle Change field type

Due to changes in demand. Now, we want a type number (8,2) field type to change char.The general idea is as follows:Rename the field name that you want to change the type to back up, and then add a field with the same name as the field name of the

[Oracle] restore all redo logs physically deleted when the database is running

[Oracle] restore all redo logs physically deleted when the database is running Lab environment: OEL5.6 Oracle11.2.0.1 Lab started: Database running status, delete all logs: [Oracle @ itaa test] $ ls Control01.ctl redo01.log sysaux01.dbf

Oracle queries whether the Department (326) of a person belongs to the Department string (329 | 2) or the sub-department of the Department string.

Oracle queries whether the Department (326) of a person belongs to the Department string (329 | 2) or the sub-department of the Department string.   Department 326 is the parent department of Department 329, and Department 2 and department 326 are

[SQL entry level] Next part: Continue to query; last part of SQL

[SQL entry level] Next part: Continue to query; last part of SQL It has been a long time since the previous article. This article continues to query and briefly summarizes the knowledge of Aggregate functions and grouping. 1. Aggregate functions

Check whether the data table exists in Oracle.

Check whether the data table exists in Oracle. During the process, especially for daily tasks, check that the queried data table does not exist. If the data table does not exist, wait for a while. The following code implements this function, if the

Total Pages: 2147 1 .... 2127 2128 2129 2130 2131 .... 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.