Oracle

My local database version installed is Oracle 11g R2, when using PLSQL connection, the following error is reported ora-12514: However, when using sqlplus in cmd to connect a user already created, the following error is reported: Oracle not

V $ Session V $ session_waitV $ ProcessV $ SQLV $ sqltextV $ BHV $ lockV $ latch_childrenV $ sysstatV $ system_event Important performance views by group 1. System over ViewV $ sysstat, V $ system_event, V $ Parameter 2. Current situation of a

To create a synonym for this user, you must have the "Create synonym" permission; To create a synonym for another user, you must have the "create any synonym" permission; If you create a public synonym, you must have the "Create public synonym"

Set serveroutput on OPEN Server Screen Display InformationWhen you compile an SQL statement on set sqlblanklines, the ignore space function is enabled. Save c:/sqlplus_test01.txt -- saveEdit -- open notepad to editGet c:/sqlplus_test01.txt --

Copy the following address to Xunlei to download it, including the latest 10.2.0. 5 patch Release ORACLE 9iOracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XPhttp: // Login Acle9i/9201/92010 NT_Disk3.zipOracle9i

First, the cause of the problem. This error occurs when I delete a file under \ oracle \ product \ 10.1.0 \ oradata \ oral. When I used SQL statement statements to create a tablespace, I was so anxious to delete the created file. The problem arises.

1. Method 1: Use loadjava; (1) Use the JDK provided by Oracle to compile the Java source fileD:/> C:/Oracle/product/10.1.0/db_1/JDK/bin/javac showdate. Java Note: The machine may have a multi-version JDK environment, but you must use the JDK that

Create a stored procedure script file, such as test. SQL Create or replace procedure DIS_1AsI integer;BeginDBMS_OUTPUT.PUT_LINE ('Hello Beijing ');End;/ Note the last/Character SQL> @ test. SQLProcedure created. SQL> set serveroutput on SQL> exec

1. pga_aggregate_target Starting from Oracle9i, Oracle introduced the new feature of automatic PGA management. The PGA_AGGREGATE_TARGET parameter is used to control the overall expected goal of PGA, but in Oracle9i, the PGA_AGGREGATE_TARGET

The computer system crashed. The original XP system was installed with win7. the oracle database was not backed up before the reinstallation. The following describes how to restore the original database. I checked it online and I have different

Compiling jobs in Oracle In Oracle, you can write a Job to regularly execute a stored procedure. The specific method is to use the Submit () process. Several parameters of the Submit process: job, what, next_date, interval, and no_parse. The

　1 Overview The monitoring and management of the Oracle SGA area is an important part of routine database maintenance. This article describes the basic concepts of SGA, the SGA running status check, and the parameter setting principles of SGA. 　　2

Create or replace package body curspkg is procedure sp_page (p_pagesize in out int, -- number of records per page p_curpageno in out int, -- current page number p_sqlselect varchar2, -- query statement p_totalpages out int, -- total page

The ROW_NUMBER () syntax is as follows: 1. row_number () over (order by column desc) first returns a serial number for each record in descending order for the column: select d. *, ROW_NUMBER () OVER (order by d. R _ OPATE_NUM DESC) AS region FROM

/*************************************** * ****************************** Query the select * from object deleted by the Drop operation recyclebin; restore a flashback table (the type of the deleted object) for a single object (table, index, or other

People who have just been familiar with ORACLE will feel helpless when they learn, how to learn, what tools are available, and what operations should they perform. So before learning to use ORACLE, first install ORACLE 10 Gb to master its basic

Http://lwl0606.cmszs.com/archives/oracle-string-add-function.html Add the DSPNAME values of the same Account as the following table.Account DSPNAMEL1 aaL1 bbL2 ccResult L1 aa, bb L2 cc Method 1: Use cursor in the function   Code highlighting

Previously, PL/SQL Developer was used for implementation, but PL/SQL Developer had two problems in exporting and importing data: 1. Separate and export table data and objects (stored procedures and views) 2. If the exported view has comments, errors

(In particular, this post mainly comes from "Fun C technology. NET ", I made some edits and added a little bit of my opinion. For the original article, see Ghost. NET. In addition, you can add a number for your blog .) Error Code: ORA-01033: ORACLE

Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/-->-- Create sequence first creates a sequence (here SEQ_LASTYEARDISCASE is the sequential column name) Create sequence my sequence name