Oracle

The Cast usage of Oracle is often seen in the SQL of the predecessors, for example: www.2cto.com with t as (select level | ''l from dual connect by level select cast ('192. 100' as number (123) as num from dual;

Check whether the number of existing processes in the database has reached the processes parameter -- select count (*) from v $ process; to obtain the current number of processes in the database. -- Select value from v $ parameter where name =

Oracle timer simple operation first create a test table: SQL code create table JOBTEST (ID VARCHAR2 (50) primary key, NAME VARCHAR2 (20), AGE NUMBER (3 )) then write the stored procedure to be called by the Timer: SQL code create or replace

Oracle index monitoring reasonably creates strategic indexes for database tables, which greatly improves query performance. But in fact, the index we create in daily life is not a strategic index. It is precisely because a large number of redundant

Oracle table analysis description 1. Table analysis concepts 1. Simply put, information about tables and indexes is collected. The CBO (SQL Optimizer) determines the optimal SQL Execution path based on the information. Through table analysis, you

Sort the query results according to the in content. Today, the customer sends an excel table with a small amount of content. There are two columns: the license plate number and the device number, let me help export the information about the device

Create or replace procedure P_114_SEARCHNT (o_Cursor Out sequence, I _Begindate In varchar2, -- start time I _Enddate In varchar2, -- end time I _citycode In varchar2 -- Address Code) /*************************************** * *** function: author:

The TOP clause of the 1.TOP clause is used to specify the number of records to be returned. The TOP clause is very useful for large tables with thousands of records. Select top number | percent column_name (s) FROM table_name For example: select top

Oracle changed the field type from number (2) to number (2, 1). This afternoon, when I did something myself, I found a small problem. When I created a data table, the course_credit field of course is set to the number (2) type, which leads to the

Oracle undo tablespace is full. 1. Start SQLPLUS and log on to the database with sys. # Su-oracle $> sqlplus/as sysdba 2. Find the UNDO tablespace name of the database and determine the UNDO tablespace used by the current routine: Show parameter

Use of DBMS_SCHEDULER 1. Use DBMS_SCHEDULER.CREATE_JOB to directly CREATE a job [SQL] CREATE TABLE T_ROSANU (R_ID VARCHAR2 (10), R_DATE TIMESTAMP (6); -- the TABLE has been created. BEGIN DBMS_SCHEDULER.CREATE_JOB (JOB_NAME => 'job _ create_rosanu ',

Use EM to view the tablespace ViewNow let's take a look at how to use EM to view the table space view.Under Administration-Storage-Tablespaces, you can view table space indicators:For example, the table space usage, total size, remaining space, and

Common Methods for moving oracle files-moving tablespace files 1. querying the table space file name SQL> select d. name from v $ datafile d join v $ tablespace t using (ts #) where name = 'xport'; 2. Disable Database SQL> shutdown immediate; 3.

Installing oracle 10 Gb has encountered the cannot open shared object file error and solution [root @ dba ~] # Su-oracle [oracle @ dba ~] $/Mnt/runInstallerStarting Oracle Universal Installer... checking installer requirements... checking operating

Examples of views, sequences, and simple paging in oracle Use join on to join and group by to query multiple tablesCreate ViewDescription View StructureDESCRIBE view nameModify View:Create or replace view empv(Id_number, name, sal, department_id)As

Oracle listening service forced shutdown cannot start TNS identification Problem Solving Problem description: a while ago, when I went home while working on the project, I found that I could not connect to PLSQL. Then I found that tnslistener was

Sqlplus ora-12514 SolutionSearch file: [html] tnsnames. oraEdit: Add [java] # ----------------------------------------------------------------- to the last line.Locals =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP) (HOST = 127.0.0.1) (PORT = 1521

Oracle searches for and deletes repeated records in a table: a field in an application table is a primary key. when inserting data into a table, the data is first placed in a temporary table (without a primary key) then insert the application table.

Oracle trigger 6-manage trigger Oracle trigger 5-Instead of trigger http://www.bkjia.com/database/201304/203344.html 1. disable, enable, and delete trigger alter trigger trigger_name disable; alter trigger trigger_name enable; drop trigger

How can I recover the Oracle database for the first time! I have been familiar with oracle for several years, but I have been engaged in development for a long time, and there are very few opportunities to back up data. Recently, the company's ERP