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_na…


This content originally appeared on DEV Community and was authored by Sydney Abuya

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"


This content originally appeared on DEV Community and was authored by Sydney Abuya


Print Share Comment Cite Upload Translate Updates
APA

Sydney Abuya | Sciencx (2024-07-07T09:08:24+00:00) SQL Oracle. Retrieved from https://www.scien.cx/2024/07/07/sql-oracle/

MLA
" » SQL Oracle." Sydney Abuya | Sciencx - Sunday July 7, 2024, https://www.scien.cx/2024/07/07/sql-oracle/
HARVARD
Sydney Abuya | Sciencx Sunday July 7, 2024 » SQL Oracle., viewed ,<https://www.scien.cx/2024/07/07/sql-oracle/>
VANCOUVER
Sydney Abuya | Sciencx - » SQL Oracle. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2024/07/07/sql-oracle/
CHICAGO
" » SQL Oracle." Sydney Abuya | Sciencx - Accessed . https://www.scien.cx/2024/07/07/sql-oracle/
IEEE
" » SQL Oracle." Sydney Abuya | Sciencx [Online]. Available: https://www.scien.cx/2024/07/07/sql-oracle/. [Accessed: ]
rf:citation
» SQL Oracle | Sydney Abuya | Sciencx | https://www.scien.cx/2024/07/07/sql-oracle/ |

Please log in to upload a file.



There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.

Related Posts