Here are some more useful SQL tricks, tested on an Oracle database. Tips on building a test table and inserting values automatically, data types, insert/update with the check option and more.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help