Oracle

--for the resulting UUID to conform to the RFC 4122 standard (http://tools.ietf.org/html/rfc4122), for example: A8f662b8-6e7a-13fe-e040-970a437c6bd7--functionCREATE OR REPLACEFUNCTION Get_uuidRETURN VARCHARIsGUID VARCHAR (50);BEGINGUID: = Lower

1.Oracle is the Oracle company, it should be considered a high level of the database;2. Occupation: DBA (Database administrator)3. Database classification://How to select a database: {1. Project size; 2. Cost; 3. Security}A: Small database: Access,

Source Address: Http://zhidao.baidu.com/link?url=mehN7bFY14DGH6DwhpbJnAbzb_ Fi3wbqn2-wqvinyyqhkfylzsfu7gqvjqgqopv07tcfiqgiotvsqff-m9d-mk Open cmd, input: Sqlplus/nolog INPUT: Conn username/[email protected] Database name And of

--New UserCreate UserExample identified by 123456;--Delete UserDrop Userexample;--Lock UserAlter Userexample account lock;--Unlocking UsersAlter Userexample account unlock;--Modify User PasswordAlter UserExample identified by 654321;--grant

Single-table operation!(The code can be replaced by hand, written down for memory)1. Create a tableCREATE TABLE Hkb_table_modify(NAME VARCHAR2 (6),Age VARCHAR2 (3),SEX VARCHAR2 (2))2. Modify the tableAdd field: Alter TABLE hkb_table_modify add

ORACLE11G has more than one installation disc:File name DescriptionP102025301120--linux-x86-64_1of7.zip Database installation mediaP102025301120--linux-x86-64_2of7.zip Database installation mediaP102025301120--linux-x86-64_3of7.zip Grid installation

At first, I thought I was going to unzip. Inadvertently see a blog, understand the meaning of the compressed package. Ha haORACLE11G has more than one installation disc: Description of File namep102025301120--linux-x86-64_1of7.zip Database

SELECT * from T_a A where A.begintime=to_date (' 2013-1-1 ', ' yyyy-mm-dd ');and theSELECT * from T_a A where To_char (a.begintime, ' yyyy-mm-dd ') = ' 2013-1-1 ';the query results are the same. the difference is that the processing steps of the

What is a view? ）1. A view is a database object, a virtual table that is exported from one or more data tables or views, and the data corresponding to the view is not really stored in the view, but is stored in the referenced data table, and the

the neglected Oracle User-owned groupChongqing days, Heat can't stand, still in the heat wave, a brother to call, tell a single instance database new Field operation, has been stuck there, do not go on. Because you are busy talking about things,

Assign the"Create Global Objects" User Right ToThe Non-administrator account.1.ClickStart,PointToPrograms,PointToAdministrative Tools, and ThenClick Local Security Policy.2.Expand Local Policies, and ThenClickUserRights Assignment.3.

1. Download the Bcpserver and open the virtual machine via VMware Workstation2, vim/usr/sbin/workstation.list Modify the configuration file, the corresponding IP and Mac bindings, this program can only write the first 90 IP3. Botang-create-dhcpconf

1: First the table in the database must be 2 of the tree structure:super_department_id For department_id The parent node number 3: The following statements are executed as a result:department_id = 88 records for all byte points and child

User, table space, table:A user typically gives a table space, and multiple users can manage a table space togetherA table space will have more than one tableFor control of permissions:You can add a table between the people menu table and the file

This post was last edited by Tsengyia on 2012-2-22 17:06Solve the problem of Chinese garbled when installing Oracle under LinuxOperating system: Red Hat Enterprise Linux 6.1Databases: Oracle Database 11g R2Method One: Evade the law, use English

--view (can view owner, object name, creation time, last modified time)SELECTT.object_name, t.created, T.last_ddl_time fromUser_objects TOrder byT.last_ddl_timedesc;SELECTT.owner, T.object_name, t.created, T.last_ddl_time fromall_objects

Use the Xshell tool.Log in as root:[Email protected] ~]#To view (Oracle related) process status:[[Email protected] ~]# PS Aux|grep OracleOr[Email protected] ~]# Ps-eaf | grep OracleKill Process:[email protected] ~]# kill-9 13118Log on as an Oracle

A colleague in the morning information how to get to the build table statement and is not with storage that kind of SQL.Oracle provides itself with a function dbms_metadata. GET_DDL, but the built-in statement contains properties for storage, table

First step: LoginAfter root login, switch to Oracle user, enterSu OracleStep Two: ConnectUnder Oracle user, enterSqlplus/nologStep Three: Use Administrator privilegesInputConnect/as SYSDBAFourth step: Start/Close ServiceInputStartupStartup

http://kely28.blog.51cto.com/665690/1412730http://kely28.blog.51cto.com/665690/1412737http://kely28.blog.51cto.com/665690/1412962http://kely28.blog.51cto.com/665690/1412965Http://www.ahlinux.com/oracle/17395.html1. Install dependent packagesYum