LOB string splitter with ordinals in SQL Server 2016 2
sql-server-2016
Paul White Paul White
6 This inline TVF converts the input string to JSON array format, then uses default `OPENJSON`.
Paul White
SQL Server LOB variables and memory usage
sql-server
Paul White Paul White
5 The 2GB LOB limit only applies to *persistent storage*; variables have no limit.
Paul White
How to select data from postgresql? 2
kus kus
3 The db<>fiddle search string (`like concat('%','kqus','%')`)is in lowercase and the elephantsql search is in uppercase (`like concat('%','KQUS','%')`), matching the data in the table.
Jack Douglas
Use db<>fiddle Oracle schema name in metadata table 1
dbfiddle oracle-18c
User 1791 User 1791
4 You can just use `sys_context` to get the schema name dynamically:
Jack Douglas
Query a Normalised Table Twice Without Using an Alias 3
sql-server-2019
John K N John K N
8 Not using an alias is a strange requirement, but *technically* yes.
Paul White
Return a value/row when selecting SDO_GEOMETRY 1
Meta
dbfiddle
User 1791 User 1791
1 Probably not, but you can modify your SQL to use `sdo_util.to_wktgeometry`
Jack Douglas
db<>fiddle Feedback 542 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
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.