Oracle

The client architecture of the wcf server is used in recent projects. The client sends a request to the server to query a table. The wcf server then accesses the server database and returns the result to the client.There is a problem with this, that

Recently I collected some questions about how THinkPHP connects to the Oracle database. Many of my friends follow the mysql connection method, which causes some methods to be unavailable in Oreale. For example, the findAll and Select methods cannot

First, write the connection string. You can write it in web. config. Copy codeThe Code is as follows: And then the back-end callCopy codeThe Code is as follows: string orclcon = ConfigurationManager. ConnectionStrings ["oracleson"].

1. Optimizing applications and business logic is the most important thing. 2. flexible application of the database design phase paradigm and the anti-paradigm. Generally, the internal design should be physical and non-standard for frequently

1. query table space usage: Sqlplus system/manager @ topprod Copy codeThe Code is as follows: SQL> @ q_tbsFREE 2. How to query temp:Sqlplus system/manager @ topprodCopy codeThe Code is as follows: SQL> SELECTD. tablespace_name, D. status

In Oracle, indexes are classified into the following types: B * Tree indexes, reverse indexes, descending indexes, bitmap indexes, function indexes, and interMedia full-text indexes, among them, the most common are B * Tree indexes and Bitmap

1. Convert string type to timestamp Copy codeThe Code is as follows: select to_timestamp ('01-October-08 07.46.41.000000000 AM ', 'dd-MON-yy hh: mi: ss. ff am ') From dual; 2. Convert timestamp to date typeCopy codeThe Code is as follows: select

Oracle stores data through corresponding algorithm conversion in the database. This article briefly introduces the Number-type data storage and conversion of Oracle. This article aims to answer question No. 2119 on the message board. We can use the

The oracle wm_concat (column) function is frequently used. The following describes how to use the oracle wm_concat (column) function to merge fields. If you use the oracle wm_concat (column) function) if you are interested in function usage, take a

Before Oracle9i, Chinese characters were sorted by binary encoding. The sorting by pinyin, radical, and stroke function is added to oracle9i.1. Set the NLS_SORT parameter value SCHINESE_RADICAL_M is sorted by Ministry (First Order), strokes (Second

I. Preface:After a period of storage process development, I wrote some summary and experiences during development and shared them with you, hoping to help you. Ii. target readers:Database developers, who have a large amount of data in the database,

In Oracle queries, if there is no sorting, but you want to route the information of a specific value in a column to the front, use the decode (field, 'field value', number) of oracle) For exampleSelect name from all data queried by the user. If you

Parse the oracle select locking method and the query of the lockI. oracle select locking method Copy codeThe Code is as follows: create table test (a number, B number ); Insert into test values (1, 2 ); Insert into test values (3, 4 ); Insert into

1. DIRECTORYSpecifies the directory where the dump and log files are located DIRECTORY = directory_object Directory_object is used to specify the DIRECTORY object name. Note that the DIRECTORY object is an object created using the create directory

How should I write SQL recursive statements in oracle databases? The following is an example of using SQL recursive statements in oracle for your reference. Example: Copy codeThe Code is as follows: pid id A B A c A e B b1 B b2 C c1 E e1 E e3 D d1

1. OriginWhen the oracle database field value is less than 1 decimal point, the char type is used for processing, and the 0 before the decimal point is lost.For example, 0.35 is changed to. 35. 2. Solution: Use the to_char function to format the

1: create a user Copy codeThe Code is as follows: create temporary tablespace user_temp Tempfile 'd: \ app \ topwqp \ oradata \ orcl \ user_temp.dbf' Size 500 m Autoextend on Next 50 m maxsize 2048 m Extent management local; Create tablespace

1. Shut down the database [Oracle @ RHEL5] $ sqlplus/as sysdba SQL> shutdown immediate; Ii. Disable listening[Oracle @ RHEL5] $ lsnrctl stop3. Delete oracle_baseI switched to root here.[Root @ RHEL5] # rm-rf/s01 3. Clear residual files[Root @

At this time, if duplicate data exists in the temporary table, whether the primary key field businessid is repeated or the whole row is duplicated, an error in violation of the unique primary key constraint will be reported. Method: group by XX

Stored Procedures and stored functions refer to the stored procedures and stored functions that are stored in the database and called by all user programs.. The stored procedure does not return values. Stored functions return values Create a stored