Oracle

I. What is a cursor? Cursor letters are the moving cursor. Description in database language: A cursor is the entity mapped to a row of data in the result set. With a cursor, you can access any row of data in the result set, after the cursor is

Yesterday I encountered a very depressing problem. I wrote an oracle function SQL statement as follows: Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> 1 Create   Or   Replace  

The initial password can be used for four accounts: SYS system sysman Dbsnmp. Two important concepts: servers and Instances The server is not only a physical concept, but also a system process. The DBA often maintains the objects in the instance.

In Oracle optimization, I opened the database configuration in the console and found that the corresponding value was changed according to its suggestions because the value in the database was zero. As a result, Oracle cannot be started after the

1. Force delete a user Sometimes, you cannot delete connected oracle users directly. You need to force kill session information: Command: Select Sid, serial #, username from V $ session; Used to view the user's session information. If we

Using Oracle ODP. Net 11g. Net Program release method () ODP. net 11g is released by Oracle for. netProgramThe ADO. NET component that accesses the Oracle database has better performance than the Oracle component that comes with Microsoft. It can

In the last note (using internal keywords for field names in Oracle), I mentioned how to use the Oracle keyword as the field name. Recently, it was found that "" is different from [] in SQL Server, which may cause unnecessary troubles.I found this

When I backed up data two days ago, I found that the size of the c: \ oracle \ product \ 10.2.0 \ oradata \ gxsn \ temp01.dbf file was much larger than 23g, completely consuming the C drive space, in a rush, I thought that the file in the

For more information about the theory, see flyingis's blog: http://www.cnblogs.com/flyingis/archive/2007/10/14/924049.html. I will only describe the operation details to describe the operation process more clearly, Open the % sdehome % \ etc \

Oracle flash back operation: Table FLASHBACK:SQL> show parameter BinSQL> alter system set recyclebin = off;SQL> alter system set recyclebin = on;SQL> select * from cat; // view all tables of the current userSQL> show recyclebinSQL> purge

ORA-29861: Domain index is marked loading/failed/unusable Cause: An attempt has been made to access a domain index that is being built or is marked failed by an unsuccessful DDL or is marked unusable by a DDL operation.

1. Create a log data table (omitted) 2. Add log4net configuration section in Web. config   Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> 1 Database storage logs --> 2

Assume that there is a tablespace in the database orcl, and there are two users Scott and coder in the tablespace. If both users use DBA permissions, if we want to export orcl data, then import the data to another database (Other). I will record the

Basic syntax Select... from tabename start with cond1 connect by prior cond2 where cond2 Note: cond1 is the limit statement for the root node. Cond2 is the connection condition, where prior indicates the previous record, indicating that the

From: http://dev.tot.name/db/html/20090321/20090321223657.htm   AbstractImproper Character Set setting is a key issue that affects Chinese Character Display in Oracle databases. Based on practical experience, this article introduces Oracle's

Importing and exporting Oracle Data imp/exp is equivalent to restoring and backing up ORACLE data. The exp command can export data from the remote database server to the local DMP file, and the IMP command can import the DMP file from the local to

As I mentioned earlier, permissions are divided into system permissions and object permissions. Here we will explain object permissions. Object permission is the user's permission to operate on Data Objects of other users. Data Objects mainly

AsProgramClerk, Oracle database is what we must learn. Below I will summarize my basic knowledge and hope to share and learn! After the database is installed, we will get a default database. The default name of my database is orcl and we will get

Oracle beginner backup problems (two problems) Question 1: I want to learn how to use RMAN to back up and restore a database. I can see from the Internet and books that the log_mode of the database is required. It is in archivelog mode, and my

I made a C # And Oracle system, and it was really troublesome to install an Oracle client on each client. So I searched the internet and checked whether there was a method for not installing the client, oracle has long thought of this problem. He