Oracle

Before importing and exporting data, it is customary to check to see if our own machine can connect to a remote Oracle host, and the detection method is tnsping service_name. My machine is as follows:c:\users\zx>tnsping ORCLHost: lenovo-pc, service

Each database provides a schema for its own data dictionary, albeit in a different form, but with the same purpose and function as in MySQL, where the data dictionary is represented in Information_schema, and SQL Server is shown in the SYS system

Guide ] Dual is a virtual table that makes up the syntax rules for SELECT, and Oracle guarantees that there will always be only one record in dual. We can use it to do a lot of things. 　 Dual is a

1. IntroductionWhen we are making queries, we often encounter requirements such as query-qualified rows or paging queries, MySQL can be completed using the limit clause, in the MSSQL can be done with the TOP clause, then in Oracle, how do we

Good food is not afraid of late--remember my Oracle database careerMy first job is in an ERP software company to do ERP software technical support, in the process of maintaining ERP software, I contacted the Oracle database, gradually have a strong

Write the name of the stored procedure directly in the what value in PL/sql + "semicolon";beginsys.dbms_job.submit (Job=: Job, what= 'Del_ky_items;', Next_date=To_date ('24-06-2015 16:30:00','dd-mm-yyyy Hh24:mi:ss'), Interval= 'trunc (Sysdate,"'mi"')

Before we discussed the "Linux Oracle 11g dataguard Physical standby configuration process,"But in the actual process will encounter different problems, first we discuss the Oracle Dataguard three modes,Maximum protection : The configuration of this

Oracle study--oracle 11gR2 RAC CRS startup failure (CRS-4000)System environment:Operating system: RedHat EL5Cluster:oracle 11gR2 GridOracle:oracle 11gR2The following error occurred while initiating a node CRS:[[email protected] ~]# crsctl start CRS

0. Common functionssubstr(str,start,length);//可以反向索引。length不指定就到结尾to_number(str);//str转numberselectto_char(sysdate,‘yyyy-mm-dd hh24:mi:ss‘) from dual;//日期转字符nvl(tt,0);//若是空值则为01. CursorsFor the processing of collection data, learn how to use

IMP-00019: Row rejected Due toORACLE Error12899IMP-00003: ORACLE Error12899Encounteredora-12899: Value too large for column"CRM". bk_ecs_order_info_00413 "." POSTSCRIPT "(Actual:895, Maximum:765) Import Log Report imp-00019: Due to ORACLE

Oracle study--oracle 11gR2 RAC CRS startup failureSystem environment:Operating system: RedHat EL5Cluster:oracle 11gR2 GridOracle:oracle 11gR2In a RAC environment, one of the nodes CRSD the process failed to start:[[email protected] ~]$ CRSCTL Check

Oracle Learning Starter Series VIINetwork Management and ConfigurationWe learned about patterns and users, including pattern definitions and the role of patterns. In this article, I look at the network management and configuration in the Oracle

Impdp/expdp To create a logical directory, the command does not create a real directory in the operating system, preferably created by an administrator such as system.Create directory Dpdata as '/opt ';Second, view the Management Manager directory

If the Oracle database Time field is set to "number" type, the query time column will be displayed as a numeric value, such as "1241450728000" style, not readable, and if "2009/5/4 15:25:28 "The style update time will prompt" Ora-01722:invalid

--virtualbox UUID issues for Oracle applicationsSystem environment:Operating system: MAC OS 10.10.3Application software: VirtualBoxFault:When you use a previously installed VirtualBox virtual machine, you are prompted to "UUID already exists

Oracle configures SQL database Problems and Solutions in OneMap, oracleonemap Error ORA-00900: Invalid SQL statement, error: ORA--00942: Table or view does not exist after clicking OK Analysis: prompt is a printing function in Oracle. If you

Data cleansing Note: sorts strings to dates (A Date Field is processed in multiple formats) Background] When cleaning data, it is found that there are three types of data formats in a certain time field of the source system. It is suspected that

How to create an auto-increment field in a table in OracleThis method uses SEQUENCE (SEQUENCE). For example, the structure of table temp_test is: create table TEMP_TEST.(Id number,Nm varchar (10 ),Primary key (id) // id is the primary key. The

ORACLE 11g R2 database installation hardware environment requirements, 11gr2 Physical memory requirements: Minimum 1 GB, minimum 2 GB for windows7, windows8, and windows8.1. Virtual Memory (or paging space) capacity requirements:  

Development and history of databases in oracle learning getting started Series   Oracle learning starter Series Database development and history   This oracle learning getting started series is based on some of my work notes, projects to recall and