Oracle

This article is divided into two parts, 1, the operation of the database through SQL statements. 2. Working with databases through DDLAn ODBC-based connection to Oracle1) Control Panel, management tool->ODBC data source, add Oracle Data source in

Maven adds Oracle JDBC dependencyBecause of Oracle licensing issues, MAVEN does not provide Oracle JDBC driver, which must be manually added to the local warehouse in order to apply the Oracle JDBC driver in the MAVEN project.First, you need to

drop table if exists sequence;CREATE TABLE Sequence (Seq_name VARCHAR () not NULL,Current_val INT not NULL,Increment_val INT not NULL DEFAULT 1,PRIMARY KEY (Seq_name));Drop function if exists currval;Create function Currval (V_seq_name VARCHAR

1. Open powerdesigner--file--reverse engineer--database2. Select the database version you want to connect to, using Oracle version 11g.3. Click the red area to select the data source4. Select Modify5. Fill in your database name, connection address,

The Recycle Bin, as its name implies, is the storage of deleted items. In principle, it is a data dictionary table that places the user's deletion (drop) out of the database object information. Objects that are deleted by the user are not deleted by

A lot of people must be like me. Due to work needs, the development environment needs to be foreign languageNext, I'll talk to you about my handling of Oracle garbled.My Windows environment is the processing order of Japanese1. Modifying environment

The password file belongs to the database partRole of the password file: DBA user authenticationDBA user when having sysdba and Sysoper permissionsBy defaultSYSDBA is sys, he has the most authority.Sysoper is the system.There are two ways to

How to jump out of loops in Oracle stored proceduresBlog Category: Oracle Oracle records the use of exit and returnExit to jump out of the loopLoopIF V_KBP is NULL thenEXIT;END IF;End Loop;Return jump out of stored procedureLoopIF V_KBP

-View all the responsibilities of EBS users:SELECT Frt.responsibility_name, Furg. End_dateFrom Fnd_user_resp_groups Furg,Fnd_responsibility FR,Fnd_responsibility_tl Frt,Fnd_user Fuwhere fu.user_name = ' &username 'and fu.user_id=furg.user_idand Furg.

I. Related content1. Master the start-up and stop of Oracle 10g related services.2. Master the use of tools such as database Configuration Assistant (DBA), Enterprise Manager (OEM), sql*plus, etc.3. Learn how to start and shut down the database

Oracle removes duplicate record statements  For example, there is now a table (table name: peosons) If you want to name, social Security number, address the three fields exactly the same record query select p1.*  from persons  p1,persons P2  where p1

Oracle Learning NotesSwapThe teacher said a lot, although it seems to be a lot of useless, but the teacher said carefully, we should take a serious look.The main content of this lesson is the working mechanism of hard disk, working principle,With

1. Installing ODACDetermine the ODAC version of the download according to your operating system x86,x64Http://www.oracle.com/technetwork/database/windows/downloads/utilsoft-087491.htmlDuring installation, be careful to configure the location and

SQL Server1 Creating a TriggerGobeginif (object_id (' wmy ', ' tr ') is not null) DROP trigger wmyend; Gocreate TRIGGER Wmyon studentinstead of Insertasbegin INSERT into Student (number,name) VALUES (1205, ' role 2 '); End;--begin and end are

Oracle 10g Advanced Replication instances (multi-agent replication)Objective:Configured three times, two is one way. The last time is finally two-way. Also a little bit of success in the joy. Joy? Joy does not. It's such a simple thing that I feel

About Oracle "ORA-12514 TNS Listener does not currently recognize request service in connection descriptor" errorReason:The listener server name is not specified in Listener.ora.Here's how to solve the idea:Try 1, start the database by restarting

First, the purpose:Profiles in an Oracle system can be used to limit the database resources that a user can use, creating a profile using the Create Profiles command, It is used to implement restricted use of database resources, and if the

Installing 32-bit and 64-bit Oracle clients first in many Oracle installation introductions, there are references to setting 2 points, one, E1, and environment variables. nls_lang=simplified Chinese_china.

1.spring Support for database accessWhen we develop a persistence layer, we face a variety of options, such as using JDBC, Hibernate, the Java Persistence API, or other persistence frameworks. Fortunately, Spring is able to support all of these

Today, I saw someone write a custom aggregation function, so mindedly want to understand, on the Internet to find information. Introduction to custom aggregate function custom aggregation function interfacesOracle provides a number of pre-defined