Oracle

--http://blog.csdn.net/gdjlc/article/details/23762549Oracle Modify field type method SummaryCategory: Oracle2014-04-15 15:24 15007 People read Comments (2) favorite reports There is a table named TB, field segment named Name, data type nchar (20)

When using order by for query sorting in Oracle, if there is a null value in the sort field (null), the sort result may not be the result we want. Such as:Sort by the age field in descending order, the result is as follows:Change the SQL statement

Http://www.cnblogs.com/eshizhan/archive/2012/04/06/2435493.html1. Two forms of the case-when expression:--Simple case function case sex when ' 1 ' then ' Male ' when ' 2 ' Then ' Women ' Else ' other ' END --case search function casewhen sex =

1 very strange, not very understanding of the principleOne, Oracle 12c create user is "ora-65096:invalid common user or role name" error-CalvinrHttp://www.tuicool.com/articles/V3UJZfASecond, Error "Ora-28040:no matching authentication protocol" when

a while ago, to do Oracle restore of the database. Because it's a rookie, I didn't use oracle database. So many places do not know how to start. in the SQL Server database restore, nothing more than an additional database . Or use a script to

1. Installation of sqlserver2008 R2 products 2. Log in with SA user 3. Click New Release: 650) this.width=650; "title=" clip_image001 "style=" border-top:0px; border-right:0px; Background-image:none; border-bottom:0px; padding-top:0px; padding-left:0

Problem: After using Scott to log in to Oracle, create a view that says "Insufficient permissions", How to solve?Reply:This is because Scott, the account, does not currently have permission to create views. The workarounds are:First sign in with the

DECLAREV_sql_drop_table VARCHAR2 (): = ' DROP TABLE my_test2 ';V_sql_create_table VARCHAR2: = ' CREATE TABLE my_test2 (not_null VARCHAR2 () not NULL, only_int INTEGER) ';BEGINEXECUTE IMMEDIATE v_sql_create_table; --Create a test

When you count a field with a null value, you find that count (1) is different from the record that is obtained by count (field).Conclusion: 1.count (1) is consistent with the result of Count (*) and contains a null value.2.count (field) does not

One: The basic principle of cursorscursors are used to process multiple rows of records retrieved from the database (using the SELECT statement). Cursors allow the program to process and iterate through the entire set of records returned one at a

[[email protected] ~]$ sqlplus/as sysdbasql*plus:release 11.2.0.4.0 Production on Mon Apr 17:19:32 2015Copyrigh T (c) 1982, Oracle. All rights reserved. Connected to an idle instance. Sql> Startup ORACLE instance started. Total System Global area 10

Get all the hours in a whileSELECTTo_date ('2013-07-01','YYYY-MM-DD hh24')+(ROWNUM- 1)/ -Sdate fromDualconnect byROWNUM(To_date ('2013-07-02','YYYY-MM-DD hh24')-To_date ('2013-07-01','YYYY-MM-DD hh24'))* - + 1;Get all the days in a

One, restore the non-current log group[Email protected] primarydb]$ RM-RF redo01*[Email Protected]:~>startupORACLE instance started.Total System Global area 285212672 bytesFixed SIZE 1218992 bytesVariable SIZE 96470608 bytesDATABASE buffers 184549376

1 ID auto-grow MySQL can be set in Auto Increment,oracle is not directly set, need to be implemented by sequence.Oracle SequenceCreate sequence Emp_sequenceIncrement by 1Start with 1NomaxvalueNocycleCash 10Attention:The first nextval returns the

First step, on the cmd command line, enter SqlplusStep two, follow the prompts to enter the user name and password1. View processes and Sessions parametersSql> Show parameter processesNAME TYPE VALUEDb_writer_processes Integer 1Gcs_server_processes

Unlike the previous versions, CodeSmith6.5 requires the user to manually add Oracle drivers, which are internally integrated with the Oracle driver.There are many Win7 64-bit machines on the Internet when using Codesmith to connect Oracle, errors

Prior to Oracle 10g, the merge statement supported 2 simple usages for matching updates and mismatches, and in 10g Oracle enhanced the merge statement by adding conditional options and delete operations. Below I have a demo to briefly describe the 10

Because there is already a database instance in the current environment, this does not affect the creation of a new instance of sunCurrent System Instance[[Email protected] dbs]$ env |grep

Oracle Data Pump (expdp) backup reports ORA-39006: internalerror in Linux Problem description: Oracle has been using a Data Pump backup, today at the terminal backup suddenly reported ORA-39006: internal error. The data pump export log file

Use mergeinto of ORACLE10gBefore Oracle 10 Gb, the merge Statement supports two simple usage methods: matching and updating and inserting non-matching. In 10 Gb, Oracle enhanced the merge statement and added the condition options and DELETE