Oracle

Case... whenConditional Conversion Functions CaseWhen there are two forms of expression1 CaseVariable whenValue 1 ThenResults 1 whenValue 2 ThenResults 2Else 'other' End --else you can choose not toExample:SelectEname,job, ( CaseJob when 'MANAGER'

Why do you need flashback log and archive log when flashback?If the activity of the database is not very frequent, you can see that its flashback log is relatively small. So what is the way to flashback to the past?The schematic is as follows:12:50

1. Open Status renamingSYS@userdata>Select Tablespace_name,file#,File_name,v.status,v.enabledFrom Dba_data_files D,v$datafile Vwhere D.file_id=v.File#; Tablespace_namefile#file_nameSTATUS ENABLED-------------------- ---------- -----------------------

Usually we use EXPDP to derive sequence in two ways:Small batch:Include=synonym: "In (' AAA ', ' BBB ')----This does not enter the schema prefixSCHEMAS=LYCH,LYCH01----Here just export the top two sequence under schemas. But the problem with a very

1. Add a table that passes the structure and data of another tableCREATE TABLE XTHAME.TAB1 as SELECT * from Dsknow.combdversion2. If the table exists:INSERT INTO TAB1 select * from TAB2;3. In the same table, assign the reference to the A field to

from:https://sourceforge.net/p/cx-oracle/mailman/message/27145597/I ' d do it with a "row factory", here is the examples, one which builds a dictionary, the other one builds a "named tuple" and is very similar to sqlite3. Row.defmakedictfactory

After I test if the silent modeling version, in other database server calls need to copy the absolute path to the database, in order to facilitate implementation, this side using graphical modeling.Modeled version, cmd Command Window input

First way: Export a database using Plsql1. Open Plsql, find the toolbar, export the table 22. Go to the Export homepage, select the folder, enter the name of the export file, click Save 33. Click the Export button to eject the Export data

1The first thing you can see is our Oracle database service, each time we use our Oracle database to open Two servicesOracleoradb11g_home1tnslistenerOracleserviceorcl 2To open our Notepad and edit it. 3Enter our two lines of code in our Notepad

Bulk collect and ForAll joint application is a bit verbose, but for speed, write two more sentences.Create two temporary tables Create Tablet_test (TestID Number( +) not NULL, TestNameVARCHAR2( +), TesttypeVARCHAR2( +), TestlevelVARCHAR2( +),

Oracle additions and deletions--the deletion1. Delete database usersSql> Conn/as SYSDBAConnected.sql> drop user Feiyu cascade;The user has deletedIf the user cannot delete and error:ERROR at line 1:Ora-01940:cannot drop a user that is currently

1, "trunc (for dates)" trunc () function processing dateSelect Trunc (sysdate, ' yy ') from dual;--returns the first day of the yearSelect Trunc (sysdate, ' mm ') from dual;--returns the first day of the monthSelect Trunc (sysdate, ' DD ') from dual;

SELECT * FROM tablename as of timestamp to_timestamp (' 2018-05-04 13:30:00 ', ' yyyy-mm-dd hh24:mi:ss ')Querying data at this point in time(It is possible because the system time and database time inconsistencies can not find the data so the time

CREATE OR REPLACE PROCEDURE update_log_proc (plids in Varchar2,pparas in Nclob,msg in NCLOB) asbeginupdate G3_log_info SET Paras=pparas,xml_data=msg WHERE lids=Plids; END; Database execution: Execute Update_log_proc (' 00000 ', ' Clerk ', ' msg ')

about Oracle1. Sqlplus Connect Remote Oracle Command Sqlplus (need to set environment variables) Scott (username)/5456 (password) @192.168.230.128:1521 (IP)/ORCL (database name) 2. View Current User Show user--Sqlplus command

Basic Relationship: Database---Table space---data segment---partition---data blockData blockBlock Block is the smallest unit of data information that Oracle stores. This is the smallest unit in the Oracle environment. Oracle is also a block of data

In an Oracle RAC environment, use a grid account to performRun asmcmd into ASM command mode, such as:[Email protected] ~]$ AsmcmdAsmcmd>Asmcmd> du//displays all disk space occupied by ASM files in the specified ASM directoryAsmcmd> Ls-ls//Lists the

1. In Web. config or app. config files, it is not possible to write the account password directly in the same format as the SQL Server.C # is Microsoft, Oracle is made by Oracle, and the two are opposites, all understandC # connections are connected

----------------------------------------------------MySQL------------------------------------------------------------1. Download JDBC, unzip the JDBC, copy the Mysql-connector-java-version-ga-bin.jar file to Jmeter/lib;2. Open the JMeter and set the

Personally, I think it's a good writing.http://blog.csdn.net/wanglilin/article/details/7200201Demand:Update the records in the T2 (T_STATBUF) table with the same ID as the T1 (T_MT) table into the T1 table.1. The wrong wording:1 Update table_name T1