Oracle

  Create table xcp as (select * from B _za_bzdzkxx ); Select * from xcp; Select count (1) from xcp; -- 22001 Select count (1) from xcp t where t. dzbh like '20140901'; -- 510521% Delete from xcp t where t. dzbh like '20140901 '; Select count (1)

    A. Use PL/SQL Developer to display ORACLE Data in Excel, tsv (text), xml, and csv formats.   Environment: ORACLE10.1 and PL/SQL Developer Version 7.0.1.1066 Open PL/SQL Developer, File --> New --> Report Window --> In SQL, insert the SQL

Calculate the total amountSelect sum (price * qty) from books; Query groups (the group by statement must be in select)Select sum (price * qty) from books group by pub; use Group by and having to replace where Incorrect case:This is not correct. As

1. concept:The tablespace is the largest logical carrier. It stores the associated database logic and stores database files.2. Create a tablespace using SQLPLUSCreate tablespace tabs -- create a tablespaceDatafile 'f: \ oracle \ product \ 10.2.0 \

I recently summarized how to set the oracle primary key. paste it here and save it. There are two ways to set a primary key, one is auto-incrementing primary key, and the other is to generate a unique sequence.I. Auto-increment primary key -- First

Some days ago, when I was working on a project, I encountered a very strange situation. Today I plan to write it down for my friends to share.When writing an Oracle statement, we may add the and logical operator behind the where statement, but there

Oracle uses PL/SQL Developer to manage data objects and data. This tool also provides many convenient and quick operations, so that we no longer complain about the ugly and difficult-to-use UI of Oracle itself. Most of the operations for table

SQL/PLUS Run CommandAppend text;Replace text Change/old text/new textDELETE command DEL n --- Delete rowDelete buffer clear buffer -- delete all contents of the BUFFERAdd a statement INPUT textDisplay the content in the buffer LIST [n/LAST] list

The Oracle Database inserts a string into a BLOB field and converts the inserted BLOB data into a string display method.First, create a table create table TB_TEST (id number, blb blob) in the database, and insert an empty data insert into tb_test

Recently report data source switch to the query database, the query reported ORA-25153: Temporary tablespace is empty, it is strange, some queries have problems, some normal, switch to the business database Normal. The system database www.2cto.com

1. set SQL code SQL> archive log list in archive mode; # Check whether archive mode is used. SQL> alter system set log_archive_start = true scope = spfile; # enable active archiving SQL> alter system set log_archive_dest = ''location

During the Asktom and Eygle Shanghai discussion at ORACLE, eygle proposed: "What is the maximum size of ORACLE Redo logfile ". This issue is rarely noticed. Because redo logfile is used cyclically, there is no need to configure a large number of

OracleORA-12520: TNS: The Listener cannot find a problem with available handlers for the requested server type. view the processes and sessions parameters SQL> show parameter processesNAME TYPE when integer 1gcs_server_processes integer

Oracle needs to store new records to other disks through Table Partitioning: the original oracle database data files are stored on the d disk, but there is not much space left on the d disk. We recommend that you switch to the E disk as the boss.

ORA-12547 error handling this morning around, the leaders told me, let me help a colleague to ORACLE Installation, he encountered problems in the installation process, error, unable to continue to install. I. Due to the NLS_LANG setting error, cause

In oracle 9i/10g, if the database instance does not have the scott mode, you can manually create it as follows:Log on to the databaseCreate scott userAssign permissions to scott users Use scott to log on to www.2cto.com1. Execute the following SQL

ORA-00020, ORA-01304, ORA-27101 troubleshooting # ORA-00020 ProblemsDuring fixed-point maintenance, the "Next" mode is used for installation of the database by Windows software. All configuration parameter values are default values. But because the

Use the Alter Database statement to switch between startup modes.1. switch from NoMount mode to Mount mode (not from mount to nomount): Command: alter database mount; 2. when the DATABASE status is closed, switch to the Open mode command: alter

1. Oracle ROLLUP and CUBE usage in addition to the most basic syntax, Oracle group by statements also support ROLLUP and CUBE statements. For Group by ROLLUP (A, B, C), group by is performed on (A, B, C), and then group by is performed on (A, B,

How to insert data nsert into table values ('th product's name', 25, '05-MAY-07 ') containing a single marker in oracle ');This statement reports an error: ORA-01756: quoted string not properly terminated to INSERT data containing a single