Oracle

the size of the Oracle query table, the usage of the table space, the default table spaceThe size of the Oracle query table, the usage of the table space, the default table space--View a table takes up disk space (table name capitalization)Select

When I recently used oracle9i, I encountered problems with database backup and recovery, which are often related to the use of exp and IMP commands. For the problems encountered, a simple summary.The background of the problem is the need to import

Declarex number; Beginx:=9;> --Cycle point x:=x-1;dbms_output. Put_Line (X); IF X>0thengoto Repeat_loop; --When the value of X is less than 9 o'clock, goto repeat_loopend if; end;/For loop usage in OracleDeclarex number; --declaring variable

In Oracle, the Utl_file package provides a number of functions and procedures for manipulating text files, learning about his basic operations 1. Create a directory and give the user authorization to copy the Code code as follows:--Creating

1. Create/* Step 1th: Create Tablespace */Create Tablespace XybiDataFile ' E:\oracle\oradata\zzxe\xybi_d01 ' size 100M;/* Step 2nd: Create a temporary tablespace */Create temporary tablespace xybi_tempTempfile ' E:\oracle\oradata\zzxe\xybi_t01 '

Oracle cursors Use the full solutionThis document contains almost every aspect of Oracle cursor use, and all passes the test--Cursor cursor_name is select_statement--For loop cursors--(1) Defining cursors--(2) Defining a cursor variable--(3) using

This article has been redirected from an excessive number of Oracle Dblink connections (Ora-02020)Today, when dealing with data synchronization issues, it is necessary to synchronize data from several other DB servers to a single target repository,

Using JDBC to connect to the database, fly is divided into three steps:The first step: Download a JDBC driver, then throw the jar package into the project and add to build path;Step two: Go to the local Oracle folder to find "TNSNames." ORA "file,

In fact, this is not a new topic. But before in many projects, always encountered in the Oracle database access, there will be a variety of problems, the most basic is to install a variety of clients on the client, the version is different, there

The recent database query encountered a problem, the database is a number Type field, in the Java type corresponding to have an integer and BigDecimal will appear;The test found that when the database is SQL Server and DB2, the integer type is taken

I wrote a data synchronization method, data synchronization between two databases, you can call the stored procedures, add jobs to implement timed synchronization data.CREATE OR REPLACE PROCEDURE Data_sync_common (tableName in varchar2) is V_sql

--CREATE TABLE SpaceCreatetablespace imarkdatafile'E:\oracle\product\10.2.0\oradata\orcl\imark.dbf'size 500Mautoextend on Next100M MaxSize Unlimited logging extent management local AutoallocatesegmentSpaceManagement auto;--Create userCreate

1: Common functionsTo_date () function to convert a string to a date formatSelect To_date (' 2015-09-12 ', ' YYYY-MM-DD ') from dual; --The subsequent date format to match the previous conversionTo_number () function to convert a string to a number

Today want to visit Oracle's EM service, but the dead and alive, Baidu told that there is no start ORACLEDBCONSOLEORCL service, enter the service, right click Start, prompt error, Baidu for a long time, the final solution is as follows:1:cmd command

-----------Books: Oracle query optimization overrides-----------1th "c## #oracle" is the user name of the login database, and the 2nd "Oraclechange" is the name of the database to log in as the password "Oraclechange" for the login database./*Create

--oracle practice;/**************************************************pl/sql Programming Basics ************************************************* **************/--firstday--"" "Data type--Create tableCREATE TABLE T_cscustomer(Cust_no VARCHAR2 ()

1.查看所有用户：select * from dba_users;   select * from all_users;   select * from user_users;2.查看用户或角色系统权限(直接赋值给用户或角色的系统权限)：select * from dba_sys_privs;   select * from user_sys_privs; (查看当前用户所拥有的权限)3.查看角色(只能查看登陆用户拥有的角色)所包含的权限sql>select * from

Today, when importing a batch of data to Oracle, I ran into a problem: Toad hints to assign a custom variable amp, and at first I was wondering if the data is a series of INSERT statements, how can I have a custom variable? Then I searched for the

Core word: Chongqing si Zhuang, Oracle Technical Support Phone: 023-68429836,oracle database cluster installation service, performance tuning, Oracle Database Upgrade service, Oracle cannot start, Oracle slow, Oracle database hangs, node exception

Oracle Database basic learning (6) subquery, oracle Database A subquery contains multiple nested query statements in a select statement.   1Use subquery in THE where clause (generally, return "Single Row, single column" Single Row, multiple columns "