Loading collection data...
Collections are a way for you to organize kata so that you can create your own training routines. Every collection you create is public and automatically sharable with other warriors. After you have added a few kata to a collection you and others can train on the kata contained within the collection.
Get started now by creating a new collection.
If you look to the right of SQL it announces it's using PostgreSQL's "PL/SQL", not Oracle's (I was going crazy till I noticed).
I have no idea yet of PostgreSQL but I found this:
https://www.postgresqltutorial.com/dollar-quoted-string-constants/
Using dollar-quoted string constant in anonymous blocks
The code in the block must be surrounded by single quotes (...)
To avoid escaping every single quotes and backslashes, you can use the dollar-quoted string (...)
Same applies to our case: "Using dollar-quoted string constants in functions"
This comment is hidden because it contains spoiler information about the solution
This comment is hidden because it contains spoiler information about the solution
also, you are supposed to write a select statement, yes.
I'm sorry, but I don't know enough SQL to help.
Maybe someone else better at sql can answer?
So this was actually a test in finding out how to create a function in another version of sql (pl/sql) Though another person's comment told me exactly where to go get the code for this function. I suggest just plain old MS-SQL for this. What the heck is $$ anyway?
This comment is hidden because it contains spoiler information about the solution