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
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
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
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
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
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
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
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
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.
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 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 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
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
[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 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 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 --- 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 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)
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