DEV Community

Sydney Abuya
Sydney Abuya

Posted on

1

SQL Oracle

Use of distint

  • Before the 1st column name
  • avoids duplicate data in column
  • can not be used twice on one table

Use of q and [], ()

  • words in side having

Select from dual;

  • an unexisting table that can be used

Column aliases

  • eg select first_name name;
  • select first_name as name;
  • select first_name AS name;

Concatenation using ||

  • select first_name || ' ' || last_name as "full name"

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more