Oracle

In the previous articleArticleIn the internal connection discussion, we used the self-connection to find out the names of all people and their superiors. However, there is a problem: King is the boss of the entire Organization and he has no

The last time I encountered a small problem, I accurately described it as a design defect. Let's first look at the problem, 3. For DEPT and EMP tables, query the results in the following format and arrange the results in descending order of

Create smallfile tablespace "newts" datafile 'd: \ app \ oracle \ oradata \ orcl11g \ newts01.dbf 'size 100 m autoextend on next 10 m maxsize 200 mlogging/* all operations on segments in the tablespace will generate redo content, which is the

Statement 1:   Select rownum, .*From (select T. brand_name, wm_concat (T. pd_type), wm_concat (T. brand_id)From base_brand tGroup by T. brand_name) Statement 2: Select 'insert into base_brand_info (brand_id, brand_name, brand_name_cn) values

Create or replace procedure pro_drop_comment is Cursor c_table_column is Select * From user_tab_columns; Cursor c_table is Select * From user_tables; Cursor c_view is Select * From user_views; SQL _drop_comment string (100 ); Begin

ArticleDirectory   For the rownum problem in Oracle, many documents do not support>, >=, =, between... and. The preceding symbols can only be used (,> =, =, .. and will prompt SQL syntax errors, but often cannot find a record,

How to make Oracle stored procedures return result sets How does one allow Oracle stored procedures to return result sets?Oracle stored procedure: Java call code: Try { drivermanager. registerdriver (New Oracle. JDBC. oracledriver ();

1.Function 1) Create a function Create or replace function get_tax (X number) return number as begin declare y number; begin Y: = x-2000; if x 2) Execution function SQL> select get_tax (1000) from dual; Result: Get_tax (1000) ---

Install Oracle 10g (10.2.0.1.0) on Red Hat enterprice linux4) Step 1 Preparation ? Check memorySz_tomcat:/home/xjy/soft> grep swaptotal/proc/meminfoSwaptotal: 2031608 KB ? Check the kernelLinux reaky.com 2.6.9-5. elsmp #1 SMP wed Jan 5 19:30:39 est 2

Permission management, menu management, general framework, Oracle database, ASP. NET, Oracle function, Oracle package 1. Table Creation User permission series Table menu Log Series table Spool ora_tables.logprompt permission classification table

Checking operating system requirements...Expected result: One of redhat-3, redhat-4, SuSE-9, asianux-1, asianux-2Actual result: redhat-4Check complete. The overall result of this check is: passed=======================================================

Primary Key (PK ):The column name that uniquely identifies a record. Foreign key (FK ):The foreign key refers to the primary key, which indicates a typeOne-to-multipleLink. Intranet connections are divided into three types: ① Equijoin:The two tables

The temp table has 94 data records in the above structure. Pagedemo. Java: Public class pagedemo {public static void main (string [] ARGs) {consumer SC = new consumer (system. in); While (true) {int page = SC. nextint (); getresult (PAGE) ;}}

1. Set the Linux computer character set so that it is consistent with the Oracle database character set on the computer; On the Linux command line interface, Query the character set of an Oracle database: Select * From nls_database_parameters t

set echo onspool D:\oracle\app\admin\ocp11g\sctripts\cteatedb.logstartup nomount pfile"D:\oracle\app\admin\ocp11g\sctrpts\init.ora";create database "ocp11g"maxinstances 8maxloghistory 1maxlogfiles 16maxlogmembers 3maxdatafiles 100datafile 'D:\oracle\

1. Use v $ session and V $ locked_object to check who has locked the resource. Select t1.sid, t1.serial #, t1.username, t1.logon _ time From v $ session T1, V $ locked_object T2 Where t1.sid = t2.session _ id Order by t1.logon _ time   More: Select

Speaking of hwm, we should first briefly talk about Oracle's logical storage management. We know that Oracle has four granularities in logical storage: tablespace, segment, partition, and block. (1) block: it is the smallest storage unit. Currently,

Ref_cursor for Oracle Development PL/SQL language development Reference ManualPrefaceWe are no longer familiar with ref_cursor. We have been familiar with ref_cursor in our previous blog: in the blog "How to make Oracle Stored Procedure return

Steps for Oracle to back up and restore table space data In the previous blog, you used logical backup exp/imp for full-database backup, single-table or multi-table data backup. This article summarizes how to use exp/IMP to back up tablespaces. The

Oracle study note _ trigger   Trigger The code block automatically executed when a specific event occurs. It is similar to a stored procedure, but users cannot directly call them. Function:1. Allow/restrict table modifications2. automatically