Learn about oracle database 12c sql fundamentals, we have the largest and most updated oracle database 12c sql fundamentals information on alibabacloud.com
One: The value of the field of the query string type is NOT NULL for SQL:[SQL]View Plaincopy
SELECT * from tb_cms_flgtinfo_a t where (T.fsta are not null and t.fsta ');
Main: The above tb_cms_flgtinfo_a is the table name, Fsta is the field in the tableTwo: The query string Type field has a null value for the SQL:[
Recently, because of the job needs, the boss asked the Oracle database on the server to migrate data to another server, I am not very familiar with Oracle, the migration of the database This is a matter of time spent, but also on the internet to inquire a lot of information. All kinds of moves are exhausted or not succ
maximum and minimum values for a columnSELECT * FROM table_name WHERE COLUMN_NAME = (SELECT MAX (column_name) from table_name);SELECT * FROM table_name WHERE COLUMN_NAME = (SELECT MIN (column_name) from table_name);3.SUM ([distinct l all] expr) MIN ([distinct l all] expr)Sum function that returns the value of the specified column andSELECT SUM (all column_name) from table_name [WHERE CONDITION];4.COUNT ([distinct l all] expr) MIN ([distinct l all] expr)Returns the number of records for a queryS
The best way to learn is practice! Therefore, my learning is based on practice. The most basic SQL statement is the query statement.
The best way to learn is practice! Therefore, my learning is based on practice. The most basic SQL statement is the query statement.
Preface
The best way to learn is practice! Therefore, my learning is based on practice. The most basic
How to connect JSP to MySQL database First, copy the MySQL database connection driver to the tomcat/common/lib package.
Download mysql-connector-java-5.1.6.zip
Http://mysql.cs.pu.edu.tw/Downloads/Connector-J/mysql-connector-java-5.1.6.zip
Configure the Tomcat virtual directory-Omitted
Create jdbcmysql. jsp page
Page
Code As follows:
Copy code The Code is as follows: Final string mysqldbdriver = "org. gjt.
, type, sum (source_size) source_size,Sum (parsed_size) parsed_size, sum (code_size) code_size, sum (error_size) error_size,Sum (source_size) + sum (parsed_size) + sum (code_size) + sum (error_size) size_requiredFrom dba_object_sizeGroup by type order by 2;
10. Monitor the log cache hit rate in SGA, which should be less than 1%
Select name, gets, misses, immediate_gets, immediate_misses,Decode (gets, 100, misses/gets *) ratio1,Decode (immediate_gets + immediate_misses, 0, 0,Immediate_misses /
); Example: Alter TABLE Stu Modify (stu_name number (20)); (8), add primary key: After the table is established, specify the column as the primary keyThe premise is that there is no null data no duplicate data.ALTER TABLE name add constraint (constraint, limit) pk_ table name _ specified column name primary key (the column specified by the primary key); Example: ALTER TABLE Stu add constrain Pk_stu+stu_no primary key (STU_NO); You can also add a primary key when you create a table CREATE TABLE
Tags: log cheng Baidu Oracle. com targe install Oracle detail getThe simple way to connect a remote database via PL/SQL is to install the Oracle client, and one way is to not install the client, but you need to create the necessary configuration files yourself, the following
Label:PL SQL Cursors Hrno records in the Hregright table that do not exist are populated with the Hrno in the House table (house only) Declare
cursorHouse_cur is
SelectH.regno,h.hrno fromHouse HwhereH.hrno is not NULL Group byH.regno,h.hrno having Count(H.regno)=1; begin
forHouseinchHouse_cur LoopUpdateHregright RSetR.hrno=House.hrnowhereR.regno=House.regno andR.hrno is NULL; EndLoop; End; PL
Label: --create the tablespace create Smallfile tablespace "Table_container"--Creating table space DataFile ' E:\ORACLE\ORADATA\ORCL\table_01 . DBF '--Create data file, file location of data file size 100M--Initial size of data file autoextend on NEXT 100M--data file increment size MAXSIZE UNLIMITED--Unlimited data file size LOGGING E Xtent MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO---Create the user created users test01--creates a customer identi
In our daily work, some security-demanding databases need to increase audit operations and which users do what when.1. Open the audit of the databasealter system set audit_sys_operations=TRUE scope=spfile; //审计管理用户alter system set audit_trail=db,extended scope=spfile; //将sql语句写入审计表中2. Restart the database and view重启数据库shutdown immediate;startup;show parameter audit;3. Increase the audit strategyWe need to
drop three grammars.
Database Manipulation Language (DML) is responsible for the instruction set for running data access work on database objects, with INSERT UPDATE DELETE three directives as the core
The Database Control Language (DCL) is responsible for authorization and role control of database objects,
Oracle Database PL/SQL trigger 7) trigger www.2cto.com 1. two basic concepts: complete the constraints of complex business rules that are difficult to complete due to the integrity constraints of the database; monitor various operations of the database to implement the audit
dataset.
C: Different from open source database synchronization software (Google results: Symmetricds, Opendbdiff (for SQL Server))
The previous three scenarios can be synchronized from Oracle to sqlserver2005, but if there is a large amount of data that may result in data loss in midstream or slower synchronization, the following scenarios are established:
S
\dbhome_1)(program = dg4msql)))The--------highlighting section shows that when the corresponding SID is configured on the transparent gateway, copy the highlighted paragraph and modify the corresponding sid_name.LISTENER =(Description_list =(DESCRIPTION =(address = (PROTOCOL = TCP) (HOST = 172.18.123.113) (port = 1521))----The IP address or hostname and port number of the listening server(ADDRESS = (PROTOCOL = IPC) (KEY = EXTPROC1521))))Adr_base_listener = D:\app\Administrator3. After configurin
Tags: data SP problem BS database server SQL as installationWhen SQL Server accesses a database table in Oracle remotely:The remote syntax is typically: SELECT * from OpenQuery (Oracle linked server name, ' query statement ')Eg:se
Oracle Database MaintenanceIt is a skill that must be mastered as a database administrator. There are many database maintenance operations. This article summarizes 18 common database maintenance operationsSQL code exampleNext, let's take a look at this part.
1. Find the SID
, Baidu to basically is program 2, but some of the data is basically the Oracle regular expressions listed to explain it again, In fact, I want to be a regular simulation like the function, I think if as a not proficient in the regular novice, learning a lot may not be able to use, so I have to share the idea of this article, if there is need to take to use good, if the need for regular, then further study.Advantages of this scheme:Simple to use, clea
Log on to PL/SQL Developer, log on to the local database, and check that the Oracle listening service is not started. Right-click to start the listening program and report an error. How can this problem be solved ?,
I. Error description
When you log on to PL/SQL Developer to log on to the local
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.