Moment For Technology

Java11 is out, making your code better?

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...

Union (all)

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...

DBeaver, Deus ex!

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...

Oracle SQL Tuning series understand execution plan Explain

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.

Oracle error ORA - 00020

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...

Oracle error: ORA-01017

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...

Search
About
mo4tech.com (Moment For Technology) is a global community with thousands techies from across the global hang out!Passionate technologists, be it gadget freaks, tech enthusiasts, coders, technopreneurs, or CIOs, you would find them all here.