Просторы интернета
Compare the results of the following query with the clause “fetch first 2 rows only”
with t1(a) as (select * from table(odcinumberlist(1,3))) ,t2(a,b) as (select * from table(ku$_objnumpairlist( [...]Everyone knows that rownum in inline views blocks many query transformations, for example pushing/pulling predicates, scalar subquery unnesting, etc, and many people use it for such purposes as a workaround to avoid unwanted transformations(or even CBO bugs).
If we pull the [...]
Just short note: If your imported Oracle Linux image hangs on boot in the Oracle cloud, just set GRUB_DISABLE_UUID=”true” in /etc/default/grub
[...]Three interesting myths about rowlimiting clause vs rownum have recently been posted on our Russian forum:
TopN query with rownum “fetch first N rows only” is always faster than rownum “SORT ORDER BY STOPKEY” stores just N top records during sorting, while “WINDOW SORT PUSHED RANK” sorts all input and [...]Recently I had to install the patch for fixing cross-platform PDB transport bug onto the docker images with Oracle, so these are easy way how to do it:
1. create directory “patches” and create “install_patches.sh”:
#!/bin/bash unzip -u ./*.zip CURDIR=`pwd` for D in *; do if [ -d "${D}" ]; [...]
Pagination is the process of dividing query results (typically on a user interface) into discrete pages, where each page contains a smaller/more manageable number of rows. In classic offset pagination, each page shows a fixed count of rows [...]
Pagination is the process of dividing query results (typically on a user interface) into discrete pages, where each page contains a smaller/more manageable number of rows. In classic offset pagination, each page shows a fixed count of rows [...]
When we need to enforce uniqueness on a combination of table columns *only if* a certain condition is true, Oracle helps us implement this using a function-based index.
What is a Function-Based Index?A function-based index is created on the value of [...]
When we need to enforce uniqueness on a combination of table columns *only if* a certain condition is true, Oracle helps us implement this using a function-based index.
What is a Function-Based Index?A function-based index is created on the value of [...]
Some solution requirements are best addressed with Java code in the Oracle database. This article shows you use cases where Java methods in Oracle are useful, how Oracle lets you store Java methods and how they can be called from PL/SQL.
Java [...]Some solution requirements are best addressed with Java code in the Oracle database. This article shows you use cases where Java methods in Oracle are useful, how Oracle lets you store Java methods and how they can be called from SQL [...]
INNER JOIN
Inner join или просто join возвращает только те строки из двух таблиц, которые удовлетворяют условию указанному в ON:
SELECT
s.id,
s.supplier_name,
[...]
INNER JOIN
Inner join или просто join возвращает только те строки из двух таблиц, которые удовлетворяют условию указанному в ON:
SELECT
s.id,
s.supplier_name,
[...]
A typical scenario that involves splitting a comma-separated string into rows:
in a UI-driven query, the user would enter a list of IDs into an input box, and the application should retrieve details for the input list of IDsThe [...]
A typical scenario that involves splitting a comma-separated string into rows:
in a UI-driven query, the user would enter a list of IDs into an input box, and the application should retrieve details for the input list of IDsThe [...]
GUI tools like TOAD and SQL Developer are all fine, but those who have cut their teeth on SQL*Plus will not do without the good old command-line interface. And so, a message like the one below [...]
GUI tools like TOAD and SQL Developer are all fine, but those who have cut their teeth on SQL*Plus will not do without good old command-line interface. And so, a message like the one below makes [...]
When you have an enormous load of data to copy/merge from one table to another, you are probably concerned about:
Performance: How fast can the program copy/merge all the data? Exception handling: How well does the program deal with [...]