Oracle

First, you can connect to the database in Java according to the JDBC specification. For more information, see Differences between http://djdnmq.iteye.com/blog/356468 Oracle drive OCI thin   OracleClient preparation 10201_client_linux32.zip

@ Echo offRem SC config oracleoracle10gtnslistener start = demandRem SC config oracleoracle10gisql * Plus start = demandSC config oracleservicecinno start = demandSC config oracledbconsolecinno start = demandPause @ Echo offRem SC start

It is estimated that SQL * Plus is used almost at the beginning in Oracle, After all, this tool can run on any platform running oracle, You can install this tool on the client or on the server, To install the client, install the client

Oracle Character Set viewingSelect userenv ('language') from dual;The following method can be used to modify Oracle10g and Xe: Connect system as sysdba;Shutdown immediate;Startup Mount;Alter system enable restricted session;Alter system set

Basic update statements Update all records Update Set = Create Table TestSelect object_name, object_typeFrom all_objects;Select distinct object_nameFrom test;Update TestSet object_name = 'opops ';Select distinct

Recently, I encountered a problem. After Oracle 10 Gb Database Export, the import in 9i was actually problematic, so After trying to install 9i and connect to 10 Gb, use the 9i exp command to export the data. Who knows whether the exported data is

Use the database trigger to correspond to the startup event Create trigger log_routine after startup on Database Begin Exec yourproc; End; Appendix:High score for help: Why cannot I trigger the startup trigger?When I create a startup trigger, I

//// // SQL Server ///////// /////////////////// Exec sp_droplinkedsrvlogin dbvip, null Exec sp_dropserver dbvip Exec sp_addmediaserver @ Server = 'dbvip ',--Access Server alias @ Srvproduct = '', @ Provider = 'sqloledb ', @ Datasrc =

If Oracle client x86 is installed, the system. invalidoperationexception error is returned when you access the Oracle database using. Net: badimageformatexception is thrown when you attempt to load the Oracle client database. This problem occurs

Query, disable, enable, and delete Foreign keys in Oracle 1. query the Foreign keys of all tables: Select table_name, constraint_name from user_constraints where constraint_type = 'R ';   2. Disable all foreign key constraints and use the

1. Disable all foreign key constraints Run the following statement in PL/SQL developer: Select 'alter table' | table_name | 'Disable constraint' | constraint_name | ';' from user_constraints where constraint_type = 'R '; Copy the query

The start with... connect by clause recursive query is generally used for a table to maintain a tree structure. Create example Table: Create Table tbl_test ( ID number, Name varchar2 (100 byte ), PID Number default 0 ); Insert test data: insert

1. Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services. 2. Start->Program-> Oracle-orahome81-> Oracle Installation products-> universal InstallerUnmount all Oracle products, but the universal installer cannot be

Cause: in fact, the system version is in English and the environment variable is also in English. After it is changed to Chinese, the JDK/JRE character set is the default English character set. Solution: install and use the new character set to

Oracle functions are divided into basic functions and analysis functions, The basic functions are the most commonly used, It is rumored that it is often used in data warehouses, In this blog post, we will only introduce the most common basic

This blog post mainly introduces the management of Oracle log files, There are two key terms for Oracle log files, That is, the log file group logfilegroup and the log file logfile, The following describes how to add a log file group, How to

If you encounter a requirement in the project, you need to merge multiple rows into one row. The table structure is as follows: Name null type -------------------------------------- N_sec_code not null char (6) C_researcher_code not null varchar2 (20

The final example shows the sorting of internal loops: SQL> Create Table T as select * From dba_objects; The table has been created. SQL> Create index ind_t_object_name on T (object_name ); The index has been created. SQL> ALTER TABLE t

Em configuration command ============================== Create an EM DatabaseEmca-repos createRebuilding an EM DatabaseEmca-repos recreateDelete An EM DatabaseEmca-repos dropConfigure Database Control for the databaseEmca-config dbcontrol

When you choose oracle as the database server, the client usually needs to install a fat M client, and also requires connection configuration, especially in the C/S mode, which is inconvenient when there are many clients. Of course, there is also a 1