Before feeling installed 11g feel quite casual, today re-Ann once, out several times wrong, very uncomfortable ah, all the process recorded.After downloading the two compressed files into a folder, click Setup.exe to start the installation, if your
Query All Users: SELECT * from all_users; register monitoring manually: Alter system register;oracle password expiration setting 1, query select * from Dba_profiles where profile= ' Default ' and Resource_name= ' password_life_time '; 2, lifting
Oracle row to column first look at the source data:Method One: Wm_concat group By this method is not a problem .SELECT code_ts, 1 ' : ' | | ELEMENT) ELEMENT where code_ts='020745' Group by Code_ts;The results obtained:You may
There are 4 types of Oracle integrity constraints: disable novalidateenable novalidatedisable VALIDATEenable VALIDATE Disable novalidate does not validate both the original and the new data. For read-only tables for improved performance. This state
Written before the installation.There may be a lot of novices who are very afraid of installing large software because some of the errors in the installation process make them headache. Below I will write a tutorial, hope to be helpful to everyone,
CREATE table Spaces First in Plsql developer if you have created tablespaces and users, you need to delete/*--Deleting a table spaceDrop tablespace jhpt including contents and datafiles;--Delete UserDrop user JHPT cascade;*/Start execution--Create
Demand:There is a table in the project that probably has 7000多万条 data, causing the tablespace to be full and some data to be cleaned up to 30 million.2 B Procedure:Delete from table_name where ID > ' 40000000 ';Note: SELECT COUNT (1) from table_name
1, version-based redefinition function (only R2 version)2. Force option for CREATE TYPE (only R2 version)3. Function Result Cache4. Continue statement: Exit the current iteration and continue looping the next iteration5. A sequence in a PL/SQL
1. Solve the ORA-12505 problem of oracle11gStart the Oraclehome92tnslistener service and start oracleservicexxxx,xxxx is your database SID. (Sid_desc =(Global_dbname = ORCL)(Oracle_home = D:\Oracle\product\11.2.0\dbhome_1)(Sid_name =
Prompt for "record locked by another user" workaround when deleting data in Oracle data:1, check the database lock, the source and type of diagnostic lock:Select Object_id,session_id,locked_mode from V$locked_object;or use the following command:
The first method:Select substr (t,1,instr (t, ', ', 1)-1) from (Select Substr (S,instr (S, ', ', 1,rownum) +1) | | ', ' as t,rownum as D, InStr (S, ', ', 1,rownum) +1 from (Select ', Tt,aa,bb ' as s from dualConnect by InStr (S, ', ', ' 1 ', rownum)
Modify the character set of the Oracle database (UTF8 → ZHS16GBK)
Modify the character set of the Oracle database (UTF8 → ZHS16GBK)
1. C: \ Users \ Administrator> sqlplus/nolog
2. Log On As sysdba
SQL> conn sys/root as sysdba
3. Call the
Oracle query fields by Field Type
Sometimes we need to query specific field information in oracle through the field name, field type, field length, field comment, table name. For example, my colleague asked me yesterday if blob type is used in our
Oracle Database creation process
Since there is already a database instance in the current environment, this does not affect the creation of a new instance sun
Current System instance
[oracle@DBA2 dbs]$ env |grep ORACLEORACLE_SID=orcl1ORACLE_BASE=/u/
How does a function return a result set in Oracle?
In Oracle, function return result sets are sometimes used. The following is a demo:
create or replace type t_test as object(id integer,create_time date,object_name varchar2(60));create or replace
ORACLE 11G traverses the cursor in the stored procedure and calls the job task for scheduled execution.
Cursor traversal and scheduled job execution in ORACLE stored procedures1. First, use the For Loop
For Loop is a simple and practical
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service