Skip to content

Category Archives: Oracle

Use default parameter/setting (row) if not set specific for entity

The other day I was asked about the following: “We have a table VARIABLE and Variable entity. A new requirement is to restrict availability of a limited number of these entities to chosen customers.” I replied: “The volumes?” And the response was: “Quite low – now around 70 rows, it might slightly exceed 100 in […]

Posted 19 May 2022 † Lasse Jenssen § ‡ Comments (0) °

SQL Developer, Database Copy and TRUNCATING unwanted tables

I just experienced something scary with SQL Developer and the “Database Copy” utility. One table in production was truncated by a mistake. I have always been a little against using the SQL Developer functionality “Database Copy …” in production, but for this one task during deployment of a new release, this customer (including me) have […]

Posted 05 April 2022 † Lasse Jenssen § DBA § SQL Developer ‡ Comments (0) °

Copy schema with data pump when using editions

We have just been through a relatively tricky situation, trying to copy our test schemas from our Oracle 12c database to the new Oracle 19c test database. We were trying to use data pump to copy the schemas. The copy was ordered from operation, and the schemas was exported and imported as ordered. Before importing  […]

Posted 18 November 2020 † Lasse Jenssen § ‡ Comments (0) °

The NUMBER datatype without precision

Lately I have seen projects using the NUMBER datatype for table columns without setting precision and scale. When I see this I always question “Is this intentional or did they just happen to forget to set the values?”. This is the problem with using implicit configuration/settings. You don’t really know if it was a mistake […]

Posted 15 July 2019 † Lasse Jenssen § SQL ‡ Comments (0) °

Redundant NOT NULLs in DDL

I often see DDLs with NOT NULL definitions which is really redundant. When I see such DDLs I really question “do the writer really know what he or she is doing”. They might not hurt you application, but why set them if they are redundant? (If you know I reason please comment) Example: CREATE TABLE […]

Posted 13 July 2019 † Lasse Jenssen § Database Design § Performance § SQL ‡ Comments (0) °

Java and JDBC for Oracle DBAs – Part 6: Spring-boot, JPA and Hibernate

In the last article we looked at Spring-boot and accessed the database using the JdbcTemplate class.Today we’ll rewrite the same application but by using JPA and Hibernate instead. The Spring Initializr web page have changed a little since the last time, so the first part will be a little different. Part 1: Install/setup Oracle database […]

Posted 18 March 2019 † Lasse Jenssen § ‡ Comments (0) °

PLSQL: Nice little overview of the PL/SQL language

I just came over these slides and nice little overview of the PL/SQL language by Morten Braten. The slides covers many good tips to follow when coding PL/SQL. It’s not ment to be an introduction to the PL/SQL language, so many topics are just mention briefly and would need to be followed by further reading and/or […]

Posted 14 September 2018 † Lasse Jenssen § PL/SQL ‡ Comments (0) °

Java and JDBC for Oracle DBAs – Part 5: Spring-Boot, JdbcTemplate & DB migration (Using FlywayDB)

Today we’ll be looking at Spring-boot and a tools which developers use to migrate databases, FlywayDB. We’ll also look at how you can automate grants towards our two roles (which we created in part 3) whenever new tables are created. Part 1: Install/setup Oracle database (in docker) Part 2: Installing Java (JDK), Eclipse and Maven […]

Posted 25 July 2018 † Lasse Jenssen § Java ‡ Comments (0) °