Oracle

/* Step 2: Log On */log on to PL/SQL with sys/sys Super User/* Step 2: create a temporary tablespace */create temporary tablespace user_temp tempfile 'E: \ oracle \ product \ 10.2.0 \ oradata \ Wu \ user_temp.dbf 'size 50 m autoextend on next 50 m

How to delete duplicate data in Oracle Source: Unknown (11:13:48) We may see this situation where a table is not fully designed, leading to duplicate data in the table. How can we delete duplicate

Create or replace type mytable as table of varchar2 (100) /   Create or replace function split (SRC varchar2, delimiter varchar2) return mytable is psrc varchar2 (500); A mytable: = mytable (); I Number: = 1; -- J number: = 1; begin

1. ORA-01403: No data found Scenario: In one stored procedure, another stored procedure is called. One sentence is select a into B from table. When the queried A has no data, this exception will be thrown at this time: ORA-01403: No data

Installing the Oracle database software under liunx is not easy for beginners. This cainiao was successfully installed after a long time of hard work and did not dare to enjoy it during the intermediate process. I will announce it and share it with

What is checkpoint? What can checkpoint do? How does checkpoint run?   This is a problem we need to understand when we understand the checkpoint concept. It is also the three problems that we often cannot understand when understanding the

Today, we will briefly introduce how to modify the CRS-related resource attributes in Oracle GI 11gr2. In Oracle 11gr2, all resources have some default properties at the end of the installation. Resources include not only CRS resources, such as

I have read many friends who have started to pay attention to 11gr2 and started to start cluster of 11gr2. Today I met another friend who encountered an error in installing 11gr2.   This friend deployed the standalone grid infrastructure. Since it

You can view the data file number and block number of the bad data block to perform a full table scan on the table, for example:Select count (*) from tablename;1. If no backup is available:1.1 Use exp/imp for restorationIn this case, data may be

Normal 0 7.8 磅 0 2 false false false MicrosoftInternetExplorer4 Today, a friend suddenly asked me how to get the uid in Oracle. There are many methods. The following SQL statement should

V $ session is a synonym for SYS. V _ $ session view under apps.   In this view, each connectionDatabaseAll sessions in the instance have a record. Including user sessions and background processes such as dbwr, lgwr, and arcchiver.   V $

Commit is a very fast operation. When we release the commit command, the really difficult operation has been completed, Data changes have been performed in the database, so 99% of the tasks have been completed. For example, the following operations

Permission refers to the right to execute specific types of SQL commands or access other solution objects, including system and object permissions. 1. System PermissionsSystem permission refers to the right to execute specific types of SQL commands.

  Oracle interview questions-technical knowledge This may be an article you have been looking forward to. while paying attention to this part of technical questions, please be sure to read personal questions and answers during the interview. The

-- How to import DMP database files in Oracle?2006/2/16 Zhanghua first createImporting and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export data from the remote database server to the

OracleThe statement for creating database jobs is as follows: BeginSYS. dbms_job.submit (job =>: Job,What => 'proc _ YW ;',Next_date => to_date ('13-11-2007 14:00:00 ', 'dd-mm-yyyy hh24: MI: ss '),Interval => 'trunc

Introduction to using cube Functions To introduce the cube function, let's take a look at another example of using rollup.06:53:00 SQL> select area_code, bill_month, sum (local_fare) local_fare06:53:37 2 from t06:53:38 3 group by rollup (area_code,

public class PageUtil{ // Methods public static DataView GetListForPage(int index, int pagesize, string tabname, string key, string condition, string sortindex, ref int count) { int rscount = 0; StringBuilder strSql = new

The most commonly used cursor operation is to Perform Batch modification or batch deletion operations in the stored procedure. For example, after deleting a master table record, you can execute a stored procedure to delete the detailed records

1. Basic Structure Create or replace procedure(Parameter 1 in number,Parameter 2 in number) IsVariable 1 integer: = 0;Variable 2 date;Begin End stored procedure name 2. Select into statementSave the result of the SELECT query to a variable. Multiple