Oracle

  Overview and simple example of Oracle Virtual Private Database (VPD) 1. Overview of Oracle Virtual Private Database (VPD) VPD provides better row-level access control than roles and views. For example, in internet access, a virtual private

Install oracle 11g in RHEL6.2 x86_64By Gong ChangyuIf you encounter any problems during the installation process, you can discuss them and learn together. If there are any errors, please let us know. Thank you.1. First modify the/etc/sysctl. conf

DBA _ view returns information about all objects in the database, regardless of the object owner. Only the database administrator can access this view. For example, a query of DBA_TABLES returns a list of tables related to the database. Sometimes

Flexible application of ROWNUM virtual column Rownum is not a physical column actually exists in the table, but a virtual column that can be used in any SQL statement. If you can correctly understand the concept and features of Rownum, you can apply

Oracle Database Operations-statistics of the number of men and women in a franchise store Web_THBC for the presentation layer is the page (. aspx) BLL_THBC is the business logic layer DAL_THBC for the database interaction layer (Execute SQL

Oracle ORA-01704: string literal too long problem analysis today when using SQL in oracle to directly insert update a table, the error of ORA-01704: string literal too long occurs, our SQL is [SQL] update mall_config a set. category_info = '|

Oracle Chinese character to PinYin (get full spell/pinyin first letter/pinyin interception, etc.) effect: Oracle Character Set GBK no problem, UTF-8 need to modify the SQL code-oracle Chinese character to PinYin PACKAGE-- 1. Obtain the full spelling

Adding a shared disk to a VM supports ORACLE 10g rac. Because the original ASM shared disk capacity is small, it is impossible to mount the archive log and backup files. so I decided to add a disk. 1. Add a virtual disk to node 1 and place it in the

Use plsql to import Excel Data to Oracle 1 prepare Excel to import data2. Save the Excel file as a text file (tab-separated) (*. txt ))You can also save an Excel file as a Unicode file, to convert the file encoding format of the generated Txt Text

Without installing the oracle client, you can also use plsql to connect to a remote oracle database. Every time you ask someone, can plsql directly connect to the server? They all say they want to install the client, I remember what kind of SQL

Oracle used a temporary table to return data tables and found many articles about the returned data tables in the stored procedure. We found that there is a big difference between oracle and SQL server. SQL server can directly return data tables in

When logging on to Oracle SQL developer, the problem is solved. When logging on to oracle's built-in SQL developer, the connection method was not selected at the beginning. The default connection type "Basic" was used. I filled in the connection

Beginner: Oracle getting started tutorial 1. note: To DELETE a TABLE, you must use the truncate table Name When deleting all the data in a TABLE. Because the drop table and DELETE * from table names are used, the occupied space of the table in

Optimization tips for SQL statements with millions of records in ORACLE 1. To optimize queries, try to avoid full table scanning. First, you should consider creating an index on the columns involved in where and order. Www.2cto.com 2. try to avoid

Check the server/client encoding and modify the database encoding at oracle 11g. If the server and client encoding are inconsistent, asp.net may display garbled characters when reading the database record. view the oracle server encoding: select *

Query the SQL information of oracle processes that occupy the CPU 1: first, use the TOP command to pass the SPID number pid username thr pri nice size res state time cpu COMMAND3575 oracle 1 12 0 0 K 0 K run 748.6 H 24.98% oracle3571 oracle 1 22 0 0

How to automatically execute the oracle stored procedure every day and call the stored procedure with the joboracle timer 1. create a table. To see the running status of the timer clearly, create a table SQL code with a date field: create table

Sqlplus Command Format and set Usage and interpretation in sqlplus [oracle @ oracle02 username] $ sqlplus -- helpSQL * Plus: Release 9.2.0.4.0-Production Usage: SQLPLUS [[] [] [] where :: =-H |-V | [[-L] [-M ] [-R ] [-S] :: = [/] [@ ] |/NOLOG ::=@

The SQL script running FOR 10 Gb IN oracle9i environment is incompatible. There is no problem IN running the SQL script IN oracle10g environment. The following is the SQL code FOR C IN (SELECT * FROM TABLE (pkg_rj_common.f_split (P_IN_IDS _, ',')

Let the show parameter command of Oracle show the hidden parameter Find internal of "show parameter" by session tracingSQL> select * from v $ version; www.2cto.com BANNER implements Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit