Oracle

Sysdate [function]: returns the current date. [Parameter]: No parameter, no brackets [Return]: Date [Example] select sysdate hz from dual; return: Last_day (d1) [function]: return the date of the last day of the month where the date d1 is located. [

Oracle backup is divided into two types: Logical backup: expdp/impdp is only used to store the exported data. Therefore, only the data saved during Backup can be recovered, Logical backup is suitable for backing up tables with few

1. Use SQL * PLUS to stop a databaseCopy codeThe Code is as follows:$ Sqlplus/nolog SQL> connect/as sysdba SQL> shutdown [immediate] SQL> exit 2. Stop ListenerCopy codeThe Code is as follows:$ Lsnrctl stop 3. Stop the HTTP serviceCopy codeThe Code

Today, I encountered a problem, which is easy to say, but it bothered me for half a day. After upgrading the database, a function can not run, in the background to observe its SQL, found that SQL contains a package can not be executed, error ora-009

This article will introduce you to some self-knowledge about tde in oracle. If you are interested in tde, please refer to this tutorial. Oracle's transparent data encryption is part of Oracle's Advanced Security Options and requires additional

In Oracle 10 Gb system management, there is an automatic SGA memory management ASMM ). This function is described as follows: To use automatic management, you need to set the parameters SGA_TARGET, STATISTICS_LEVEL = TYPICAL or ALL. Because the

I like the VB. net undo tablespace very much. In my work, I also like to sum up the experience and lessons on the VB. NET UNDO tablespace. Let's talk about this in detail. Create a VB. net undo tablespace. The VB. net undo tablespace is used to

A few days ago, Oracle Database not only acquired Sun, but the database giant also acquired Java. Larry Ellison, the chief character of Oracle, also considered JAVA as the most important technology in all Oracle acquisitions. But now the fate of

The following articles mainly describe the actual application of Process Memory in the Oracle storage structure. We all know the actual application processes of Oracle except for the SGA (System Global Area, the following three global zones are also

The following articles mainly introduce the example of Oracle Database DBA interview questions. This article describes the basic mode of Oracle Database DBA interview questions in a one-Answer manner, the following is an introduction to the related

The following articles mainly describe the actual Oracle optimization query operations. We first assume that LARGE_TABLE is a large table), and the username column does not have relevant indexes, what statements are used in actual operations? The

The following articles mainly explain the Oracle Raw type in detail. We first talk about the concept of RAW, which is similar to CHAR in that aspect, the declared method is RAW (L). It takes L as the length, and the relevant bytes as the unit. It

Many new users may not know how to query all tables and data in oracle. The following describes how to query all tables in oracle for your reference. SELECT t. data_type FROM user_tab_columns t Group by t. data_type; -- Created on 2010-8-2

The following describes how to rename an Oracle listener log file without renaming it. It is helpful for you to learn about the Oracle listener log file. Oracle listener log file (usually called listener. log) is a plain text file whose size keeps

Mongoisedb, an open-source database vendor, declared war on Oracle, the database market leader, based on a survey ". The survey shows that Oracle is not good for open source. The survey sample is from 600 people at the JavaOne conference. Sampling

Oracle Database FirewallA perimeter protection circle is built around the database to monitor various application activities in real time, allow normal application activities, and help prevent SQL injection attacks and unauthorized access to

Oracle DatabaseIt is widely used in various fields of society, especially in the Client/Server mode. However, application developers often encounter the problem that the performance of the entire system decreases significantly as the data volume

OracleDatabaseRman recoveryOfSystem tablespace recoveryIs what we will introduce in this article. The system tablespace stores the data dictionary information. When the database is in the open state and the data file corresponding to the system

Insert and display images in Oracle (BLOB type)Blob type for storing images in oracle First, create a database: -- Connect to the AdministratorConn sys/tbsoft as sysdba; -- Authorize scott user Grant create any directory to scott; -- Return to scott

  Lpad () function usage: The lpad function fills the string on the left with some specific characters. The syntax format is as follows: Lpad (string, n, [pad_string]) String: but a character or Parameter N: the length of the character, which is the