Oracle create database link example

The syntax for the create database link command is pretty much impossible to figure out. I always get it wrong. Even when I read the docs carefully. So here's my version of the example.

CREATE DATABASE LINK
    name_of_link
  CONNECT TO
    oracle_username
  IDENTIFIED BY
    password -- no quotes here
  USING
    'database_sid' -- single quotes here
/
-- test
select * from dual@name_of_link
/