frankeyf的专栏

Sql代码--1.建包       1. CREATE OR REPLACE PACKAGE my_pak AS        2.    TYPE my_cus IS REF CURSOR   ;         3. END my_pak;     --2.写存储返回过程       1. CREATE OR REPLACE PROCEDURE sp_add_emp3(         2.     v_empno emp.empno%TYPE,         3.  

 ☆dba_开头.....dba_users 数据库用户信息dba_segments 表段信息dba_extents 数据区信息dba_objects 数据库对象信息dba_tablespaces 数据库表空间信息dba_data_files 数据文件设置信息dba_temp_files 临时数据文件信息dba_rollback_segs 回滚段信息dba_ts_quotas 用户表空间配额信息dba_free_space 数据库空闲空间信息dba_profile

Using packages:define function in packagescreate or replacePACKAGE FUNCTION_PAK AS FUNCTION GET_F_S_C(p_tname in varchar2,-- parent table namep_cname in varchar2,-- parent foreign key column nametname in varchar2, -- referenced table namecnam

<br />Error<br />Named Exception<br />ORA-00001<br />DUP_VAL_ON_INDEX<br />ORA-00051 <br />TIMEOUT_ON_RESOURCE<br />ORA-01001 <br />INVALID_CURSOR<br />ORA-01012 <br />NOT_LOGGED_ON<br />ORA-01017 <br />LOGIN_DENIED<br />ORA-01403

The EXECUTE IMMEDIATE statement prepares (parses) and immediately executes a dynamic SQL statement or an anonymous PL/SQL block. The syntax

有空再翻译吧If we need to recover a scheme which default LANG is WE8ISO8859P1 and our database isAL32UTF8, the import process crash because the special characters during the conversion pass from one b