Oracle

Select X.ksppinm Name, Y.KSPPSTVL value, y.ksppstdf IsDefault, decode (Bitand (Y.KSPPSTVF, 7), 1, ' MODIFIED ', 4, ' System_mod ', ' false ') Ismod, decode

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

Oracle OCM Oracle Certified Master  corresponding Certificate  Oracle Certified Master-OCM (Oracle Certified Master)      Certification Prerequisites  to obtain the OCM certification, OCM certification is required on the basis of the OCP

A synonym is a database object that is an alias defined for a database object , and the primary purpose of using synonyms is to simplify the writing of SQL statements .The concept and type of synonymsSynonyms can be used to define an alias for an

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

1.sysdate changed to Sysdate (), or Now ();2.NVL (EXPR1,EXPR2) to Ifnull (EXPR1,EXPR2)NVL2 (EXPR1,EXPR2,EXPR3) changed to IF (EXPR1,EXPR2,EXPR3);3.to_date (' 19000101000000 ', ' Yyyymmddhh24miss ') changed to select Str_to_date (' 1900-01-01 00:00:00

Create or Replace function f_split_condition (start_string VARCHAR2, V_flag VARCHAR2)/*** Replace the given START_STRINGN string with a comma-delimited string by V_flag* For example: 12-34-56 replaced with ' 12 ', ' 34 ', ' 56 '* Use loop Loop to

Oracle Single data file expands beyond 32GThe tablespace data file capacity is related to the Db_block_size setting, which is specified when the DB instance is created. The Db_block_size parameter can be set to 4K, 8K, 16K, 32K, 64K, and so on,

Recently, the Company development Environment Database server is very unstable, often not connected to the development of a great impact, so you want to back up the database to the local.Since you have been working with the Navicat database, share

Oracle Learning Series 3************************************************************************************ Multi-table query: 1, SQL1999 syntax support for multi-table queries 2, the use of grouping statistics and statistical functions 3,

package cn.com.login.dao;import java.sql.connection;import java.sql.drivermanager;import  java.sql.preparedstatement;import java.sql.resultset;public class logindao {     public string getusername (String usercode) {    connection 

First, create a userOverview: In Oracle, to create a new user using the Create USER statement, you typically have DBA (database administrator) permissions to use.Create user username identified by password;Note: Oracle has a problem, the password

A function that converts a date into characters:To_char (Date[,fmt[,params])Default format: DD-MON-RRParameter description:Date: Dates that will be loadedFMT: Format for swappingParams: The language of the date (can not be written)Example:Sql>

--Create Jobbegin Dbms_scheduler. Create_job ( job_name = ' apicall_log_interface_job ', job_type = ' stored_procedure ', job_action = > ' Apicall_log_interface_clean ', start_date = to_date (' 2016/4/23 1:00:00 ', '

Query and delete duplicate records of SQL statement 1, find redundant records in the table, duplicate records are based on a single field (ID) to determine the select * from table where Id in (the Select ID from table group Byid having count (ID) > 1

OracleDatabaseStartupand theShutdownWayTo start and close a database, you must have aOracleadministrator rights The user logs in, usuallySYSDBAPermission User Login. Generally we useINTERNALuser to start and close the database (INTERNALthe user is

Understanding the PGAPGA (Program Grlobal areas or process global area) refers to the private memory space of the service process, including the service process global variables, data structure and control information, such as cursors for the

I wrote a data synchronization method, data synchronization between two databases, you can call the stored procedures, add jobs to implement timed synchronization data.CREATE OR REPLACE PROCEDURE Data_sync_common (tableName in varchar2) is V_sql

Call the stored procedure of Oracle with NHibernate, nhibernateoracleSummaryNHibernate2.1.1 can finally call the stored procedure of Oracle, but you must use nhib.pdf. driver. oracleDataClientDriver Driver (Oracle. dataAccess. dll), but this will

Develop Oracle database-oriented applications in. NET,. netoracle In fact, this is not a new topic. However, many projects have encountered various problems when you access the Oracle database. The most basic problem is to install various clients on