Oracle

CREATE TABLE Space1. Syntax CREATE [Smallfile/bigfile] tablespace tablespace_nameDataFile '/path/filename ' SIZE num[k/m] Reuse[, '/path/filename ' SIZE num[k/m] reuse][...][Autoextend [on| OFF] NEXT num[k/m]][MAXSIZE EXTEND [UNLIMITED |

An index is an object provided by Oracle that provides a quick way to access the data, improving the retrieval performance of the database. The index allows the database program to not have a full table scan of the entire table, in which you can

Create or Replace procedure Sum_info is I integer;temp1 varchar2 (100) temp2 varchar2 T1 DATE;T2 ); v_sqm varchar2 (+); U_name t_temp.u_name%type;t_name t_temp.t_name%type;c_name t_temp.c_name%type;cursor tb_list Is select U_name,t_name,c_name from

First execute Sqlplus/as sysdba with Oracle user, enter Sqlplus,Then first look at what data files are currently available sql> select name from V$datafile; And then we see a/u01/app/oracle/oradata/sid/test.dbf in the results.Then close the database

Exceptions and rollbacks for OracleDECLAREDept_no Number(2) := -;BEGIN --Start a transaction INSERT intoDeptVALUES(Dept_no,'Marketing Department','Beijing');--Insert Department record INSERT

1. Check the listening status Lsnrctl status2. Start monitoring Lsnrctl start3. Turn off monitoring lsnrctl stop4. Log on as a database administrator Sqlplus/as Sysdba5. Manually start the database sql> STARTUP6. Close the database Sql>shutdown

Oracle stored procedure Call dynamic sqlcreationtime--2018 August 16 11:25 author:marydon1. Error implementation mode--Start time stitching ' 00:00:00 ' v_sql: = ' Select decode (Length (' | | | V_end | | '), 10, ' | | ' Concat (' | | V_end | | ', 0

One, inner connection(inner JOIN (can be abbreviated as join))The INNER JOIN query operation lists the data rows that match the join criteria, and it uses comparison operators to compare the column values of the concatenated columns.1. Equivalent

Call report in the menu Program (If you do not specify a parameter, you can use the following program segment for passing the parameter) run_product (reports, 'Report program name. rep ', synchronous, runtime, filesystem, '', null); call the Report

I. Spatial table metadata Use all objects in the sdo_geometry column of the table as a space layer. Spatial needs to verify, create indexes, and query all spatial objects. In this case, you need to specify the appropriate metadata for the layer.

1. enable statistical log information Set autot on stat 2. Summary of Oracle Memory AllocationView SGA:Select * from V $ SGA; (Note that Oracle is a multi-process in UNIX and a single process in Windows)View the various pools actually allocated by

I want to start to systematically learn some basic Oracle knowledge. Although I am not a DBA, I want to learn some basic knowledge well this time. So I plan to take notes and make an outline, which is too specific. The content is not listed. Only

1. Create a table: Create Table stud (Sid int,Sname varchar2 (50))Insert a data recordInsert into stud values (1, 'Tom ') 2. Create a stored procedure -- Create a stored procedureCreate or replace procedure pro_select_name (V_sid in stud. Sid % type,

1. Create a table: Create Table stud (Sid int,Sname varchar2 (50))Insert a data recordInsert into stud values (1, 'Tom ') 2. Define a cursor through the package Create or replace package pack_studIs-- Declare a cursor typeType cur is ref cursor;End;3

In practical applications, tree structure data is widely used, such as the directory structure of books and the classification of organization departments !!!!! Such as the Directory of a book Name Code P_code

Use PLSQL developer to write packages and packages. Remember not to execute them simultaneously in the same SQL window., For example, in an SQL window Create or replace package my_package isFunction getrowcountbytable (tablename in varchar2) return

How to Handle System and SYS password loss in Oracle 　 This article describes how to handle system and SYS password in Oracle. One is OS verification and the other is password file verification. Oracle provides two authentication methods: OS

1. parameter settings during Database Installation The following database version is Oracle 9i ( 9.2.0 ), When the database is installed, the database system will create a database instance, where: The installation directory is/Oracle, the

Oracle relational database management system is a popular relational database system in the world. It is an extremely powerful, flexible, and complex system. It is said that this idea should be applied to Oracle, that is, almost any idea can be

Oracle Database performance Adjustment Oracle is a high-performance database software. You can adjust parameters to optimize the performance. Performance optimization is mainly divided into two parts: one is that the database administrator optimizes