Oracle

I helped a friend with Oracle cross-database operations a few days ago and shared the specific operation process: 1. database with different IP addresses (dblink) Local Database IP address 10.56.7.26 Remote database IP address 233.215.219.8 1

/* Memory space parameters allocated for creating Bitmap indexes to accelerate index creation */ Show parameter create_bit; /* Change the index storage parameter */ Alter index index_name pctfree 30 storage (initial 200 K next 200 k ); /*

Query The SELECT statement is used to query data from the database. When the SELECT statement is used in PL/SQL, it must be used with the into clause. The return value of the query is assigned to the variable in the into clause, variable

Recently I want to optimize some SQL statements for full table scan. The first thing I think of is index creation. I checked the online information and said that if there is null or is not null in the WHERE clause, the index will not be used, but I

In a QQ group, I saw a person learning about the overview and learning plan of the hardware abstraction layer (HAL) of Android during his android journey. When I encountered a problem, I went to the workshop.ArticleToday, I will give you a

// Create a temporary tablespaceCreate temporary tablespace gcag_tempTempfile '/u01/APP/Oracle/oradata/Xe/gcag_temp.dbf'Size 32 mAutoextend onNext 32 m maxsize 2048 mExtent management local; // Create a data table spaceCreate tablespace

Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch with a lot of things outside of

1. Grant the select permission of one user to another user (executed as sys ): Select 'Grant select on Cisco. '| table_name |' to Chen; 'from all_tables where owner = upper ('cisco '); Authorize all tables under a Cisco user to the user Chen.   2.

1. Execute immediate will not commit a DML transaction execution and should be committed explicitlyIf you use execute immediate to process DML commands,Before the execution is complete, you need to submit it explicitly or as part of execute

Create a MyApp under/packages/apps/and use eclipse to create a project, so that you can use ADT to generate configuration files quickly, copy/packages/apps/MyApp/GEN/COM/example/MyApp/R. delete the classes defined in Java. Do not repeat them. The

I have never been familiar with Oracle. I have learned a lot from my brother's demonstration today, so I wrote this article to record it. Let's talk a little bit about the situation: Environment: Windows2003 + oracle9i is installed in vpc2007 as the

Record variable Define a record variable using the type command and % rowtype. For more information about % rowstype, see related materials. Record variables are used to extract data rows from the cursor. When multiple columns are selected for the

Use query in a cursor For Loop You can define a query in a cursor for loop. Because no explicit declaration is made, the cursor has no name, and the record name is defined through the cursor query. Decalre V_tot_salary EMP. Salary % type; Begin For

When I accidentally executed the left outer join query of Oracle 9i, I found some incredible problems. I will post them here to discuss with you. Create tables and records to simulate the current situation: Create Table temp_test1 (A number

--------------------------------------------------------------------------- ---- This is andkylee's personal originality. Please repost it with respect to the author's Labor achievements; ---- The original source must be specified for

Configuration file: --> {Call p_test (?, : Vpostno )} Stored Procedure: Create or replace package testpackage Type test_cursor is ref cursor; End testpackage;   Create or replace procedure p_test (p_cursor out testpackage. test_cursor,Vpostno in

Oracle development often suffers from invalid stored procedures and functions from time to time, so I made up my mind to solve this problem. I found a good solution and modified it On the basis, I finally solved the problem. 1. Create a stored

Before writing a program, you need to implement the function of querying the tablespace usage in the database. Although you do not know the significance of doing it, you have to do the project requirements. I wrote one and can only find permanent

Parallel Processing generally involves disk access. If data is not distributed across multiple disks, using PEO will cause I/O bottlenecks. Using parallel operations in small tables or very fast queries reduces performance. When the degree of

User_xxx all_xxx dba_xxx -- the data dictionary stores Oracle system information. Analyze System user, table, and index information --------------------------------- select sum (bytes)/(1024*1024) as "size (m)" from user_segments where segment_name =