After Oralce is installed in normal steps and dbca is used to create a database, an error is reported, as shown in:
The following error is reported in the Oracle Installation Log:
[Thread-40] [12:23:54. 055 CST] [BasicStep. handleNonIgnorableError: 431] ORA-00600: internal error code, arguments: [4: kg1_lditoepochts], [1], [], [], [], [], [], [], [], [], [], [], [], []
It is found that/etc/hosts is the
To make it easier for everyone to understand the SQL statements I have mentioned, this article assumes that a student achievement management database has been established. The full text is described in the case of student achievement management.
1. display the column name in the query results:
A. Use the as Keyword: Select name as 'name' from students order by age
B. Direct representation: Select name 'name' from students order by age
2. Exact search:
Tags: style blog http color os ar strong for dataA customer's RAC node hardware has changed, the host restarts after the database instance cannot start, remote login to view alert log found a large number of errors:Writing to the above trace file is disabledErrors in file/oracle/app/diag/rdbms/xxxx/xxxx2/trace/xxxx2_ora_184464.trc:ora-00600:internal error code, arguments: [4:kgstmlditomicrots], [1], [], [],
"Go" MySQL Database for internal connection, left join, right connectionInternal connection: The data corresponding to two tables are isolatedOuter joins: Isolate the corresponding data based on a tableFirst create the table in the database with the following database code:/*Navicat MySQL Data transfersource server:loc
Tags: tuple ima alt one HTTP database es2017 right connection dataAn inner join is a tuple that returns a relationship table that satisfies both the query condition and the join conditionAn outer join is a tuple that returns a relationship table that satisfies the query criteria but does not necessarily meet the join criteriaOuter connection: Left outer connection, right outer connection, full outer connectionA LEFT outer join is a tuple that returns
null7 rows have been selected.Sql> SELECT * FROM Dave a right outer join BL B on a.id = b.ID;ID Name ID Name---------- ---------- ---------- ----------1 Dave 1 Dave2 BL 2 bl1 BL 1 Dave2 Dave 2 bl3 DBA 3 Big Bird4 sf-express 4 EXC9 Huaining--The left table here is insufficient to fill with null7 rows have been selected.With (+) to achieve, the + number can be understood as follows: + to supplement, that is, which table has a plus, this table is a matching table. So the plus sign is written in th
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.