Oracle

Permissions classification 1. System permissions: Permissions for database operations, including but not limited to:CREATE TABLECREATE VIEWCREATE SESSIONCREATE SEQUENCECREATE PROCEDURE......2, object permissions: For user-created tables, view

First truncate is a DDL statement, and delete is a DML statement.The deletion of truncate is much faster than delete, especially when the amount of table data is large, because Truncate does not produce undo during execution, so truncate can no

VBA Round is based on the silver Connoisseur algorithm (rounds to the nearest even number)Round (1.5) = 2Round (0.5) = 0Implementing Banker Algorithms in Oraclesql> Create or Replace function Bankers_round (val number, rnd_digit number: = 0) return

Create or replace procedure Drop_all ascursor Cur_obj is SelectUO. object_name, UO. Object_type fromuser_objects UOwhereUo. object_name notinch('Drop_all') and UO. Object_type notinch('LOB'); /*cursor cur_tablespace is select UT. Tablespace_name

[Email protected] ~]$ export ORACLE_SID=ORCL[Email protected] ~]$ Sqlplus/as SYSDBASql*plus:release 10.2.0.1.0-production on Mon Nov 10 23:04:36 2014Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.sql> startup

The package consists of two separate parts: Baotou (packages) and inclusion (Packagebody). Baotou is the description part of the package, is the external operating interface, is visible to the application, the package is the code and implementation

1. View All Users: SELECT * from Dba_users;  select * from All_users; select * from User_users; 2. View user or role system permissions (System permissions that are directly assigned to a user or role): SELECT * from Dba_sys_privs; select * from

The client Oracle server enters the PL/SQL developer times ora-01033:oracle Initializationg or shutdown in progress error message that the application system cannot connect to the Oracle service. Solve the problem by remote guidance. The process is

Modeled http://blog.csdn.net/makenothing/article/details/170800691 Adding a database connection to the Oracle connection VS2010Get the connection stringData Source=server1; Persist Security info=true; User id=s227; password=xxx; Unicode=truexxx for

Add several password-related issues to note after upgrading from 10g to 11g:1.11g default start password is case-sensitive, you can set the parameter to Sec_case_sensitive_logon =false Shield2. The 11g password is valid for 180 days by default and

This function splits the target string with the specified string and returns the result through the table structure. The code is as follows:CREATE OR REPLACETYPE Str_split is TABLE of VARCHAR2(4000);CREATE OR REPLACE FUNCTIONSplitstr (p_stringinch

As the company needs to install Oracle EBS for form development, it starts the painful Oracle EBS installation process. Just started to install EBS in the VM Win2003 server, I do not know whether my own level is too poor or bad luck, according to

One, character functionsThe character function is the most commonly used function in Oracle, so let's see what the character functions are:Lower (char): Converts a string to a lowercase format.Upper (char): Converts a string to an uppercase

1. Randomly take records from the tableSELECT * FROM (SELECT * from staff ORDER by Dbms_random.random)Where RowNum To randomly fetch 3 records from the staff table2. Generate Random NumbersSELECT Dbms_random. RANDOM from DUAL;produce a random number

When pfile is used to start an oracle instance, startup fails --- the db_recovery_file_dest parameter value does not exist on the OS. [Oracle @ vm22 ~] $ Export ORACLE_SID = orcl [oracle @ vm22 ~] $ Sqlplus/as sysdbaSQL * Plus: Release

DBA_Oracle DBA partition concept Summary (concept), dba_oracledba 2014-06-20 BaoXinjian I. Summary Some maintenance operations on table partitions: Note: select a partition based on the actual situation. Table partitions have the following

Modify the size of oracle redo log files and oracle redo log files Create 3 new log groups SQL> ALTER DATABASE ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/orcl/redo06.log') SIZE 500 M; SQL> ALTER DATABASE ADD LOGFILE GROUP 5

ORA-01720 and ORA-01031 errors when GRANT/SELECT View, ora-01720ora-01031 For information about ORA-01031 errors when creating a view, refer to an article I 've previously compiled: Create view failed with ORA-01031: insufficient privileges,

Oracle11gRAC manually uninstall grid and nodeinstall1. log on to the ORACLE_HOME page of the grid as the root user. [Root @ db01] # source/home/grid/. bash_profile[Root @ db01] # cd $ ORACLE_HOME/crs/install/ 2. Execute the following two scripts

Oradebug promotes scnSometimes we encounter the following errors: ORA-01092: ORACLE instance terminated. Disconnection forcedORA-00600: internal error code, arguments: [2662], [0], [5685940], [0], [5685970], [4194432], [], [], [], [], [], []Process