Oracle

Select * From dba_views;Select * From user_views; Desc dba_source; DESC user_source;Select text from user_sourceWhere name = 'your PKG name'Order by line;Union can remove duplicate records, but union all cannot.In Oracle, how does one call a stored

The 10 Gb archive log of Oracle Database is stored in flash_recovery_area by default, and 1 GB is selected during the default installation. When the archiving log exceeds 1 GB, the space is insufficient, so the archive log file cannot be archived.

-- Oracle service reconstruction method (-- telemt is the database name) > Oradim-New-Sid telemt-srvc oracleservicetelemt-intpwd Oracle-pfile C: \ oracle \ product \ 10.2.0 \ Admin \ telemt \ pfile \ init. ora.89200801642 -- Still unsolved>

  Oracle stored procedure: The Pag cursor outputs the search results based on the conditions .. Totalcount indicates the total number of queries. create or replace procedure DataGridPages(p_zcbm in varchar2,p_fwbm in varchar2,p_zcmc in

Although the clob and BLOB fields in Oracle meet the requirements for storing ultra-large content during development, they often cause troubles in some simple usage. Clob stores pointers and cannot directly obtain the actual values. The text field

Skills for using decode () functions in OracleDescription: Decode(Condition, value 1, translation value 1, value 2, translation value 2,... value n, translation value n, default value) The function has the following meanings: If condition =

The database table contains three columns: ID name banben (Version) (the column value is a number ). The ID is unique, the name is not unique, and the banben is not unique, but the combination of name and banben is unique. Find the ID of the row

How to use ORACLE analysis functions such as rank (), row_number (), and lag ()Row_number () over (partition by col1 order by col2) Indicates grouping by col1 and sorting by col2 within the groupThis value indicates the sequential number after

The problem is: change the name of the employee in the employee information table to another one. For example, change Zhang to Wang and only change the name without changing the name: Update table name set field name = 'King' | substr (field name, 2

Create or replace procedure ABCDE (MGR in number)AsType t_pubapplyrow is record (V_empno number (4 ),V_ename varchar2 (10));V_mgr EMP. Mgr % type;Type cur_test is ref cursor;Emp_cur cur_test;V_var t_pubapplyrow;BeginV_mgr: = Mgr;Open emp_cur for

All scripts and instructions for creating databases manually System Environment: 1. Operating System: Windows 2000 Server, 128 MB of machine memory 2. Database: Oracle 8i R2 (8.1.6) for NT Enterprise Edition 3. installation path: D: \ oracle Steps

Select to_char (add_months (last_day (sysdate) + 1,-1), 'yyyymmdd'), to_char (last_day (sysdate) + 1, 'yyyymmdd') from dual; 00 22 ***['Echo \ 'cal \ '| awk & apos; {print $ NF} & apos; '-EQ 'date + \ % d'] & do-something (do two at the end of each

1.Get help  imp help=y 2.Import a complete database  imp system/manager file=bible_db log=dible_db full=y ignore=y 3.Import all tables, indexes, and other objects of a specified user.  imp system/manager file=seapark log=seapark fromuser=seapark

Oracle query operation considerations 1. Fuzzy searchTo use the wildcard % and _ as character values, you must use the Escape Character After escape. For example:-- Query records starting with 'pt _ 'in the g3e_username FieldSelect * From

From: imports data from the Oracle table into an insert statement. Sometimes we need to import data from Oracle to other databases. Generating the insert into table name... is a simple and straightforward method. From www.arikaplan.com/oracle.htmlin

Deletes a column from a table in the database. Alter table tablename drop clumn clumnname; Some fields in the Database need to be modified because of the changes required. after checking the information on the network, the field name cannot be

Single Row Function Format: Function name [(parameter 1, parameter 2, parameter 3 ,...)] The parameters can be user-defined constants, variables, column names, and expressions. A single-row function operates only one row of data in the table, and

1. String concatenation Update tbl_main d set D. area_id = '0' | D. area_id 2. Stored Procedure and cursor Create or replace procedure prc_inset_dealAsBeginDeclareCursor main_departIsSelect * From main_bak;Temp main_bak % rowtype;BeginOpen

Many people have explained this online, the relevant code is also a lot, the code reference http://hi.baidu.com/bailang3106/item/c80b0fed8a08dbd1ea34c952 Http://baser.blog.51cto.com/4153192/871086   There is only one recipient process:  Create or

Http://blog.csdn.net/jisuanjixu/article/details/1741965excerpt s 1. Stop the Oracle listener immediately after it is started. TNS-12545: the connection failed because the target host or object does not existTNS-12560: TNS: protocol adapter error.TNS-