Przejdź do głównej zawartości

How to Oracle - en

How to Oracle - en

Szukaj na tym blogu

Programming

Pobierz link
Facebook
X
Pinterest
E-mail
Inne aplikacje

Null -sentenced to full scan?
Loading data - SQL
Loading data - SQL: is there any error? [GTT, tab]
Loading data - SQL: is there any error? [var]
How to make bubbles or homemade ORDER BY
How many indexes you have - indexes and performance.

How to convert a list to a table?

Are you affraid of commit?

OraGP: translate vs. regepxp_replace

It won't be faster, how (not) to use bulk collect.

Winning with complexity - naming variables

Same SQL - different execution plan?

Nulls:the sneaki little devils. Do you know then well?

Best practices more important than ever – IF [NOT] EXISTS

SQL Developer for VS Code - 3 and 1/2 tricks that will make you love your editor (a little bit more)

Pobierz link
Facebook
X
Pinterest
E-mail
Inne aplikacje

Komentarze

Prześlij komentarz

Popularne posty

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. Login as SYS user sqlplus sys/sys as sysdba 2. Connect to container XEPDB1 As a SYS connect to XEPDB1 ALTER SESSION SET container= XEPDB1 ; 3. Unlock HR schema An...

The Magical NVL Function

A while ago, I came across an interesting NVL trick on Connor Mc'Donald's blog . In his example, he compares a query that uses an optional parameter :p select * from tab where ( X = :P or :P is null) with a similar approach using the NVL function. select * from tab where X = NVL(:P,X) NOTE: The two queries above behave the same only if column X is NOT NULL . Both queries take an optional parameter :p . If :p has a value, only the rows where X = :p will be returned. If :p is left as NULL , all rows in the table will come back (because WHERE X = X ). I found this example intriguing enough to explore it myself. To make things even more interesting, I’ll also include a comparison using the COALESCE function. DEMO DB: Schemat : HR Wersja : Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production QUERY USING A LOGICAL "OR" This query looks for an employee in the EMPLOYEES table based on the :nEmpId parameter. If :nEmpId is NULL , it will simply...

Who Shook Up the World of PL/SQL Testing? A Conversation with Jacek Gębal

A new PWOW webinar is approaching, focusing on a topic often—unfairly—neglected: Unit Testing . 🧪 The key to success isn't just writing ad hoc tests, but their REUSE . During this session, you will learn how to design a testing process within your development cycle and which tools to use to achieve the best results with minimal effort. In connection with the upcoming webinar, we have a special treat for you – an interview with the creator of the utPLSQL tool, Jacek Gębal: Who Shook Up the World of PL/SQL Testing? A Conversation with Jacek Gębal. Meet the man who brought order to the chaos of database code. While the original foundation of utPLSQL was first laid by the legendary Steven Feuerstein , the framework has since undergone a modern transformation. Today, Jacek Gębal stands as the lead architect and driving force behind its evolution, helping Oracle developers trade manual "hope-it-works" testing for professional automation. Check out the fram...

Obsługiwane przez usługę Blogger