Oracle

Oracle queries all tables under the userSELECT * FROM All_tab_comments--Query All users ' tables, views, etc.SELECT * FROM User_tab_comments--Query the user's table, view, etc.SELECT * FROM All_col_comments--queries the column names and comments for

Because you are familiar with Linux commands, you have installed Oracle virtual machines in the Win7 environment and installed unbuntu-server in the virtual machines. Unbuntu installation process is smooth, because it is a piece of cake, the basic

Oracle system permissions and role permissions are limited to the user's permissions, which also protects the access security of the database to some extent. Let's take a look at the following.Oracle System permissionsOracle system permissions

stored procedure Create OR REPLACE PROCEDURE ADMIN. Insert_obj (objefirt_parms in NVARCHAR2, objedatt_parms in NVARCHAR2, objesect_parms in NVARCHAR2, objecontent_parms in NVARCHAR2, isrelease_parms in INTEGER, objecode_parms in NVAR CHAR2, tags_

/// ///returns the value of the simulated self-increment field for the corresponding table/// /// Table name /// table's simulated self-increment field value Public decimalGetpknum (stringtablename) { Switch(

Helloworld.sqlSet Serveroutput onDeclare--Description sectionBegin--ProgramDbms_output.put_line (' Hello world ');End/If statement. sql--Determine the number of user inputSet Serveroutput on--Receive keyboard input--num: Address value, at which the

----constraint---------1. PRIMARY KEY constraints--Unique identifier, cannot be empty, usually used for ID--1> Creating a primary keyCREATE TABLE Person (ID VARCHAR2 (primary key),Name VARCHAR2 (50),Birthday date,Sex VARCHAR2 (2) Default ' male

Log in to OracleSqlplus/as SYSDBASql> Startup---Start Oracle databasesql> shutdown Immediate--stop databaseConn Smsdb/password--Connect to SMSDB usersBack to Terminal mode, enter:$ LSNRCTL StatusCheck to see if the listener has a boot.If it does not

Create a user smsdb, view status locked (TIMED)UNLOCKED, conn Smsdb/password still error, and then locked, and finally found that the number of errors to reach the Oracle limit of 10 times, resulting in subsequent failure to log on operation. Here's

1. Download the Oracle instance client. Http://www.oracle.com/technetwork/database/features/instant-client/index-097480.htmlSince the machine is 64-bit, the 64-bit version is downloaded. But later found that Plsql is 32-bit, and downloaded the

1. Turn off all Oracle services. Can be turned off in the Windows Service Manager;2. Open the registry: Regedit Open path:Hkey_local_machine\system\currentcontrolset\services\Remove all service names starting with Oracle under this path, which is a

I. PrefaceIn our operating system, sometimes to unload the Oracle database, each time to remove the win under the registry, in order to facilitate the removal of the registry information, the following through a delete registry shortcut script.Two.

ORACLE AWR report Generation Steps(Example of a command window in PL/SQL)1.sqlplus or plsql commod window (Command window) Run command@d:\oracle\product\10.2.0\db_1\rdbms\admin\awrrpt.sql; --specific address, need to query to get--then enter the

Oracle establishes tablespaces and users[SQL]View PlainCopy To establish the tablespace and the user's steps: User Create:Create user username identified by "password"; Authorization:Grant create session to user name; Grant create

I. Table space-related commandsCreate a data table spaceCreateSmallfile tablespace DataSpace datafile'E:\oracle\product\10.2.0\oradata\orcl\dataSpace.dbf'SIZE 50M Autoextend on Next10M MaxSize unlimited extent management local; creating a temporary

64-bit win7 with PL/SQL, often meet "Could not load" ... \bin\oci.dll "" This error, I checked the information because PL/SQL only supports 32-bit OS, The workaround is to load an additional Oci.dll file with the following actions:STEP1: Download

The following article reproduces the blog: Http://blog.csdn.net/bluishglc speaks deeply and thoroughly, turns to share under: basic idea and segmentation strategy of database shardinghttp://blog.csdn.net/bluishglc/article/details/6161475on the grain

The difference between Oracle and SQL Server development is that developing a database application with SQL Server typically builds a database and then designs a database object in the database, such as tables/views/stored procedures/functions

To create a package:Create or Replace package P_view_param isfunction Set_param (num number) return number;function Get_param return number;End P_view_param;To implement the package body:Create or Replace package body P_view_param isParamvalue

Online Baidu to appear this phenomenon reason, said seems to be quite reasonable, so copy come over:when you debug a procedure, function, or package, the company's firewall kills the session connection if there is no action for a long time. This