Three ways to get error message/stack in PL/SQL

Hi All

Today I speak about how manage errors in PLSQL.

This link speaks about three ways to manage errors in PLSQL, it's very clear and complete.

Basically, exists three forms to manage it :

• SQLERRM
• DBMS_UTILITY.FORMAT_ERROR_STACK
• UTL_CALL_STACK API (From Oracle 12c version)

I invite you to read the link for more details.

Stay tuned.

Objectives 2022

 Hi all

Today starts year 2022 below my new objectives, basically same of last years :

1. Improve My English Level

• Improve listening comprehension
• See at least a film in English
• Read at least a book in English
• Duolingo every day, return and remain in diamond league

2. Improve my Chess Level

• More Matches than 2020
• Improve my level  Actually is :

Diaries (Giornalieri) : 1150

Problems : 1437

V/S/N : 119/119/12

• Win one or more tournament

3. Improve my incomes

• Investments
• Saving
• Less expenses than 2021
• Another work 

4. Be a better Christian

• Same church activities (Timoteo, Banco Alimentare, Uscieri, Timoniere)
• Read the bible daily, at least 12 plans on MyVersion
• Speaks more about Christ to another people

5. Development

• Deploy one or more application on Google Play (Lineadd and/or CrashP)
• Release at least 5 new repositories on github (actually 1st January 2o22 are 27 repositories) 

6. Blog

• Write more posts on this blog (12 or more)

7. Fitness

• Under or equal to 77 kilograms (Actually 1st January 2o21 my weight is 77,1 Kg)
• Home fit (abdominal, ...)
• Jogging activities
• More than 3 Trekking activities

8. Courses

• At least 3 courses (Coursera, EDX, SoloLearn, HacherRank....)
• Improve my Frontend Knowledge (Express or Angular)
• Course Flatter / Dart

Stay tuned.

Year 2022 - Objectives 2021 Balance Time

 

Hi All

Before all, 2021 was another year with pandemy COVID virus.

Today first day of 2022 it's balance time, below my 2021 objectives.

1. Improve My English Level

• Improve listening comprehension (Little improvements)
• See at least a film in English (No)
• Read at least a book in English (No)
• Duolingo every day, reaching 1500 days and remain in diamond league (Yes) I finish 2021 with 1623 (Yes)

2. Improve my Chess Level

• More Matches than 2020 (So and So, more matches but also more defeats)
• Win one or more tournament (No)

3. Improve my incomes

• Investments (No)
• Saving (No)
• Less expenses than 2020 (Yes)
• Another work (No)

4. Be a better Christian

• More church activities (Yes - Timoteo School)
• Read the bible daily, at least 12 plans on MyVersion (Yes - I read all Bible and 20 plans completled)
• Speaks more about Christ to another people (So and So)

5. Development

• Deploy one or more application in Google Play (Lineadd and/or CrashP) (No)
• Release at least 5 new repositories on github (actually 1st January 2o21 are 24 repositories) (So and So released only 3 repositories more)

6. Blog

• Write more posts on this blog (12 or more) (No only 8 posts)

7. Fitness

• Under or equal to 80 kilograms (Actually 1st January 2o22 my weight is 77,1 Kg)
• Home fit (abdominal, ...) (Yes)
• Jogging activities (No)
• More than 3 Trekking activities (Only 1)

8. Courses

• At least 3 courses (Coursera, EDX, SoloLearn, HacherRank....) (Yes)
• Improve my Frontend Knowledge (Node.js or Angular) (Yes Node)

9. Book

• Release at least one book in wattpad (No)

The 2021 balance was :

OK 8 over 23 : 34,8%

KO 11 over 23 :  47,8%

SO AND SO 4 over 23 : 17,4%

It's not a very good result but better than 2021.

My best 2021 areas were : "Be a better Christian" 2 over 3, "Courses" 2 over 2 reached and Fitness Area 2 over 4 (most important my weight)

Stay tuned.

Another beautiful Visualcode extension

Hi all

I found another interesting extension for my favorite editor.

In my last post My extensions for Visual Studio Code, I spoke about the best extensions I use actually in Visual Code Editor.

Today i want speak about another interesting extension, a csv editor.

Who like me needs to work on csv files and needs to modify them, can use this fantastic extension.

Exist a online version too on https://edit-csv.net/.

The repository in on github and you can install it on Visual Studio Code.

Stay tuned.

My extensions for Visual Studio Code

 Hi all

In my opinion Visual Studio Code is actually one of the best free editor.  

This editor developed by Microsoft have many extensions and it is light and fast, I am using it daily for work and personal development.

Actually I am coding in Java, Javascript, CSS, HTML, awk, C, C++, PLSQL, SQL, and Python.

While I write this post my current Visual Studio Code version is 1.58.0 and my favorite extensions are :

• VIM : Vim emulation for Visual Studio Code

        I am a Vi lover so I need this extension to improve the editor with vi                      powerful commands.

• SFTP by LIXOMO 

    

        This is one of the best sftp extensions presents in Marketplace, very useful,             permits to configure more remote connection by JSON file.

• BEAUTY by yhpnora

        This extension permits to beautify code and actually supports javascript, 

        css, python, html, ...    

  

• DIFF TOOL by Jinsihou

        This useful extension permits to compare two files, is one of the best                       extension of this type on marketplace.

 These four extensions are for me very necessary to develop my work and              recommend use them to everyone.

Stay tuned.

    

How to think like a programmer

 Hi all

Today I want share a very interesting article about "Problem Solving".

How to think like a programmer — lessons in problem solving

These article was posted on FreeCodeCamp site.

I am completely agreed with it, and resume the three points in problem solution method :

• Understand
• Plan
• Divide

If you don't understand a problem probably you can't solve it. If you don't have a plan to solve a problem never you solve it. Divide a problem in more little problems can help you to solve it quickly.

Before closing this post I want to report this beautiful sentence :

“If you can’t explain something in simple terms, you don’t understand it.” — Richard Feynman

Stay tuned.

With Simpler is simple to learn english

 Hi all

Today I want talk about a very good application :

Simpler 

I subscribe for $23.00 a Premium subscription.

How is write on site, Simpler include :

★ The KNOW-HOW: learning English grammar with visual rules

★ AN UNUSUAL PRACTICE! "Detective Stories" written in English adapted to consolidate your knowledge

★ Memorize new words through ASSOCIATIONS

★ New SIMULATORS to consolidate knowledge

★ PRACTICE of listening comprehension

★ Regular CHECKPOINTS to assess knowledge and fill in gaps

★ Daily and free TRUNKS with new useful words

★ Ability to learn English for FREE

I recommend this app to learn and improve your english level.

Stay tuned.