Oracle

11g scheduling -- scheduler use CREATE_SCHEDULE Procedure www.2cto.com This procedure creates a schedule. DBMS_SCHEDULER.CREATE_SCHEDULE (schedule_name IN VARCHAR2, start_date in timestamp with timezone default null, repeat_interval IN VARCHAR2, end_

Modify the field type of existing data in Oracle [SQL] www.2cto.com create table t_person (id varchar2 (200) primary key, name varchar2 (200), address varchar2 (200 )); [SQL] insert into t_person (id, name, address) values (sys_guid (), 'hangsan',

Oracle recovery accidentally deleted the table. Today, PLSQL accidentally clicked the drop action on a table, causing the table to be deleted. Www.2cto.com eventually uses the following command to restore: flashback table username. T_tableName to

In oracle, the deleted data database is retrieved in a timely manner. select * from whir $ t3068 as of timestamp to_timestamp ('2017-03-30 9:00:00 ', 'yyyy-mm-dd hh24: mi: ss') select * from whir $ t3068 as of timestamp sysdate-750/1440; flashBack

Orcl create user permissions 1. system permissions classification: DBA: All privileges are granted, which are the highest permissions of the system. only DBA can create a database structure. RESOURCE: users with Resource permissions can only create

Oracle transaction features a transaction refers to a complete logical process composed of a series of database operations. For example, the bank transfers, deducts the amount from the original account, and adds the amount to the target account. The

Clear concepts related to Oracle Fusion MiddlewareI recently learned this kind of knowledge and found a detailed introduction to the concept of Oracle Fusion Middleware, which is very rewarding. I would like to share it with you in detail. Oracle

Environment where sys cannot log on remotely: the database ORACLE 10 Gb is installed on the data Server A (Red Hat Enterprise Linux Server release 5.5 (Tikanga, however, we cannot log on to the database remotely from machine B with the DBA account.

ORACLE startup and utilization data dictionary 1. ORACLE startup and shutdown 1. To start or shut down an ORACLE System in a standalone environment, you must first switch to an ORACLE user, the following are su-oracle a and ORACLE> svrmgrl SVRMGR>

Case... when... then statementCASE is a keyword used by SQL as a logic such as if-then-else.// Syntax:Select case ("column name ")   WHEN "condition 1" THEN "result 1"   WHEN "condition 2" THEN "result 2"   ...   [ELSE "result N"]  ENDFROM "table

ORACLE encountered a TNS-04415 error with netca configuration listeningError descriptionD: \ Users \ Elvis> netcaOracle Net Services Configuration:Configuring LISTENER: LISTENERServiceAliasException: unable to save service alias: TNS-04415: file I/O

SQL in the special string truncation techniques in the preparation of SQL, will always encounter a special meaning of a field value, the interception of a piece of the value of the return, such as a string SSOC-XXX-13-001, now you need to return 13

Common Database Operation 1 in work. create a tablespace in PLsql: Method 1: create tablespace biaokongjian [tablespace name] datafile 'd: \ oracle \ product \ 10.2.0 \ oradata \ ORCL \ temp. dbf' [tablespace data storage address and file name] size

In Oracle's left-and right-connection PL-SQL, the left-and right-connections are implemented in the following way: SQL code SELECT emp_name, dept_name FORM Employee, Department WHERE Employee. emp_deptid (+) = Department. deptid this SQL statement

Dynamic SQL of stored procedures in the ORACLE package --- create or replace package test_pkg is g_public_flag varchar2 (1); function test_function (p_param1 varchar2, p_param2 varchar2) return varchar2; function hello_function (p_param3 varchar2)

Oracle integrity constraints are used to enhance data integrity. Oracle provides five integrity constraints: Check not null Unique Primary Foreign key integrity constraints are a rule, it does not occupy any database space. Integrity constraints

Create a table in Oracle and an auto-increment table in primary key: create table tuser (id number (11) not null, name varchar2 (20) not null, password varchar2 (20), birthday date, constraint tuser_pk primary key (id); create sequence: create

Alter table open parallel operation use alter table open parallel first create a table create table a_test (name varchar2 (10) insert into a_test values ('aaa'); select * from a_test; NAME ---- aaa add an age and then use the parallel alter table

The database of the Oracle 11g virtual column Acme contains a table named SALES, as shown in the preceding figure. The table structure is as follows: SALES_IDNUMBERCUST_IDNUMBERSALES_AMTNUMBER some users want to add a column named SALE_CATEGORY to

Rman restore recover C: \ Users \ Administrator> rman recovery MANAGER: Release 10.2.0.1.0-Production on Sunday March 31 20:10:53 2013 Copyright (c) 1982,200 5, Oracle. all rights reserved. RMAN> connect target \ target database password: connect to