Write a simple query statement1. Display all the information of the Department tableSelect * FROM Dept;2. Show department number, department nameSelectdeptno,dname from Dept;3. Displays the following fields and string connections: Employee name, "1
Modify field Comment sql:COMMENT on COLUMN table name. Field name is ' comment content '; Bulk Modify field comments for all tables, here is the modification of all field attachments that are not annotated: implementation steps: 1. Use SQL to find
To write efficient SQL, you must have a clear SQL execution path, a lot of articles about how to improve SQL performance, and I'll talk about how to improve query performance from reducing the number of SQL back tables, because the back table will
Turn into Oracle to do the project, sister's, too pit Dad, Oracle does not have the concept of database, is to build roles, assign permissions, seemingly very powerful, after building the right to check the data when the error said that the users
http://www.blogjava.net/lukangping/articles/340683.html/* creates a memory space parameter allocated for bitmap index to speed up indexing */Show parameter create_bit;/* Change the storage parameters of the index */Alter INDEX INDEX_NAME PCTFREE
Oracle does not have the top number feature of SQL Server. Can only be achieved in the form of a periodCode implementation paging, parameters curpage the current page, pageSize per page row, calculate the starting end page numberint startpage =
The drop tables and indexes are stored in the Recycle bin ( so the Recycle Bin function must be set for the production database )Because this generation environment after dropping the existing table, re-create a lot of tables, all the direct
Job: Flash Back Table experiment1. Construct the test table flb_test, the data is not less than 10000 lines;[email protected]>create table flb_test (ID number,dd date);Table created.[email protected]>begin2 for I in 1..100003 loop4 INSERT into
(Study record)In the Code table class and field class please refer to: http://meijia.blog.51cto.com/8684191/1563874The relevant parameters can be adjusted by reference to the API.(Same note format)1. The method is as followsPublic list Export ()
One, Oracle connection type☆ Description: According to their own understanding of the type of classification, not the official definition.1. Internal connection① equivalent Connection② Non-equivalent connection③ Natural Connection2. External
First, the system table:1. User_tables: Store information of all the tables under the user;2. Dba_tables: Store All the information of the table under Administrator's permission;3. All_tables: Stores information for all tables.Second, determine
oracle10g after the installation is complete, the value of Global_name is not only ORCL, but also the domain name, and very long, difficult to remember. So think of ways to change the value of Global_name.Conn/as SYSDBAShow parameter
Usage of ForeignKey outside Oracle (1)
Oracle Foreign Key usage (1)1. Objectives
Demonstrate how to use a foreign key in an Oracle database2. What is a foreign key?
1) in Oracle databases, foreign keys are one of the methods used to achieve the
Oracle Development Environment ConstructionI. software preparation address: installation package on the oracle Official Website: because of personal learning, you can install the server without a client. A total of two compressed files are extracted
PL/SQL -- package, plsql --
I. Package
A package is a combination of PL/SQL programming elements such as related processes, functions, constants, variables, cursors, and exceptions. It is similar to classes in C ++ and Java, where variables are
Install Oracle10G in windowsUnzip 1.decompress the file 10__database_win32.zipand double-click setup.exe under the project. The installation interface is displayed as follows:
Enter the password and confirm the password, for example, password.
Sort related concepts in oralce
【Database Name]
Concept:It is a database identifier, which is equivalent to our ID card. If multiple databases are installed on one machine, each database has a database name, when these database names are created,
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