Oracle

-- Create a table that acts as a child tableCREATE TABLE fk_t as select *from user_objects;Delete from fk_t where object_id is null;Commit-- creates a table that is the parent tableCREATE TABLE pk_t as select *from user_objects;Delete from pk_t

Two days to solve the configuration of configuring the Oracle listener to use SQL operations St_geometry, search a large web, the results really found only methods available, below this method I personally in the summary.ArcSDE10.1 Configuring the

If loop control statementIf -- then endifIf ---- then ---- else endifIf ----- then -- elsif then ---- else endif-- Write a process and enter an employee name. If the employee's salary is lower than 2000, the employee will be increased by 10%.Create

Create table mytest (name varchar (20), password varchar (30 ));Create or replace procedure sp_pro2 isBeginInsert into mytest values ('fc ', '123 ');End;View error informationShow errorHow to call this process:1. exec process name (parameter ,..)2.

Triggers and packages based on PL/SQL Package /* Package: encapsulate objects such as stored procedures, functions, variables, cursors, and exceptions. Voice and body composition Advantages: 1. modularization; 2. Easier application design; 3.

During routine database maintenance, we will find some objects in the database (Package, stored Procedure, Function, View, synonym .....) it becomes INVALID and is in an INVALID status (INVALID ). Sometimes it is necessary to regularly check which

Application connection test database times ORA-12516: TNS: listener cocould not find available handler with matching protocol stack Check the listening log file and find a large number of TNS-12516 errors

1.1.1. ORA-19502, ORA-27072 Date: Environment: Testing Machine [Error code] $ Oerr ora 1, 19502 19502,000 00, "write error on file \" % s \ ", block number % s (block size = % s )" // * Cause: write error on output file // * Action: check the file $

16. After installation, the following page is displayed. You need to log on to the following directory with root and execute these two scripts. Now, the installation of the Oracle software is complete, and you can create a database. VcD4KCjxwPjE3

Today, you can not log on to the tomcat front-end interface, view the log found that the original ORA-28001: the password has expired error, this error is caused by the new features of Oracle11G, when creating a user at Oracle11G, the default

DG has the following three modes:-Maximum protection-Maximum availability-Maximum performance In Maximum protection, the slave database and master database data are exactly the same, so that zero data loss transactions are committed on both sides

The CNT option makes the Oracle client attempt to use your current Windows domain credentials to authenticate you with the Oracle server. This cocould fail for a couple of reasons:-The Oracle server is not configured to support Windows

In the project database design process, because the data volume of a single table is very large, you need to partition the table. Because the data in the table is a historical transaction, it is partitioned by month to improve query and management.

1. Create a userCreate user @ username identified by @ passwordExample: create user aobama identified by futureA user named "aobama" is created, and the password of this user is "future ".Note: The Administrator (DBA) permission is required for

Oracle bitand () functions are common in Oracle databases. The following describes the usage of Oracle bitand () functions in detail. If you are interested, take a look. Oracle bitand () functions: Returns the result of the bitwise and operation

When I execute: INSERT INTO MERs (Customer_id, first_name, last_name, dob, phone) VALUES (5, 'doreen', 'Blue ', '20-MAY-1970', NULL);The error "ORA-01843: Invalid month" occurred. After Google, find the following article, which says to executeAlter

How Does ORACLE 11G modify awr retention period less than 8 days? Oracle Database 11g has a system-defined Moving Window Baseline by default. This Baseline corresponds to all AWR data during the AWR retention period.Only one Moving Window Baseline

ERROR: ORA-28002: the password will expire within 7 days The error is that the password is about to expire. There are two solutions to this problem. 1. Modify the password of the user who has reported an error The account that has been reported that

In 11g, statistics are automatically collected at PM (Monday to Friday, 4 hours) and am (Saturday, Sunday, 20 hours) by default ), as follows: select a.window_name, a.repeat_interval,a.duration from dba_scheduler_windows a,

Cancel provides three types of Set Operations: UNION, INTERSECT, and MINUS) UNION: merges the results of multiple operations into one query result, returns the UNION of query results, and removes duplicates automatically. Union all: Merge the