1. Definition
Process: (1) Accept 0 or more parameters as input (input) or output (outputs), or both as input and output (INOUT).
(2) Unlike functions, stored procedures do not return a value.
(3) Stored procedures cannot be used directly by SQL
The simplest type of writing is a fool
Oracle_database_linux32.zip is the name of the installation package
Configuration is simpler and more simple, so no variables are used
#!/bin/bash ################### Yum and rpm ###################
The SQL Tuning toolset (SQL Tuning set,sts) is an integral part of the Oracle 10g SQL Tuning Advisor feature. Each tuning toolset contains one or several SQL statements, as well as the contextual information needed to properly interpret them. SQL
Oracle Decode () functions and case statements are all common use, so what is the difference between them? Here's a detailed description of
The difference between the Oracle Decode () function and the case statement for your reference.
First, give
oracle| Data | database
Java interface with Oracle:
Running Java in a database can be said to be the most exciting new feature of Oracle8i. In the application you created to use the Oracle8i database, you can use new Java-related features to easily
1 IntroductionInformation is important for success, but if information is compromised or exploited incorrectly, it poses a threat to success. Oracle provides a wide range of security features to protect users ' information from unauthorized access
Oracle
Link
Http://www.eygle.com/case/sql_trace_2.htm
Problem Description:
Many times
When we do database operations
such as drop User,drop table and so on, often encounter such a mistake
Ora-00604:error occurred at recursive SQL level
This is a set of Windows RAC environments, as well as an environment that previously dealt with a performance failure caused by a row cache lock. Here is a record of the process:
1 for the one-hour AWR collection and analysis, first of all, from
In this paper, the configuration scheme of Oracle database is described in detail in several aspects.
All users connected to Oracle must execute two code modules:
Application or Oracle Tools: A database user executes a database application or an
RAC, Data Gurad, Stream are three tools in the Oracle High-availability system, each of which can be used independently or in conjunction with each other. Their respective emphasis is different, the application scenario is also different.
RAC its
Oracle Trace Files
Oracle trace files are grouped into three categories:
One is the background alarm log file that records the activity of the background process during startup, shutdown, and running of the database, such as table space creation,
If the backup is not recoverable, then it is useless. RMAN provides a way to check database restore capabilities without having to restore the database, and provides several check options for the user.
1. Restore Preview command
This command lets
Declaration: PL/SQL version:PL/SQL Developer 9.0.6 (http://files.allroundautomations.com/plsqldev906.exe)Error notificationCause: PL/SQL supports only 32-bit OS, and the workaround is to load an additional Oci.dll fileWorkaround: 1, download OCI.DLL
Single page application: Use a page that is loaded once, and if the page changes due to user interaction, only the part of the page that changes is drawn.To create a single-page application, you need to use OJ. Router is supported by virtual
Reprint Please specify source: http://blog.csdn.net/dongdong9223/article/details/47448751This article is from "I'm a fish-hook blog."
When importing data using the IMPDP data pump in Oracle, it is assumed that the user was created before the
In many cases of development, for convenience or commonality of consideration, we first consider the SQL Server database for development, but sometimes the customer's production environment is Oracle or other database, then we need to transform the
Oracle Performance Optimization Performance Diagnostic Tool-beyond OCP proficient in Oracle video tutorial Training 33Course IntroductionOracle Video tutorial, wind Brother this set of Oracle Tutorial training > 3rd 10 Sets: Performance diagnostic
Summarize Oracle system views and table Daquan:Dba_ opening .....Dba_users Database user InformationDba_segments Table Segment InformationDba_extents Data Area InformationDba_objects Database object InformationDba_tablespaces database table Space
The Oracle translate function and replace function Usage Details, oracletranslate
Syntax of the translate function:
translate(expr, from_strimg, to_string)
Introduction:
Translate returns expr, where all occurrences of each character in from_string
Example of how to use the decode function in oracle, oracledecode
Decode usage
1: Use decode to determine whether the string is the same
DECODE (value, if1, then1, if2, then2, if3, then3,..., else)
Meaning:IF condition = value 1 THENRETURN (value 1)
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service