Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with oracle-sql-developer
Search options not deleted
user 129930
Oracle SQL Developer is a free tool for SQL & PL/SQL development and reporting similar to Quest's Toad or Allround Automations' PL/SQL Developer.
0
votes
Accepted
Concatenating only desirable values with LISTAGG
So, to achieve the desired output the initial query was split into two, for selecting "CONSTRYEAR" and "RECONSTRYEAR" separately.
For the "CONSTRUCT":
SELECT YEARS.FID,
MIN(YEARS.BJA) CONSTRUCT …
- 177
0
votes
2
answers
57
views
Converting string with DIN 1421 pattern to human-readable
In the Oracle DB there is a table that stores "DIN"s attribute (VARCHAR2(1200 BYTE)), see a table/image below.
Each string follows the DIN 1421 pattern.
+------------------+
| DIN |
+---- …
- 177
0
votes
Converting string with DIN 1421 pattern to human-readable
I does not work yet for 0004.00.01.00.00.
The query that I have in mind:
with d as
(
select '0004.01.03.00.00' data from dual union all
select '0006.06.00.00.00' data from dual union all
select '0002 …
- 177
3
votes
4
answers
1k
views
Concatenating only desirable values with LISTAGG
In the Oracle DB there is a table with data "YEARS", see a table/image below
+-----+-----------+------------------+
| FID | I0 | BJA |
+-----+-----------+------------------+
| 1 …
- 177
2
votes
3
answers
138
views
Ordering streets by their names and polysyllabic numbers in SQL query
In Oracle DB there is a table with some data:
LAG
HNR
STREET
00020
44
Aachener Straße
00020
44/2
Aachener Straße
00020
44/1
Aachener Straße
00020
46
Aachener Straße
00020
46/6
Aachener …
- 177