Query a Normalised Table Twice Without Using an Alias 2
sql-server-2019
John K N John K N
6 Not using an alias is a strange requirement, but *technically* yes.
Paul White
Return a value/row when selecting SDO_GEOMETRY 1
Meta
User 1791 User 1791
1 Probably not, but you can modify your SQL to use `sdo_util.to_wktgeometry`
Jack Douglas
db<>fiddle Feedback 516 6
Meta
dbfiddle
Jack Douglas Jack Douglas
9 `feature-request` **Concurrency Support**
PeterVandivier
6 I have several links to db&lt;&gt;fiddle for demos in the following post:
Solomon Rutzky
5 The "ff" ligature destroys the cursor position. See GIF below:
fiatjaf
4 `bug` `fixed` Brittle fiddle one-boxing in chat
PeterVandivier
4 `bug` `fixed` YYYY-MM-DD for SQL Server
PeterVandivier
4 `bug` `fixed` Embedded fiddles should respect `&hide=` args
PeterVandivier
4 `feature-request` please add an (opt-in) cookie to remember the last platform a user was on?
PeterVandivier
4 `bug` clicking 'Back' should switch back not only the query, but also the database selection.
Ami
3 `feature-request` please add CockroachDB
PeterVandivier
2 `bug` `fixed` All-null rows collapsing in embedded fiddles
PeterVandivier
2 `feature-request` `declined` add an 'Update this post' button on embedded db<>fiddles on TopAnswers
PeterVandivier
2 `feature-request` `retracted` Add support for SQL Server `GO [count]` syntax
John K N
2 `bug` `fixed`: Firebird, datatypes, aligning
Arioch
0 `feature-request` sa/postgres/root - superuser fiddles
PeterVandivier
0 `feature-request` [`declined`](https://topanswers.xyz/transcript?room=37&id=17302#c17302) Allow multiple statements per batch for Firebird again
Arioch
SHOW WARNINGS; 2
dbfiddle
Anonymous 2333 Anonymous 2333
Oracle support on dbfiddle doesn't allow multiple statements in one batch
dbfiddle oracle
Anonymous 2328 Anonymous 2328
10 The [OCI](https://www.oracle.com/uk/database/technologies/appdev/oci.html) ("Oracle Call Interface" - their own API) doesn't support running multiple statements in a single batch.
Jack Douglas
How to extract fields of anonymous row type in PostgreSQL 2
postgresql
Tom Ellis Tom Ellis
5 [New in v13](https://www.postgresql.org/docs/13/release-13.html#:~:text=Allow%20ROW%20expressions%20to%20have%20their%20members%20extracted%20with%20suffix%20notation)
PeterVandivier
How can I constrain a v4 UUID?
mysql-8.0
Jack Douglas Jack Douglas
3 Use `binary(16)` with a check constraint that checks the 6 identifying bits for v4 UUIDs are set correctly.
Jack Douglas
Request: update font-awesome version 1
Meta
dbfiddle
Anonymous 2311 Anonymous 2311
3 I've replaced Font Awesome with raw SVGs from Fork Awesome.
Jack Douglas
Missing results for SELECT queries after SELECT * FROM set-returning function with nested row tpe 6
dbfiddle
Erwin Brandstetter Erwin Brandstetter
3 I've managed to find a test case that doesn't use a function at all:
Jack Douglas
Safeguard against infinite looping in case of missing FETCH NEXT
sql-server
Elaskanator Elaskanator
2 To avoid problems like this I'm using different pattern for fetch:
Piotr
chat
transcript

Enter question or answer id or url (and optionally further answer ids/urls from the same question) from

Separate each id/url with a space. No need to list your own answers; they will be imported automatically.