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

Workaround: 1. Login with DBA role; 2, enter the following format command unlock: Alter user username account unlock; 3, if the password forgotten, enter the following format command to modify the password: Alter user username identified by new

Oracle databases sometimes accidentally delete data, want to query this data, or recover data, you can use a SELECT statement with the AS clause for a flashback query. Flash-back query for data from a time period in the past SELECT * from TB as

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

Build Table Statement (ORACL) (Contains records) --Create TABLE CREATE TABLE STUDENT (studentid number (), studentname VARCHAR2 (30), studentscores Number (3) ) INSERT into STUDENT (StudentID, Studentname, studentscores) VALUES (1001, '

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

Use Oracle users to execute the following script: #!/bin/bash source/etc/profile export Nls_lang=american_america. ZHS16GBK #Oracle的字符集, the Chinese character set for the Oracle database is American_america. ZHS16GBK #Oracle数据库的根目录 export

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;

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