C # connecting Oracle databases can implement many of the features we need, and here's how C # connects Oracle database query data, and if you're interested in C # connecting to Oracle database, you might want to take a look at this.Using System;
Set mydate=%date:~0,4%%date:~5,2%%date:~8,2%EXP username/Password @ instance name file=d:\mydata_%mydate%.dmp owner= user name Log=d:\mylog_%mydate%.logforfiles/p d:\123/s/M *.dmp/d -7/c "cmd/c del @path"DescriptionSet
One,the characteristics of Oracle database, can have the following four points:1, the Complete data management function:The large amount of data, the persistence of data retention, the sharing of data, the reliability of data2, complete relations of
--Query field name, field type, field comment Select dd.*, EE. Constraint_type from (SELECT t.column_id, T.column_name, (case when (t.data_t YPE = ' VARCHAR2 ' OR t.data_type = ' RAW ' then T.data_type | | ' (' | | T.data_length | |
/** * Call function get data table ID value * @param tableName Table name * @return * @throws SQLException */public string Callfun (string tableName) t Hrows SQLException {Connection conn = connectionfactory.getconnection (); CallableStatement
Ora-12516:tns: The listener could not find an available process ' error that meets the protocol stack requirements, to resolve the problem first look at the number of existing processes in the database, whether the parameter processes has been
SQL statement for querying and deleting duplicate records1, look for redundant records in the table, duplicate records are based on a single field (ID) to determineselect * FROM table where Id in (select ID from table group Byid have count (Id) > 1)
DeclareForint number (18);Seqnum number (18);BeginFor forint in 1..20000 loopSelect Seq_forum.nextval to Seqnum from dual;Insert into Frm_answer (Answerid, QuestionID, ParentID, Answertype, Createuserid, CreateDate, Updateuserid, UPDATEDATE, S Tatus,
Paging statements:Select z.* from (select X.*,rownum members from Reg_user x where rownum01 Get Total PagesSQL code 01.SELECT DECODE (mod (COUNT (*), s), 0,count (*)/100,trunc (COUNT (*)/100,0) +1) 02.AS pages from XZQH where XZQH is the name of the
The following is an example of importing and exporting.Data export:1 full export of database test, user Name System Password Manager exported to D:\daochu.dmpExp system/[email protected] file=d:\daochu.dmp full=y2 Exporting the system user in the
Oracle learning path (6) two practical examples1. Simple data insertion example
-- Created on 2015/6/15 by LYH declare v_fnumber varchar2(10):='qwe'; v_fname varchar2(10):='lyh'; v_fage int:=10; v_fsalary int:=101.00;begin INSERT INTO
. Net connection to oracle Database --- ShinepansFAQ: 1. the reference solution is missing. Add reference:
using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Data.OracleClient;using
Oracle Database questions
Table Structure Description:
Create table employee (id number (10) not null, -- employee id salary number (10, 2) default 0 not null, -- salary name varchar2 (24) not null -- name ); -- enable the console to output set
Oracle view and other object operationsView and other object operations
Lab Purpose
(1) master the creation, query, modification, and deletion operations of views.
(2) establish, query, modify, and delete synonyms, and compare the operations on
Oracle obtains the year, month, and date list for a certain period of time.
Get date list:
SELECT TO_CHAR (TO_DATE ('2017-10-01 ', 'yyyy-MM-dd') + ROWNUM-1, 'yyyymmdd ') as daylist from dualconnect by rownum
Obtain the month list:
SELECT
Oracle Learning (13): Data DictionaryThe data dictionary structure includes:-basic table: Description of database information, which can only be modified by the database server-User table: User-Defined tableData Dictionary naming rules
Oracle regular backup and oracle backup
1. Copy the following code to the text, and modify the text suffix name to a XXX. bat batch file;
**************************************** **************************************** ******************************
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service