Oracle

Oracle exceptions are predefined and custom exceptions (personally felt). Predefined exceptions include anonymous exceptions and non-anonymous exceptions. (Anonymous exception: No name, like ORA-00371; Non-anonymous exception: name, like

There is a project because there are more query summaries, considering the speed, so the materialized view is used.   Simply put the used to the next to tidy up. First look at the simple Create statement: Create materialized view

Example 1:select deptno,ename,job,sal,sum (SAL) over (order by Sal) his from EMP; Results: SMITH Clerk JAMES Clerk 950 1750 ADAMS Clerk 1100 2850 WARD salesman 1250 5350 MARTIN salesman 1250 5350 MILLER Clerk 1300 6650 TURNER salesman 1500 8150

I want to add a network card to the Oracle VirtualBox for the internal network, and another machine to do the heartbeat heartbeat test. How to add it. Turn off the virtual machine and add a virtual NIC: After you start the virtual machine, you

Local=no and Local=yes in the Oracle process Reprinted to Http://www.cnblogs.com/wjoyxt/p/3780860.html We connect the database with Sqlplus on the server, and when we view the process, we have one more record: Oracle 16007 16006 0 10:27? 00:00:00

The syntax format is as follows: Lpad (String, Padded_length, [pad_string]) String Prepares the string to be filled; Padded_length The length of the string after the padding, which is the length of the string returned by the function, if the number

When you first use Oracle database, we may find it more difficult, in general, the initial use of a database, we would like to know what the operation is, the author believes that may be the following questions. 1, how to enter the SQL

Sometimes we accidentally delete the important records in the database table (EMP), how to get it back, look at the example below you will understand. One day, 10 o'clock, John accidentally deletes an important record of the EMP in the database

1. Create a table first SQL code [SQL]View Plain copy print? CREATE TABLE TE (ID VARCHAR2 (2), T_code VARCHAR2 (4), T_name VARCHAR2 (4), T_amount INTEGER , T_dept VARCHAR2 (4), T_project VARCHAR2 (4), T_type VARCHAR2 (1)) CREATE TABLE TE ( ID

We may encounter this situation in the operation of the database, the data in the table may be repeated, so that we have a lot of inconvenience in the operation of the database, then how to delete these duplicate useless data? The data

Oracle complains when deleting table A records: "ORA-02292: Violation of full constraint (XXX.FKXXX)-Child records found 1, find the "fkxxx" as a foreign key table a child table, run directly Select A.constraint_name, A.table_name,

JDBC Programming Steps:----Java-Oracle Data connection (under Lomboz_eclipse environment)1. Locate the JDBC Folder →lib folder in the Oracle Database installation folder →classesl2.jarImport this jar package in 2.lomboz_eclipseImport Method:Create a

Select T.table_name,t.num_rows from User_tables t If the above SQL is not found, execute the following script:>>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>>>>>>>>>>>>>>>>>>>>>>> >>>>>Create or Replace function count_rows (table_name in VARCHAR2,Owner in varchar2

CREATE tablespace shopping datafile ' D:\oracle\mypc\oradata\orcl\shopping.dbf ' SIZE 20M autoextend on; Create user shopping--creating username identified by shopping-password password character default tablespace shopping--default table space

Special symbol ASCII definition Box Drawings Chr (9) Line feed Chr (10) return character Chr (13) Select Replace (replace (' 111111111111 ' | | chr) 22222222222222222 ' | | Chr (a) | |

Error when connecting to Oracle database using DB Browser Wizard in MyEclipse: Error while performing database login with the Oracle.jdbc.driver.OrcaleDriver driver:Ora-00604:error occurred at recursive SQL level 1Ora-12705:cannot Access NLS data

Sql> CREATE TYPE tab_varchar2 as TABLE of VARCHAR2 (4000); 2 / Type created. sql> CREATE OR REPLACE FUNCTION concat_array (P tab_varchar2) return CLOB is 2 l_result CLOB; 3 BEGIN 4 for cc in (SELECT column_value from TABLE (p)

substr (String, -10) Oracle string function substr (string, intercept start position, intercept length) 1. If the last intercept length parameter is empty, it means that the intercept starts at the bottom 2. If you intercept the start position

A very handy data import tool Tttableschemafromoraqueryget and Ttloadfromoracle are added to the TimesTen 11.2.2 release. You can simply load the table structure and data quickly into the memory library without using the cache group. However, this

1, Login server 2. See if the disk space is big enough df-h -H more Current disk space and usage to be displayed in a more readable way [Root@rac1 ~]# Df-h FileSystem Size Used Avail use% mounted on /DEV/SDA1 2.9G 2.3G 521M 82%/ None 209M 0 209M 0%/