Oracle

Millisecond conversion to date 1 2 3 SELECT To_char (1406538765000/1000 * *) + to_date (' 1970-01-01 08:00:00 ', ' yyyy-mm-dd HH:MI:SS '), ' Yyyy-mm-dd HH24:MI:SS ') as CDATE from DUAL; Date conversion milliseconds

Oracle unlocks the Scott/tiger user 1, verify the current system for Scott user status: SELECT * from Dba_users where upper (username) = ' SCOTT '; Account_status:expired & LOCKED 2. Release the lock for Scott User: Conn Sys/bitservice@ttonline

Index uniqueness Scan (Index unique SCAN) (scan for UNIQUE index) the Peso range Scan (index unique SCAN) requires a minimum of 1 logical reads, because the index unique row scan is clear that only a maximum row of data is returned. An index-range

Data Guard offers two main services:1 Redo Transport service: The Primay end of the redo log transmission to one or more standby destinations.2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby

Oracle does not have such features as the self-adding fields, but it can be implemented by triggers (trigger) and sequences (sequence). First build a test table: CREATE TABLE Userlogin( ID Number (6) is not NULL, Name VARCHAR2 NOT NULL primary

When the index is too fragmented, it affects the speed at which the query is executed, which affects our productivity. The most advantageous measure at this time is to rebuild the index. This article mainly introduces the process of examining index

[Oracle@zhongwc1 ~]$ Sqlplus/as SYSDBA Sql*plus:release 11.2.0.3.0 Production on Wed 23 17:02:01 2013 Copyright (c) 1982, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition release 11.2.0.3.0-64bit Production With

The steps are simple: Guan-> copy to target machine-> boot to mount State rename->open database Login to the source database host Create map directory 192.168.1.2oradata map to Z: Disk Check to see if the file is allowed to be written after

Oracle 11.2.0.1 logical Standby Library Environment setup After you create a physical standby library and create a physical fallback library, it's best to create your own spfile Stop redo application on physical standby ALTER DATABASE recover

Oracle and Firewall settings To access the Windows Oracle database behind the firewall, it is not possible to simply open the fixed TCP port. The root cause of this problem is the BT design of the Windows Oracle Database (Unix/linux is not the

Oracle Database backup: --Keep the backup record of the most recent week; = = = Text: = = Start ============== Echo Set backup file Folder ... Set "Tbuf=e:cwaybackup" echo Sets the backup file name (named after the day of the week, that is,

Oracle Chapter 5th: Managing Oracle Routines Returning to course list purpose This chapter focuses on the tasks involved in managing routines. In this chapter, you will learn how to use the Properties page in the Instance area of the Administration

oracle| Data | After the database is installed on the Oracle database, when we visit Port 8080, a xdb window pops up asking for a username and password. This will conflict with some of our local applications that use the port, such as Tomcat, JBoss,

Client|oracle Client-side approach to installing Oracle Cantonese Zhongshan Thank you macro 2001/04/03 Objective: I've seen a lot of people on the Internet asking the client to connect a PB program to an Oracle library by not installing

Oracle|window Oracle installed on disk D: 1. Re-establish the Pl/sql package Dbms_logmnr_d Open D:\oracle\ora81\rdbms\admin\dbmslmd.sql Find "TYPE Col_desc_array is Varray (513) of col_description;" To "TYPE Col_desc_array is Varray (1023) of

asp.net|oracle| Access | solve | data | database | problem ProblemAfter installing the Asp.net,oracle9i client, you receive the following information when you use System.Data.OracleClient to access the Oracle database System.Data.OracleClient

Let's take a look at Oracle's encryption of table-sensitive fields through the Dbms_crypto package, a friend who needs to know. In the security more and more attention to the near body, we often need to a table in the Database sensitive column data (

First, manually delete the file system database 1. Stop Listening and OEM The code is as follows: $ lsnrctl Stop Listener_name $ emctl Stop Dbconsole 2. Access to data files, log files and control documents related information, including

If you manage some application projects under the Oracle database that have a large number of modifications to delete operations, data indexing needs to be periodically rebuilt. It can not only improve query performance, but also increase the

Today I learned about the latest popular Ruby on Rails, feeling like a code generator linking OracleDatabase, I searched for half a day of information. Finally found a way, ^______^. 1. Installation drive http://rubyforge.org/projects/ruby-oci8/