Oracle

1. copy only the SQL statements of the Table Structure Create Table tablename2 as select * From tablename1 where 1 <> 1 2. SQL statement used to copy the table structure and data in the table Create Table tablename2 as select * From tablename1  

Background: Processing null values during sorting, In Oracle official documents, null values are a special value type in the sorting process. By default, null values are regarded as the maximum value. That is to say, during sorting, when the null

After Oracle 11g is installed on Windows Server 2008, PL/SQL developer can connect to the server. However, other Oracle client software has been installed on the LAN. OfThe machine cannot be connected through PL/SQL developer. After

Later, I checked the information and found that the tablespace data file size is related to db_block_size. when creating the database, db_block_size should be set 4 K, 8 K, 16 K, 32 K, 64 K, and so on, Oracle physical files can only be up to 4194304

During the installation of Oracle 11g R2, if a prompt is displayed, the system cannot find... /Oracle/11g/Solaris/J2EE/oc4j_applications/applications/em. ear file. After the download of the 11g file, decompress the package and there are two

1. Download the Oracle Instant Client.Be sure not to download instantclient-basiclite-win32 that only supports English, which does not support other languages.: Http://www.oracle.com/policy/software/tech/oci/instantclient/index.html, and select your

  SQL> shutdown immediateThe database has been closed.The database has been detached.The Oracle routine has been disabled. Start method: Enter dos Input Connect sqlplus/nolog to SQL SQL> Conn/As sysdbaConnected. SQL> shutdown abort

  1. Open EMC (Enterprise Manager), 1-1: The page "add database to tree" is displayed. (You can also click "Navigator"> "add database to tree ") Host Name: the IP address of the machine where the database is located. Here is 192.168.2.101.

Common Oracle commands1. Connect to the database Connect user name/Password Example: connect Scott/tiger; equivalent to conn Scott/tiger; 2. Disconnect Disconnect is equivalent to disconn; 3. Change the user's password Password is

Manage permissions and Roles * IntroductionWhen you create a user, the user does not have any permissions and cannot perform any operations. If you want to perform a specific database operation, you must grant the system permissions to the user; if

  Listener Configuration: # Listener. ora network configuration file: D: \ oracle \ Network \ admin \ listener. ora# Generated by Oracle configuration tools. Sid_list_listener =(Sid_list =(Sid_desc =(Global_dbname =Chenjian)(ORACLE_HOME = D: \

Jar files: Mysql-connector-java-5.1.7-bin.jar (* http://dev.mysql.com/downloads/connector/j/5.1.html of main files) Commons-dbutils-1.1.jar (queryrunner package http://commons.apache.org/downloads/download_dbutils.cgi required) Instance: 1. Put the

Because I have poor memory, I often cannot remember the commands. Note that it is not very bad, it is too bad, and it is also relatively lazy, so I want to write a little thing and release the labor force. so I had an idea to write a small tool for

CaseWhen fd_business.amount_debit> 0 andFd_business.syscreate_type <> 5 andFd_business.fd_fund_account_id in(Select fd_fund_account_idFrom fd_fund_account FFAWhere FFA. fund_account_type = 'C') then'Cash receipts'When fd_business.amount_debit> 0

// Create a spatial field index for Oracle Spatial table// ================================================Drop index index_sp_v_gbjj;Drop index index_sp_v_xzq;Drop index index_sp_v_ytfq;Drop index index_sp_v_dltb;Drop index

Guidance:Oracle has various restrictions (limit). A clear understanding of these restrictions can help us better use Oracle and understand oracle.This is the first article in the Oracle restrictions series. It mainly introduces some basic limits

Some Suggestions on connection to the Oracle Database "sqlallochandle on SQL _handle_env failed" "Microsoft ole db pr987yu4259654ovider for ODBC drivers error '20140901' [Microsoft] [ODBC driver manager] sqlallochandle on SQL _handle_env of the

Recently I made a data diagnosis project, in which I wrote a database operation class, including connecting to the database, reading data tables, performing SQL operations, and releasing the database. I hope it will be useful to everyone, due to the

Chapter 2 DML and transaction control-v512 workshop Editor: Xuan Yu Merge Save point   My blog Update Transaction Control V512 Studio Delete Automatic submission of sqlplus Chinese Emy of Sciences

Oracle Stored Procedure return result set * Process return record set: Create or replace package pkg_test As Type myrctype is ref cursor; Procedure get (p_id number, p_rc out myrctype ); End pkg_test; / Create or replace package body