Oracle

What happens if I forget my Oracle user name password?Forgot the user name and password set at installation? Check the information on the Internet, finally solved!Method One:First enter the Sqlplus: There are two ways to enter, one is through the

--1. Creating Oracle vcenter tablespace and data filesCREATE tablespace "VCENTER" DataFile ' $PATH/vcenter. DBF ' SIZE 1G autoextend onNEXT 10M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;--2. Creating Oracle

1. Installation environment ... 42. Installation steps ... 52.1. Check the hardware environment ... 52.2. Check the SOFTWARE Environment ... 53. Installation Standard ... 73.1. Kernel parameters ... 73.2. Set up System user groups, configure user

Online too many e-mail storage process, I will not forward, to get a simple example;Create or Replace procedure Send_mail (Mail_body varchar2) is Smtp_conn utl_smtp.connection; User_name VARCHAR2: = Utl_raw.cast_to_varchar2 (Utl_encode.base64_encode

PL/SQL Connect Oracle Database 1, IntroductionUse PL/SQL to connect to a remote Oracle database without installing an Oracle database.2, the specific steps:A) Install PL/SQL, install the Oracle client based on your operating system (not related to

http://blog.163.com/magicc_love/blog/static/185853662201210194592757/SELECT * from v$version; or select banner from sys.v_$version;  results as follows:    banner 1 Oracle Database 10g Ente Rprise Edition Release 10.2.0.1.0-prod 2 PL/SQL Release 10.2

The most important syntax structure for Oracle tree queries is: Select...start with...connect by...prior, which allows you to display the relationships in a table as a tree.1. Create test tables and data:--Create a test tableCREATE TABLE Yag_tree (T_

Oracle Rman Backup Example: Solaris + Oracle 11.2.0.3SHELL:CSH Backup strategy: Sunday Level 0 Backup, Monday ~ Weekly level 61 backup, Backup archive log every 6 hours, clean up the History folder every day.--Level 0 backup script:#!/bin/csh#db0

The Reset method is as follows: Open the cmd command prompt and enter the following command to reset:Input Sqlplus/nolog, enterSql> Conn/as SYSDBAis connected;Sql>alter user system identified by "123456"; ---(123456 is the reset password)Sql>alter

Count Group function: (filter out fields that are empty)Select count (Address), COUNT (*) from B_userMax () Avg () min (), SUM ()Select SUM (age), Max (age), min (age), Avg (NVL (age,0)) from B_user1 260 70) 10 37.1428571428571groupby: If the field

Case statementCase SelectorWhen value1 and then action1;When value2 and then Action2;When Value3 and then Action3;.....ELSE Actionn;END case;Case expressionDECLARETemp VARCHAR2 (10);V_num number;BEGINV_num: = &i;Temp: = Case V_numWhen 0 Then ' Zero '

Today, when you write a simple SQL statement and execute it, it throws an error message as shown!Well, the exception information is obvious, the length of the identifier in the SQL statement is too long, short should be no problem, I looked at my

Development often use ORALCE database, the use may encounter various types of error prompts, such as: Ora-00933:sql command did not end correctly, ORA-009242 and so on, for this record accumulation for their own is still very helpful, today on the

GG Configuring Oracle Synchronization to SQL ServerPrepare a test table for the source end target side. Oracle Source: Drop table Ggmgr.t1;create table ggmgr.t1 (id int primary key,name varchar2 (), time date);SQL Server target end: BEGIN

In an Oracle database, creating an index is relatively straightforward. However, it is more difficult to create indexes reasonably. The author believes that when creating an index to do three appropriate, that is, on the appropriate table, the

Meaning explanation:Decode (condition, value 1, return value 1, value 2, return value 2,... Value N, return value N, default value)The function has the following meanings:IF condition = value 1 ThenRETURN (translation value 1)elsif condition = value

Example of mutual conversion between ORACLE milliseconds and dates, and oracle mutual conversion Convert millisecond to date SELECT TO_CHAR(1406538765000 / (1000 * 60 * 60 * 24) + TO_DATE('1970-01-01 08:00:00', 'YYYY-MM-DD HH:MI:SS'), 'YYYY-MM-DD HH2

Detailed example of Rownum paging in Oracle, oraclerownum In MySQL, we usually use limit to retrieve data sets by page. in Oracle databases, there is no convenient way to achieve paging like limit, therefore, we usually perform paging directly in

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up oracle data. The exp command can export data from the remote database server to the local dmp file, and the imp command can import the dmp file from the local to

Statement: This is not a technical document. Since I have learned a few tricks about oracle, I cannot afford to sell it to anyone. Just after a meal, I joined several friends in the library. It is just a bit humorous and it can also be used to make