Oracle

Beginners SSH Framework, in the online search for resources for reference study, found that in addition to the learning of MySQL, most also use Oracle. In order to better use the database in the future, specifically on the Internet to find some

Oracle:1. Get the current date of the year, month, day, time, minute, secondSelectTo_char (Sysdate,'yyyy') asNowyear fromDual//get the year of the time 　　 SelectTo_char (Sysdate,'mm') asNowmonth fromDual//get the month of the time 　　 SelectTo_char

Backup:Defined:The process of copying a database to a dump device.Dump device:The tape or disk where the database copy is placed.Backup of the original database:A copy of the database stored in a dump device.Classification:Physical and logical

1: After a few days of tossing, and finally Oracle installation success, create users, authorization and so on, then settle down learning Oracle;Install the Plsql GUI and after the Chinese (the process of Baidu, Baidu more and more), login graphical

MyBatis BULK INSERT requires a foreach element. The foreach element has the following main properties:(1) Item: the alias at which each element in the collection iterates.(2) Index: Specifies a name that represents the position of each iteration

☆dba_ opening .....Dba_users Database user InformationDba_segments Table Segment InformationDba_extents Data Area InformationDba_objects Database object InformationDba_tablespaces database table Space informationDba_data_files Data File setup

I. Oracle basic data type 1, character data type Char: stores a fixed-length string that, if not specified, has a default of 1 bytes, and if the length of the data does not reach the specified length, the space is padded to reach the

Create a new temporary tablespace Tmpa Create temporary tablespace tempa tempfile '/oracle/tmp/tempa01.dbf ' SIZE 8192M reuse autoextend on NEXT 1024K MAXSIZE UNLIMITED;2. Specify the default temporal tablespace as TmpaALTER DATABASE default

Oracle provides a sequence object that provides self-growing serial numbers from the system, typically used to generate the self-growing primary key or ordinal of a database data record.Here are some common operations on sequence generation,

1.ASCII returns the decimal number corresponding to the specified character;Sql> Select ASCII (' a ') a,ascii (' A ') a,ascii (' 0 ') zero,ascii (') space from dual;A A ZERO SPACE--------- --------- --------- ---------65 97 48 322.CHR gives an

The Oracle database has three standard backup methods, namely export/import (EXP/IMP), hot backup and cold standbyReport Exporting a spare is a logical backup, and cold and hot backups are physical backups.First, export / import

Do not know what to do, the data sheet locked, unable to update.Baidu has a variety of methods, summarized as follows.Check the locked table (two sentences are available):SELECT * from v$session T1, V$locked_object T2 where t1.sid=t2.

System permissionsSystem permissions refer to whether the authorized user can connect to the database and what system operations can be performed in the database.System permissions are the right to perform some kind of operation at a system level in

I. Stored procedures and FunctionsStored procedures: Encapsulation of a moduleFunctions: Functions are almost the same as stored proceduresDifference:function must return a value via the return keywordStored procedures:Return value is not

Problem Description:A cell, need to follow the plot, Wendy, unit number, room number, but sort by address description, because the string contains a number, so the result is as follows,Building 1th is supposed to be building 2nd, but the search

1 --Querying table Information2Xxx_tables--contains basic descriptive and statistical information for a table3Xxx_tab_columns--contains descriptive and statistical information for the columns in the table4Xxx_all_tables--contains all the

1, Oracle is a large database and MySQL is a small and medium-sized database, MySQL is open source and Oracle price is very high.2, Oracle Support large concurrency, large traffic.3, the space used to install the difference is also very large, MySQL

What are the available commands for 1> Oradebug? Log into the database as SYSDBA, through Oradebug help can see oradebug commonly used commandsSqlplus/as SYSDBAOradebug Help 2> Tracking Current session informationOradebug Setmypid--Track current

DECLARETYPE cst_table_list is Table of VARCHAR2 (40); TYPE Cst_list is TABLE of VARCHAR2 (40);TYPE Name_list is TABLE of VARCHAR2 (40); TYPE Type_list is TABLE of VARCHAR2 (20);Cst_tab_name cst_table_list:=cst_table_list (); Cst_name

Simply record the process: (in fact, the guidance of the help page is very simple and clear) Download installation files OracleXEUniv.exe, run directly; Most of the steps go directly to the boot, note where the password is required, this