Oracle Import CSV file:1, build the corresponding tables and fields;2. Create a new Test.ctl file and write it with Notepad editor:Load'e:\TB_KC_SERV.csv' --Modify the corresponding file path into table by ',' by ' " '
left join (left join) ---Returns records that all records in the left table and the condition fields in the right table are equal. right join (right join) ---Returns all records in the right table and records with the same junction fields in
Oracle triggers can be divided into DML triggers, instead of triggers, and system triggers.
Only DML update supports column-level triggers. ,
The format is as follows:
Create or replace trigger t_name
Before update of column1, colum2 on table
--- Create a tablespace in Oracle ---Create tablespace ssitablespaceDatafile'/Opt/Oracle/DB/oradata/iptvrpt/lv_ssitablespace1tbs' size 20 m autoextend on next 10 m maxsize 100 mExtent management local segment space management auto;
--- Create a
Order by is used to sort the select results. It is very simple, but let's summarize it.
1. sort by column name. The default value is ascending.
Single Column Ascending Order: Select from order by ;
Single Column descending order: Select from
◆ Oracle query user tablespace: Select * From user_all_tables
◆ Oracle queries all functions and stored procedures: Select * From user_source
◆ Query all oracle users: Select * From all_users.select * From dba_users
◆ Oracle view current user
Open Control Panel --> Administrative Tools --> Local Security Policy result my computer is like this:
Run the following command: regsvr32 gpedit. dll wsecedit. dll.
Copy framedyn. DLL to C:/Windows/system32/WBEM
Enter regsvr32 gpedit. dll
Start with DBA .....
Dba_users database user information
Dba_segments table segment information
Dba_extents data zone information
Dba_objects database object information
Dba_tablespaces database tablespace Information
Dba_daTa_filesData File
Oracle Database hang I. Possible phenomena in database hang
1. The most intuitive thing is that most of your business operations, for example, a query takes a long time, or no results are returned at all. This is different from the simple lock table.
Query constraint type
Select distinct constraint_type fromdba_constraints;
Type Code
Type description
Acts on Level
C
Check on a table
Column
O
Read only on a view
Object
P
Primary Key
Flashback transaction Query
Flashback transaction query is also implemented using undo information. This function allows you to view all the changes in the execution of a transaction. You need to access the flashback_transaction_query view. The Xid
I. Why partition?
Oracle big tables have the following manageability and performance constraints:
1. Table availability
A. The damage to the large table read disk is more fragile.
B. It usually takes several hours or even longer to restore a
I. test environment:Vmoel5u4: IP: 192.168.92.100OS: Linux version 2.6.18-164. EL5DB: Oracle 10g Enterprise Edition Release 10.2.0.1.0;
Even machine: IP: 192.168.92.200OS: Linux version 2.6.18-164. EL5DB: Oracle 10g Enterprise Edition Release 10.2.0.1
As follows:
Tip: commit is required after execution. Of course, you do not need to execute another statement update. Otherwise, you may find that the update is useless.
1. log on to the database as a DBA
Connect sys/change_on_install @ hhxx as
The Oracle parser processes the table names in the from clause in the order from right to left. The table written in the from clause (basic table driving table) will be processed first, when the from clause contains multiple tables, You must select
Today, when I sorted out the project implementation documents that I used to work with an older generation, I found a SQL statement that is quite cool. I 'd like to share it with you:
-- The structure of the sample table is identical to that of the
Operations in relational algebra can be divided into two types:
(1): traditional set operations. And, difference, intersection, Cartesian product.
(2) expanded relational operations: projection (vertical separation of Relational Tables), selection
From: http://blog.csdn.net/seventh1984/archive/2009/02/26/3940168.aspx
I personally think this function is actually very useful. sys_connect_by_path (field name, The Connection Symbol between two fields). Note that the Connection Symbol here
Even if BW is not available, Bo can directly connect to the ECC database to generate reports. For webi, you can use universe-> data base, xcelsius, and more methods, including liveoffice, qaas, and Web Service. today we will talk about how universe
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