Oracle

Usually when the enterprise development, the database is not installed in our local (nonsense), so when using plsql, when not necessary, we try not to install Oracle, too big;Next say I plsql, do not install Oracle's use steps;1. Personal Local

Example is given below to create a data block based on from Clause query in Oracle Forms. The following is the steps: Create a data block manually and set the following properties: You can specify different query as per your need. Then create

1-show pagesize # # #显示页行数Set PageSize # # #显示页行数为3002-show Linesize # # #显示行宽度Set Linesize # # #显示行宽度为3003-show Numwidth # # #显示数字字段长度Set Numwidth Ten # # #显示数字列长度4-Save Forever/u01/app/oracle/product/11.2.0/db_1/sqlplus/admin/glogin.sql # #

The concept of cursors can be understood as a result set object similar to the one we learned before.We can use cursors to traverse the result set from top to bottom to get each line of contentFirst, we'll analyze the classification of cursors.

A new 64-bit Win7 system has recently been installed that requires an Oracle database for work, and a database that is managed and maintained by the company's it dba.We only need to connect to use it, so I installed the Oracle client x64 and PL/SQL

The first step in using the tool is to install the tool and configure the environment! The following is a brief introduction to the installation and simple utility of Oracle 11g Express.A Download the installation processGo to Oracle's official

The first step is to create a table spaceLog in to the OEM as Sys/sys account and SYSDBA, and open the table space creation interface through manage-database management-storage-tablespaceSelect Create to go to the Create TABLE space interface,In the

1. Understand the types of SQL(1) DDL Data Definition language: Defines how data in a database is stored, including the creation (create) modify (Alter) Delete (drop) of database objects, which are mainly databases, data tables, views, indexes, and

1. SYS user and System userWith the SYS user login needs to sysdba role login, so when entering the password in the password after adding as SYSDBA. SYS SYSTEM Status A super User of Oracle Oracle

1. View all users in the Oracle database: (1) Log in to the database using an account with DBA authority; (2) Execute select username from dba_users. SQL> conn sys input password: connected. SQL>Select from dba_users; USERNAME-----------------------

Daoteng Oracle for a while. Because the project often need to use, some basic function or need to grasp, convenient for peacetime project docking and maintenance, truth-seeking, speak, today record an Oracle 11g complete creation of tablespace

Daoteng Oracle for a while. Because the project often need to use, some basic function or need to grasp, convenient for peacetime project docking and maintenance, truth-seeking, speak, today record an Oracle 11g complete creation of tablespace

MySQL differs from OracleArticle Category: DatabaseFriday went to a company to interview, the company manager asked about the difference between MySQL and Oracle, did not summarize before, the answer is not very good, just by feeling, first summed

Tag: Generate MOS log _id download Containe Style size nbsp12C Dbua New Features1. New pre-upgrade check tool.2. Parallel upgrade.3. When upgrading Dbua, the default degree of parallelism is the number of CPUs or 2. The degree of parallelism can be

1. Aggregation functionCount (field) //number of non-empty lines max (field) //Get maximum sum (field) //Sum avg (field)/ / average min (field) / min value2. Conversion functionTo_date ()

Join on: Multi-Table AssociationInternal connections: Connecting to other tablesFrom table 1 T join table 2 s on t. Field 1 =s. field 2 join table 3 N on N. field 3=t. field 1 or from table 1 A, table 2 B, table 3c where a. field =b. field　　Self-

One, the database query statement:1. Query the entire table: SELECT * FROM table nameCases:2. Query a row of data by condition: SELECT * from table name where field nameCases:3, a column of data to re-query: SELECT DISTINCT field name from table

The previous blog describes the method of backing up Oracle with the Navicat tool, which describes how to import and export an Oracle database using the PL/SQL developer tool. PL/SQL Developer is one of the primary tools used by Oracle databases

How to learn Oracle? Distinguishing several concepts is the key There are always some Oracle beginners ask the following questions, here to focus on the answer, I hope to help you.  1, if there is a certain base of the database, know what SQL is

SYS as[email protected]>startup open;ora-32004:obsolete or deprecated parameter (s) specified for RDBMS instanceORACLE instance started.ORA-32004: does not affect the use of the database. The error message is a parameter expiration. You can see the