Oracle

 1. Previous section ReviewIntroduction of 2.pl/sqlThe foundation of 3.pl/sqlUnderstanding Oracle's PL/SQL conceptsMaster PL/SQL Programming techniques (including writing processes, functions, triggers, packages ...) ）What is PL/SQL?PL/SQL

1. Standard Insert-single row insertSyntax: INSERT into table [(Column1,column2,...)]   VALUE (value1,value2,...)    Example: INSERT into DEP (Dep_id,dep_name) VALUES (1, ' technical Department '); Note: Only one piece of data can be inserted using

for DBA , the database Job again familiar, because often to the database automatically execute some scripts, or do database backup, or do data extraction, or do database performance optimization, including rebuilding indexes and so on. However,the

When configuring Oralce client or server side problems, consider the following steps:1 Check the following files:Client side:D:\app\Administrator\product\11.2.0\client_3\network\adminListener.oraTnsnames.oraServer side:D:\app\Administrator\product\11

Instructions for using Oracle function ListaggAt work, customers often come up with the requirement that they want to enumerate the dates one by one in a summary merge., the original data is this:Customers want to be able to achieve such a summary

1. Install the Linux system C3 on a bare metal and prepare it to join the C1,C2 two-node RAC environmentTo have two NICs eth0,eth1Slightly2. Adjust/etc/hosts fileTurn three nodes into the

Materialized view is a more characteristic of Oracle, since Oracle9i, the application is very extensive, unlike MySQL, does not support the native materialized view, with the help of flexviews to achieve. What is the use of materialized views? To

Action blob whether this field produces a lot of redo, the answer is No. To do an experiment, the test database version number is 11.2.0.1.0:--Create a table for testingCREATE TABLE Test_blob(ID number,Tupian blob);Import

Public database link Dblink_wzgtams CONNECT to Wzgtams identified by Wzgtamsusing' (DESCRIPTION = = 192.168. 11.112 1521 ))))) (= = orcl11g)= dedicated))) ' ;Next, create a simple query validation effectSelect from

From me Oracle Latest SQL Recall Walkthrough 11 blog post http://blog.csdn.net/luozhonghua2014/article/details/45729669 Just re-publish once, is to extract experience, so that we can find a solution --------Modify the field type of the

1 IndexThe goal is to improve the speed of the query, when the user is not satisfied with the query speed and needs to adjust the performance of the database, the priority is to establish an index.The concept of indexes in a database is very similar

RAC on windows:oracle Grid Infrastructure Install or Upgrade fails with Error INS-20802 if Microsoft WMI Service is D Isabled (document ID 1641356.1)pplies to:Oracle Database-standard edition-version 11.2.0.2 and laterinformation in this document

Analysis:The first thing to do is to have an array type before you can define an array variable, so write PL/SQL as follows:Declare --defines an array type a_type is table of number; A a_type: = A_type (); Begin A.extend (3); A (1): = 1; A (2):

1. Open SQL Plus2. Log on using the system3. Use Select sys_context ('USERENV ', 'con_name ') from dual; See if the current user is a CDB user or a PDB user4. Use alter pluggable database PDBORCL Open, open pdb mode 5. Use Alter session set

The structure of the data dictionary includes: – Basic table: Describes database information and can only be modified by the database server – User table: User-defined table Data dictionary Naming conventions

Summary record stored procedure syntax and how Java programs are invokedA stored procedureFirst, we build a simple table to test the stored procedureCreate TableXuesheng (IDinteger, xing_mingvarchar2( -), Yu_wen Number, Shu_xue Number);Insert

Using JDBC to connect to the database, you need to load the Oracle JDBC driver and reference a Ojdbc5.jar library. Examples of concatenated strings:Drivermanager.getconnection ("Jdbc:oracle:thin: @localhost: 1521: database ", " login name ", "

Data cleansing Note: String-to-date: Timestamp-caused problems Background] During data extraction, the source "time significance" field data is in "timestamp format" and the field type is string type. However, the target end requires that the data

The string in oracleerror quotation marks is not properly ended.ERROR:ORA-01756: the string in the quotation marks does not end properlySelect distinct. jno from Rt as a where not exists (select pno from St as B WHERE NOT EXISTS (SELECT JNO, PNO

Oracle shrinktable shrink table Use Cases There is a serious shortage of External table space in the site, and the customer does not want to resize it. To clean up some data, it is a large field blob. the tablespace is 1 TB and 0.99 TB has been used.