How to Oracle - en

Szukaj na tym blogu

Unit Tests

Pobierz link
Facebook
Twitter
Pinterest
E-mail
Inne aplikacje

utPLSQL - insallation

Pobierz link
Facebook
Twitter
Pinterest
E-mail
Inne aplikacje

Komentarze

Prześlij komentarz

Popularne posty

How to check if a row is a continuation of the previous one - part 2.

Some time ago, in 2019, I wrote a post with a query that solved a quite common problem - how to recognize in an SQL query whether rows in a table are a continuation of the previous row. What is it actually about? For example, let's look at an employee with employee_id = 101 and check his employment history (all examples use the HR scheme). SELECT * FROM hr.job_history WHERE employee_id in (101) ; EMPLOYEE_ID START_DA END_DATE JOB_ID DEPARTMENT_ID ----------- -------- -------- ---------- ------------- 101 97/09/21 01/10/27 AC_ACCOUNT 110 101 01/10/28 05/03/15 AC_MGR 110 In 2001 Ms. Kochhar changed her position from AC_ACCOUNT to AC_MGR. Nevertheless, she was still employed. We would like to find the dates of employment of employees from - to, regardless of whether they changed positions or departments in the meantime or not. In 2019, I proposed a way, on an older version of Oracle, how to solve this problem using analytical

How to unlock HR schema? [XE]

Unlocking sample HR scheme in versions older than Oracle 12c was very easy. Just execute from the SYS user: alter user hr identified by hr account unlock; And done! - HR scheme ready to go. In 12c, when the containers came in, things got complicated: alter user hr identified by hr account unlock; Error report - ORA-01918: user 'HR' does not exist 01918. 00000 - "user '%s' does not exist" *Cause: User does not exist in the system. *Action: Verify the user name is correct. But I know, that HR is out there somewhere... When we log as SYS user, we log into the CDB database. And there is actually no HR schema. The HR schema has been hidden in the pluggable database. To be able to unblock the HR user, we need to connect to the PDB (pluggable) base. How to do that? 1. Find PDB name as a SYS user execute the SQL SELECT name, con_id, open_mode FROM v$pdbs; Out PDB base is XEPDB1 . 2. Update tnsnames.ora file We need to add our

How to install utPLSQL on Oracle 23ai

utPLSQL is one of the best tools for performing unit tests on applications built on Oracle databases. Today, I want to check if the tool's installation will go smoothly on the latest Oracle 23ai Release. -------------------------------------------------------------------------------- 'Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free' -------------------------------------------------------------------------------- The following instructions will guide us step by step through the installation of utPLSQL. DOWNLOADING THE INSTALLATION FILE You can download the installation file from GitHub. The latest version of the tool can be found at https://github.com/utPLSQL/utPLSQL/releases . Download the utPLSQL.zip file and extract it to your chosen location on the disk. Open CMD and change directory to SOURCE > Cd C : \ _monika \ utPLSQL \ source Next, log in to the database XEPDB1 using SQL*Plus as the SYS user with SYSDBA privileges: >s

Obsługiwane przez usługę Blogger