Oracle

--Bulk Modify the name of the table partition DECLARE V_sql VARCHAR2 (1000); BEGIN For X in (SELECT table_name, partition_name From User_tab_partitions WHERE to_date (SUBSTR (REPLACE (Partition_name, ' _ ', '),-6), ' Yy-mm-dd ' Add_months (TRUNC

--Delete partition test --Created on 2014-10-08 by LENOVO Declare --Local variables L_begin_date DATE; L_end_date DATE; L_begin_time DATE; L_sql VARCHAR2 (2000); Begin --Test statements here L_begin_time: = l_begin_date; For L_partname in (SELECT

If you are connected to your native Oracle: 1, in the cmd command line to try: Ping native IP address; 2, to ensure the shutdown firewall 3, the database listener started 4, of course, also does not exclude the caching problem, so need to

At present, the main data warehouse development, the following major records need to optimize the process of SQL learning, reference data "Oracle query optimization rewrite skills and cases", mainly learning notes, covering the following chapters,

Field type: Blob,clob,nclob Description: Three large objects (lobs) to hold large graphics files or formatted text files, such as Miceosoft Word documents, as well as audio, video, and other non-text files, the maximum length is 4GB. There are

A stored procedure consists of three parts: a declaration, an execution section, and an exception.can have parameter-free programs and stored procedures with parameters.Non-parametric program syntax1 Create or replace procedure Noparpro2 as;3 begin4;

－－－－－－－－－－－－－－－－－－－－－－－－－－ Initialize related parameters job_queue_processesAlter system set JOB_QUEUE_PROCESSES=39 scope=spfile;//maximum value cannot exceed 1000 job_queue_interval = 10//Schedule Job Refresh frequency seconds Job_queue_process

The problem with a long field I have encountered, if you want to take the value of a long field, you must see the processing. To add a new method: /** * Insert the method´s description here. * Creation Date: (2002-6-4-17:37:55) */ public static

1, start the database: Oracle@suse92:~> Sqlplus/nolog Sql*plus:release 9.2.0.4.0-production on Fri 20 02:29:37 2006 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Sql> Connect/as SYSDBA Connected to a idle instance. Sql>

1 in the PowerDesigner table, and the various associations between the tables, when finished, select the menu item in the "Database" under the "Generate Database", find a path, save as a SQL statement. 2 in Pl/sql, tool "Import table, select the

Simple and practical, not much nonsense said: [SQL] view plain copy Select Substr (' A, ', 2,1) from dual;substr (' character to intercept ', length of character, character length-1) Extended: [SQL] view plain copy Select substr

1, in the Powerdesinger design table (1) After downloading Powerdesinger, right key new-->physical data model default name is: Physicaldiagram_1, right key new-->table, start table design (2) Configuring an ODBC data source Configure the ODBC data

If your user does not have DBA authority and only wants to view the number of records for all of the tables in this user (note: Not all tables in the library you said), change to: EXECUTE dbms_utility. Analyze_schema (' MyUserName ', ' COMPUTE ');

Oracle queries all table records of users Because of the need to upgrade the application in the field, to assess the amount of data for security purposes, Oracle, a command can be done. One need to be aware that users with DBA authority are

Oracle in depth fifth chapter locking and latching LocksIn Single-user systems, locks is not needed. In multi-user system, in order to allow multi-user access to data, modify data, modify the structure, you need a mechanism to ensure that

When you debug a stored procedure a few days ago, Oracle inexplicable error, when the stored procedure to a section of SQL, how to do not pass the past, and finally the sqlcopy out of the separate execution OK, when a specific record of the change,

Http://hi.baidu.com/cuigq_hr/blog/item/ba2bc167ed79022eaa184c34.html 1. A summary of the dates after the Sysdate conversion: Select To_char (sysdate, ' yyyy-mm-dd hh24:mi:ss ') today_date,--the time of the day with the seconds(Sysdate-to_date (' 197

DECLARE CURSOR Tab_cursor is SELECT table_name from user_tables;   V_table_name User_tables.table_name%type;   V_num number; V_P1 number;   BEGIN Open tab_cursor;      Loop fetch tab_cursor into v_table_name;      Exit when Tab_cursor%notfound;

Three highly available cluster scenarios for Oracle Take a look at the official Oracle Web page and the unofficial PPT to get a quick look at the high availability offered by Oracle. There are three main types: 1. RAC RAC, real application

http://www.itpub.net/forum.php?mod=viewthread&tid=1776483&pid=21223451&page=1&extra=# pid21223451 In the actual project, it is often necessary to invoke the cursor returned by another stored procedure in one stored procedure, and this article