How can you tell the distances by road between the settlements of Ten Towns in Icewind Dale?

I’ve read through Chapter 1 of Icewind Dale: Rime of the Frostmaiden and have not found any guidance on how to judge distances and travel times between the settlements of Ten Towns.

Other than a good old fashion ruler compared to the map scale, is there a quick way to determine the distances between the settlements of Ten Towns?

Ensuring relationship between child tables exists prior to SQL insert

I have a situation where I have three tables: user, assignment and test. A user must have completed an assignment before he can take the test. This means the test table has both both a user foreign key and an assignment foreign key on it.

I could write a sql statement like this: insert into test (name, user_id, assignment_id) values ("final exam", 1, 1) which would check to see if the user and assignment exist before doing the insert. However it would not check to see if the user and assignment were related.

The easy way to solve this problem is to do a separate query before the insert to ensure the user has an assignment. I’m wondering if I can accomplish both in one query though. I’m not all that experienced with constraints or subqueries, both of which could be solutions. Looking for a best practice here as it will be used throughout an application.

What’s the difference between Row Polymorphism and Structural Typing?

The definitions I’ve stumbled across seem to indicate they express the same idea. That’s that the relationship between record types is determined by their fields (or properties) rather than their names. Their Wikipedia pages also seem to indicate the same idea:

A structural type system (or property-based type system) is a major class of type system in which type compatibility and equivalence are determined by the type’s actual structure or definition and not by other characteristics such as its name or place of declaration.

In programming language type theory, row polymorphism is a kind of polymorphism that allows one to write programs that are polymorphic on record field types (also known as rows, hence row polymorphism).

Are there any differences between them?

What is the broad overview of the differences between Wizard and Sorceror in D&D 5e?

What are the differences between Wizards and Sorcerers in D&D 5e, in broad overview terms?

Really, I’d like to know this from two perspectives. One I have a somewhat idea about from reading the PHB and other websites, one I don’t get at all.

  1. What are the differences in the two classes from a character building background in terms of story and roleplaying? This is the part I don’t have any clue about.

  2. What are the differences from a mechanical standpoint? I understand Sorcerers get spells a bit quicker and it looks like Wizards have to buy their spells but I’m really not too clear on this either.


I’ve already read a few articles and watched a few videos but still don’t know the answer. I especially don’t know the answer to the character building / roleplaying side as most of what I did find just talks about which one is more powerful. These are the resources I’ve looked at thus far (not including the Player’s Handbook which I’ve read over and over now):

  • Why did the sorcerer/wizard spell lists diverge in D&D 5e?
  • Which spells do Wizards get at lower levels than Sorcerers?
  • Sorcerer vs. Wizard: Clearing Up the Choice 5e
  • Sorcerer vs. Wizard: Anything You Can Do I Can Do Better?
  • Nerdarchy’s YouTube Channel: Wizards Vs Sorcerer| Dungeons and Dragons 5th Edition Classes

What’s the difference between a jelly, a pudding, and other oozes?

Several types of named oozes exist in 5th edition, but the naming conventions are strange. Black puddings and ochre jellies exist, alongside simple grey oozes. Do these names signify anything? Obviously the color portion signifies the color of the ooze, but the second halves of the names are more ambiguous.

Since my searches within 5th edition have turned up nothing, previous editions’ lore is welcome.

Problem using ‘Regular expression’ in order to split characters of a column when there is no delimiter between them

I have a table with below structure:

create table TBL_TEST (   col_id   NUMBER,   col_name VARCHAR2(500) ) 

Some example data :

col_id | col_name    -----------------   1    | aetnap           2    | elppa          3    | ananab        

What I need to do is to split characters of column col_name for each col_id for example for col_id=1 we must have :

col_id | col_name    -----------------   1    | a   1    | e   1    | t   1    | n   1    | a   1    | p 

this query is fine when there is only one record in the table :

SELECT col_id, REGEXP_SUBSTR(col_name, '[a-z]{1}', 1, LEVEL) AS VAL   FROM tbl_test t CONNECT BY REGEXP_SUBSTR(col_name, '[a-z]{1}', 1, LEVEL) is not null 

but as soon as I insert another record in the table (say col_id=2 and col_id=3) I can not have the desired result. I want to know two things:

  1. Why is this query works fine for one record and it does not for more ?
  2. what is the best way to split the characters when there is no delimiter between them?

Thanks in advance