SQL code
-- Ref cursor
/*
Show multiple rows of a cursor
Implicit cursor data manipulation language DML and single-line select into statement
1. Define a cursor
Select result set statement corresponding to the cursor
CURSOR cursor_name IS
1) Full Table scan (Full Table Scans, FTS)To scan the entire table, Oracle reads all rows in the table and checks whether each row meets the WHERE restrictions of the statement. Oracle reads each data block allocated to the table sequentially until
Migrate databases using third-party tools-import, export, backup, and restoreTo put it bluntly, the so-called database transfer means to copy the tables, data, and stored procedures on the database servers used for development, and then import them
Change... keep (rman long-term backup) is to determine when to mark the backup file as "obsolete" based on the change command. SQL> select * from v $ version; BANNER implements Oracle Database 11g Enterprise Edition Release
[1] 1. select name, log_mode from v $ database; NAME LOG_MODE ------------------ ------------------------ query noarchivelog 2. use the archive log list Command Database log mode No Archive Mode Automatic archival Disabled Archive
With the rapid development of traditional databases, computer networks, and digital communication technologies, the research and development of distributed database systems featuring data distributed storage and distribution processing have
ABS (x)[Function] returns the absolute value of x. [parameter] x, number expression. [Return] number. [Example] select abs (100), abs (-100) from dual;
Sign (x)[Function] returns the positive and negative values of x. [parameter] x, number
1. What is the Oracle character set?The Oracle character set is a collection of symbols for the interpretation of byte data. It can be divided into different sizes and have an inclusive relationship. ORACLE supports the national language
1. view the operating system version SQL> select * from v $ version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-ProdPL/SQL Release 10.2.0.1.0-ProductionCORE 10.2.0.1.
Set oralce Automatic Memory ManagementShutdown and restart are required to enable oracle automatic memory management.1. Determine the sga pga memory size:Copy codeThe Code is as follows:SHOW PARAMETER TARGET 2. determine the maximum pga usage since
Introduction to iSQL * PLUS
ISQL * PLUS is a new feature provided since ORACLE 9i and is a Web form of SQL * PLUS (not supported by ORACLE 11g ). It is designed based on a three-tier structure. Its client, middle, and server can be located on the
-- Connection recovery ManagerC: \ Documents ents and Settings \ mengzhaoliang> rman target/-- Archive log listRMAN> list archivelog all;-- Delete archive logs that do not exist in the physical fileRMAN> delete expired archivelog all;-- Delete
This course is a part of the Oracle Advanced Course, which is slightly theoretical, but closely related to database program development, management, and optimization. In addition, part of this course has been covered in the previous chapter, pay
Many data conversion and processing operations may encounter the need to convert 0.007007040000 to 0.70%. We can use the Oracle SQL function to_char to achieve this conversion.This function is used to convert the DATE or NUMBER data type to a
Web_THBC indicates the presentation layer, that is, the page (. aspx)BLL_THBC is the business logic layerDAL_THBC is the database interaction layer (Execute SQL statements to the database)Model_THBC is an entity class.DbHelper is the database
After installing Oracle11g, I want to enable the built-in SQL Plus for learning, and then follow the prompts to use the sys user to connect to the database. If I lose the SQL Plus, an error is prompted several times:Error: the account is lockedThis
Partition Table Concept Partitioning is committed to solving the key issues that support large tables and indexes. It uses a small and easy-to-manage partition-based piece (piece) method. Once a partition is defined, SQL statements can access a
1. Start-> Settings-> Control Panel-> management tools-> servicesStop all Oracle services.2. Start-> Program-> Oracle-OraHome81-> Oracle Installation Products->Universal InstallerUnmount all Oracle products, but the Universal Installer cannot be
If you delete a data file in a tablespace before Oracle10g, the file will still exist in the Database Data Dictionary. Unless you delete the tablespace, the file information will not be cleared.
However, from Oracle10gR2, Oracle allows us to
/*The younger brother just came into contact with the ORACLE stored procedure and asked me a question. The younger brother wrote a stored procedure to receive a parameter as the table name, then, you can query the content of one field of all records
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.