Oracle

In my blog last week, I wroteArticle, Solves the troubles of installing on your own book. In the past, my computer and server were in the same LAN, so every time they were remote servers, they were not the solution. Because multiple people used

Using sqlplus can connect to Oracle normally, and using PLSQL to connect to Oracle is also normal. However, the following exception occurs when myeclipse's dB browser is used to connect to Oracle: Java. SQL. sqlexception: ORA-00604: Error occurred

Log on to the Oracle database through PL/SQL, and then execute the menu: File/New/command window, open a command window, and then execute the script in the Command window to create and delete tablespaces. Create a tablespace SQL> Create

Import the data exported from the Oracle database to the MySQL database1. Import the data to the MySQL database using the default ending symbol:Load data local infile 'd:/oracle.txt 'ignore into Table alarmlogThe default ending character of fields

Compared with other databases, Oracle Data has the primary feature of introducing tablespaces. This articleArticleLet's talk about the Oracle tablespace. Oracle Database pioneered the design concept of tablespace, which makes an indelible

[Guide] Using regular expressions in Oracle requires the following four functions: Oracle uses regular expressions without these four functions: 1. Regexp_like 2. Regexp_substr -- Select regexp_substr ('aaa, BB, CCCCC, DDD, vvv ',' [^,] + ', 1, 4

[Oracle entry series] Chapter 2 _ database query basics -- v512 workshop Editor: Xuan Yu Null Value Field alias Join Operator   Send me an email Sort Conditional Query Relational operators V512 Studio

1. conversion functionsThe biggest relationship with the date operation is the two conversion functions: to_date (), to_char ()To_date () converts the character type to the date type in a certain format:Specific usage: to_date ('1970-11-27 ',

Package test; Import Java. io. bufferedreader; Import Java. io. file; Import Java. io. fileinputstream; Import Java. io. filenotfoundexception; Import Java. io. ioexception; Import Java. io. inputstreamreader; Import Java. io. reader;

Create or replace procedure merge (v_phone_number in varchar2, v_tone_id in varchar2, v_tone_code in varchar2, v_tone_name in varchar2, v_tone_type in number, v_num out varchar2, -- serial number v_iswin out number, -- whether to win 0 not yet, 1

The daily work does not process much date. Recently, a time dimension table needs to be designed. This opportunity is used to sort out common date processing methods. Oracle provides several basic date processing functions Function

  -- Create Table try as select * from student basic information; -- add the deferred primary key alter table try add constraint pk_try primary key (student ID) deferrable initially immediate; -- set the primary key delay set constraint pk_try

Oracle databases have three standard backup methods: Export/Import (exp/IMP), hot backup, and cold backup. Exporting backup is a logical backup, while cold backup and hot backup are physical backup. 1. Export/import (export/import) The export can be

Write a stored procedure. You can enter the table name, the number of records displayed on each page, and the current page. The total number of records, the total number of pages, and the result set are returned. -- Oracle Paging Select T1. *,

I. Environment Description   Redhat Enterprise Linux 6.0 + virtual box 4.1.8 + Oracle 10g  2. Pre-installation Configuration  1. install the software packages required for Oracle 10g r2 Use Root Log on to the system and install the following

It has been plagued by the Unicode problem of Oracle 9i nvarchar for a long time. On the Internet, I can see an article KB-Oracle 9i nvarchar Survival Guide.To solve this problem in C #, I want to know how to solve it in Delphi 2009 (Delphi 2009 now

Note: Sid-Database IDHome_name-Oracle Home Name, such as orahome92 and orahome81(1) oracleservicesidDatabase Service, which automatically starts and stops the database. If a database is installed, its default start type is automatic. The service

Original article: http://desert3.iteye.com/blog/811007 -- Not a number select * from dual where not regexp_like ('1 is not a number 1', '^ [0-9] + \. {0, 1} [0-9] * $ ') -- select * from dual where regexp_like ('1. 1', '^ [0-9] + \. {0, 1} [0-9] *

Write Public Boolean savewordfile (string filepath ){ File file = new file (filepath ); Connection conn = getconnection (); Try { Java. SQL. Statement ST = conn. createstatement (); Conn. setautocommit (false ); St.exe cute ("insert into table_name

  1) field method: varchar2 (50), number, date, integer, char (10)2) Default Time: oprtime date default sysdate not null; call_time datetime default getdate () not null,3) create an index: Create index idx_accountchange on account_changehistory