Oralce officially released Java 11 on September 25, the first long-term release supported since Java 8. As we all know, none of the previous releases were long-supported, however, it makes sense to release this latest long-supported release. Java11 also has a number of new features added and, of course, some features removed...

In the union usage, the field types of the two SELECT statements match and the field types must be the same. FL_ID = 'FL_ID'; FL_ID = 'FL_ID'; FL_ID = 'FL_ID'; FL_ID = 'UNION'; FL_ID = 'FL_ID'; The UNION filters out duplicate entries after the join, so...

1. The database password is locked su -l oracle $source /home/oracle/.bash_profile $sqlplus/as sysdba

I recently installed DBeaver because so many people love it. Boy, it works. But from the first glance I opened it, I knew it was developed in Java, because every time I added a database type, I needed to download a corresponding JAR package. Good good, no more worrying about whether Navicat is pirated or not, and no more installing PL/SQL that can crash the system. With such development...

Once read "harvest, not just SQL tuning" book, this book is a very good tuning type of book written by domestic DBA, is some very good tuning experience to share. Although I read it again and took notes on the book, I feel that I have gained something, but I still feel that I lack practice in practical practice. Just recently, there was a training event for SQL tuning. After attending it, I reviewed the Oracle execution plan again.

By default, the number of Oracle database connections is 150. If the Oracle database is used for production, it may be sufficient for a period of time when the initial services are small, but may not be enough when the later services are large...

Remember a few years ago, oracle database installation package downloaded from the Internet was injected with a virus, running after a year of automatic deletion database, a year of data ah......

The password of the database user is correct. Why is the password invalid displayed on the client? In the database to change the password again, why the message is invalid? See if the user you are connecting to is sys...

On March 21, Oracle announced the official release of Java 10. This is the first official release of Java after the big release cycle (see here), and it's worth noting. You can download it immediately by clicking on the address below

Modify PL/SQL Developer connection information Login tool PL/SQL Developer Run commands for example: Summary: How do I delete all data of a user in Oracle?