Oracle

Add the following statement to the function to indicate transaction autonomy. PRAGMA AUTONOMOUS_TRANSACTION;   Example: SQL codeCreate or replace function func_made_applycode (schoolcode in varchar2, spe_level in integer) return varchar2 isResult

The question mark is displayed in SQLPLUS. in linux, the question mark is displayed in sqlplus, as shown below: [oracle @ why-server ~] $ Sqlplus/as sysdba SQL * Plus: Release 11.2.0.1.0 Production on Wed May 15 16:20:03 2013 Copyright (c) 1982,200 9

Get DDL metadata SQL comes from the get_ddl function in the dbms_metadata Package of metalkink. Its usage is as follows: -- GET_DDL: Return the metadata for a single object as DDL. -- This inte *** ce is meant for casual browsing (e.g ., from

In the Product detail split project, the Schema and User in Oracle need to split the original Product table into two tables: Product and Product_detail. The database creates a Schema named alibaba1949. I do not know about the schema, but I have also

The split function implemented by the oracle stored PROCEDURE, which separates the string [SQL] PROCEDURE SPLIT_STRING_SP (P_INSTR IN VARCHAR2, -- input string, separated by commas (,), and input parameter P_STRS OUT VARCHAR2, -- truncate the

The Oracle db_file_mulitblock_read_count parameter Oracle DB_FILE_MULTIBLOCK_READ_COUNT is an important global parameter in Oracle, which can affect the system level and sessioin level. It is mainly used to minimize the number of data blocks that

[Oracle] uses autonomous transactions to implement the audit function. In a transaction (outer transaction), one or several autonomous transactions can be defined. An autonomous transaction can be committed independently without affecting the outer

Oracle startup error: OracleOraDb11g_homeTNSListener service on the local computer starts... SolutionMethod 1:This problem occurs because of an issue with your Oracle file;In your Oarcle installation path: D: \ Oracle11g \ product \ 11.1.0 \ db \

ORACLE uses TNSNAMES. for UNIX platforms, ORACLE first looks for the environment variable TNS_ADMIN. If the environment variable exists, it goes to the directory specified by the environment variable to find tnsnames. ora file. Otherwise, go to the $

Empty oracle table ticket cleanup 1. query table space usage: sqlplus system/manager @ topprodSQL> @ q_tbsFREE2. how to query temp: sqlplus system/manager @ topprodSQL> SELECT d. tablespace_name, d. status tablespace_status, NVL (. bytes, 0)

The truncate implicit commit colleague asked me to check the problem. procedure jumped out of exception and rolled back in the middle, but some table commit still exists, but no commit statement was found before rollback. it is still a DDL implicit

The oracle client could not connect to the server. The solution was to try to connect to the oracle server today, but it was always unsuccessful. later it was discovered that the firewall was enabled on the server, so the firewall added an exception

Oracle Database Index 1 index basic concept index is a data object used to accelerate data access. Rational Use of indexes can greatly reduce the number of I/O operations, thus improving data access performance. Single-Column index: an index created

Primary Key constraints automatic index creation constraints are used to ensure the integrity of database data. In oracle databases, you can use constraints, triggers, and application code (processes, functions) to achieve data integrity, among the

Trouble shooting: FRM-30425 resolution keywords: Oracle Form buider FRM-30425 summary error information: [plain] FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes. item: CNT_CON

[Oracle]-[EM]-solve the problem that EM cannot be opened for a long time and it has not been opened yet. This error occurs today: SQL> select username, account_status from dba_users; USERNAME ACCOUNT_STATUS extends outln opensys opensystem

ORA-55622: DML, ALTER and create unique index operations are not allowed on table execute statement: delete tablespace reports error, drop tablespace name error symptom: ORA-55622: DML, ALTER and create unique index operations are not allowed on

Files managed by OMF will be automatically deleted by experienced DBAs. When you drop tablespace, data files will not be deleted without the words including contents and datafiles, during the demonstration on Sunday last week, when you drop

Oracle create and manage tables/* ----------------------- create and manage tables --------------------------- */1. Data Types in Orcale: 1. NUMBER, DATE, VARCAHR, CLOB, BLOB 2, and table Creation Create table Name (field name 1 field type [DEFAULT

Oracle self-study (3) [SQL] pl/SQL language and programming: declare --- declare variable begin --- execute statement except10n end; for example: declare v_department char (3); v_course number; begin insert into classes (department, course) values