Oracle Stored Procedure Learning

Java codeCreate or replace procedure stored procedure name (param1 in type, param2 out type) As Variable 1 type (value range ); Variable 2 type (value range ); Begin Select count (*) into variable 1 from Table A where column name = param1; If

Create and call Aggregate functions on your own in oracle

When you are working on a project, you may need to merge multiple records into one record, then combine different fields into one field for display, and separate them with commas, solved a lot of problems that are inconvenient to solve. We will sort

How to change the Oracle10g Port

Generally, the default port 1521 after Oracle is installed is used for security purposes. How to change.1. view the listening port:C: \ Documents ents and Settings \ mengzhaoliang> lsnrctl statusLSNRCTL for 32-bit Windows: Version

Db_name, instance_name, service_names

1. db_name SQL> show parameter db_name NAME TYPE VALUE----------------------------------------------------------------------------Db_name string aaadb Indicates that the database name is aaadb. 2. instance_name SQL> show parameter instance_name NAME

Oracle 10 Gb asynchronous calling of Stored Procedures

What is DBMS_JOB?DBMS_JOB is an expert package provided by Oracle database.It is mainly used to run programs in the background and is an excellent tool in the database. It can be used to automatically adjust scheduling routine tasks, such as

Oracle archiving and non-archive Switching

First, you can use the following statement to view the existing database mode:Select name, log_mode from v $ database;You can also use the following statementArchive log list; (This method requires the as sysdba)SQL> archive log listDatabase log

Oracle programming Art Study Notes (23)-Section

  Segments are the database objects that occupy the storage space. Each object that occupies the storage space is stored in a segment, such as tables, indexes, and rollback segments. Segment type 1) Table segment 2) table partition or

Detailed description of Oracle utl_file_dir Parameters

  1 UTL_FILE_DIR Parameter Definition UTL_FILE_DIR is a "static parameter" in Oracle. You can set one or more paths. It is used to specify the path when file I/O operations (utl_file package can be used) are performed in PL/SQL. UTL_FILE_DIR is a

Oracle online redefinition (converting normal heap tables into partitioned tables)

  1. Create a test table Use the sys user to create a test table SQL> CREATE TABLE HR. ST (ID NUMBER, TIME DATE ); Table created. SQL> INSERT INTO HR. ST SELECT ROWNUM, CREATED FROM DBA_OBJECTS; 50416 rows created. SQL> commit; Commit complete. 2.

Install Oracle EM 11g Fusion Middleware Control

  Oracle provides Fusion Middleware Control 11g, which uses the EM Console provided by it to monitor the performance of Web applications (such as adf bc application modules, task flows, and Servlets ). This is a good tool for monitoring the running

Oracle Big Data Processing

  Oracle defines a BLOB field to save binary data. However, this field cannot store real binary data, and only one pointer can be saved to this field, then place the data in the LOB segment of the Oracle to which the Pointer Points. the LOB segment

Demonstrate the impact of PCTUSED and PCTFREE on Data Operations

Demonstrate the impact of PCTUSED and PCTFREE on data operations in the PCTFREE experiment. As pctfree increases, the fewer block-mounted records and the more data blocks occupied. SQL> create table test as select rownum as id from dual connect by

Oracle Table & amp; Segment

What is the relationship between an Oracle Table and a Segment? The two are still confused. Let's talk about the association between them: first, we need to understand their concept: tables are logical objects, and segments are physical storage

Oracle functions for obtaining the start time and end time of the last ten days

Oracle functions for obtaining the start time and end time of the last ten days [SQL] -- get create or replace function fd_lastxunstart (rq in date) return string is refstr varchar2 (50); v_rq date; begin -- get date v_rq of the last ten: = trunc

Oracle partitions a table

Oracle partitions tables during data warehouse construction, there is often a large amount of data. In a short period of time, the data volume in the table is limited, and the query performance is still acceptable. However, as time passes, the data

Oracle tablespace (view path, modify, create)

Oracle tablespace (view path, modify, create) 1 view tablespace path select * from dba_data_files;  2. Modify the tablespace size. ALTER TABLESPACE MAXDATA ADD DATAFILE '/oradata/XX/MAXDATA02.DBF' SIZE 1000M;   [SQL] can be viewed through PL/SQL. 1.

Processing of orcle xmltype

Oracle supports a new data type named xmltype from 9i. It is used to store and manage xml data and provides many functions, it is used to directly read xml documents and manage nodes. The following describes some basic usage of xmltype. 1. create

ORACLE --- add control file

ORACLE --- adding control files will be unfamiliar without any technical skills. ORACLE control files are crucial. Next I will write an article on how to add control files to ORACLE. First, view the information of the current control file: 1SQL>

Oracle date computing

Oracle date computing -- Take the current hour and the hour v_begin_date: = to_date (to_char (sysdate, 'yyyy-mm-dd hh24'), 'yyyy-mm-dd hh24'); v_end_date: = v_begin_date-1/24; -- execution result: v_begin_date = 09:00:00 v_end_date = 08:00:00 --

Oracle Time Processing Method

Oracle time processing method: common date functions 1. Sysdate current date and time SQL> Select sysdate from dual; sysdate--------21- June-052. Last_day SQL> Select last_day (sysdate) from dual; LAST_DAY (s--------30- June-053. Add_months (d, n)

Total Pages: 2147 1 .... 2079 2080 2081 2082 2083 .... 2147 Go to: GO

Contact Us

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

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.