Oracle

Thanks to the following author's share: http://blog.csdn.net/wildboy2001/article/details/7271877http://blog.csdn.net/lsyuan1989/article/details/50418665There are two ways to import and export a database: import: Imp IMPDP "Data Pump"Export: Exp

In Oracle, you can use the drop, delete, and truncate three commands to delete a table from a database.1. Delete and truncate both delete the contents of the table and cannot delete the structure of the table, while the drop is to delete the

Establish stored procedures on ORACLE server that can be called by multiple applications, can pass parameters to stored procedures, and can be passed back to stored proceduresTo create a stored procedure syntax:CREATE [OR REPLACE] PROCEDURE

1. Create TABLE spaces:begindeclarecnt integer: = 0; BEGIN Select 1 to CNT from dual where exists (SELECT * from user_tablespaces where tablespace_name = UPPER (TRIM (' TEST ') ))); IF cnt! = 0 Then DECLARE s VARCHAR2 (500);

First, database security: System security, data securitySystem permissions: Permissions for the databaseObject permissions: Permissions to manipulate database objectsScenario: A set of database objects, such as tables, views, sequencesIi. Database

1. Oracle instance starts, stopsSql>shutdown immediate; Oracle Stopsql>startup; Oracle Startup2, ORACLE monitoring start and stopLsnrctl Start monitoring BootLSNRCT Stop Monitoring stopsLSNRCTL Status Monitor state3. View Orcle instance and database

Stored Procedure Basic syntaxHttp://www.cnblogs.com/hero4china/articles/base_rule_oracle_procedure.htmlBasic notation for Stored proceduresHttp://www.linuxidc.com/Linux/2013-11/93196.htmA simple example of a stored

Javaweb projects are slightly different from plain Java projects when connecting to an Oracle database.Normal Java project will ojdbc.jar build path directly;The Javaweb project may not work and needs to be set up again:Right-click on the project

NVL () function in OracleHow Oracle's NVL function is usedThe total value of a field is obtained by querying, assuming that the value bit null will give a preset default valueSelect NVL (SUM (T.DWXHL), 1) from Tb_jhde t where zydm=-1Here the Nvl

In the recent inspection of a unit system, found that the database has a number of instances, directly to one of the instances of the query, the display is missingDefeat. After discovering that it needs to be specified, modify the environment

For computers with limited configuration, it is not necessary to use Plsql to install Oracle.First, download a instantclient (a lighter-weight customer package provided by Oracle)It is said that Plsql does not support 64-bit instantclient.Attached

Sometimes we need to go to the customer site to do security, occasionally need to stop the database cluster, and then stop. Usually we take a more secure approach than a brute force approach. Savage Way. #/u01/app/oracle/product/10.2.0/

Uninstall steps: 1. Stop all Oracle Services2. Running Oracle Universal Installer uninstalling Oracle3. Modify the registry to remove Oracle-related information? Oracle software has key-value hkey_local_machine\software\oracle? Oracle Service

implementing a row merge using Wmsys.wm_concatIn Oracle, multiple rows of data from one field are converted to a comma-styled line. Can be achieved using function Wmsys.wm_concat.This one in the previous articleOracle Built-in function

Basic syntax for building a table:CREATE TABLE table_name (Field1 datatype,Field1 datatype,Field1 datatype,...)NOTE : table_name table name; field specifies the column name (field name); datatype specifies the column type (field data type)Note: When

The time partition can be partitioned according to the day of the month and the day, generally according to the daily or monthly partition is sufficient, here according to the day partitionDemo is as followsCREATE TABLE Apdemo (OID number generated

Recently participated in several interviews. Summarize the most frequently asked questions about the competition for Oracle development positions:1, delete and truncate difference? 1) Truncate is a DDL statement, and delete is a DML statement;2)

This is my third blog ~Today, we mainly talk about the impact of database commit on execution efficiency.Congo: When you write 800W of data, the period of commit and final commit time difference of one hours. Specific is not so I do not research,

Authorization principle: Principle of least privilegeEmpower users with roles to simplify administrator administrative privilegesBusiness account creation:To create a specific table space:CREATE tablespace TBS1 datafile '/U01/APP/ORACLE/ORADATA/PROD4

Select substr (object_name,1,30), substr (os_user_name,1,20) from v$locked_object,user_objectswhere v$locked_object.object_id = user_objects.object_idSelect B.owner,b.object_name,a.session_id,a.locked_modeFrom V$locked_object a,dba_objects bwhere