Help us understand the problem. What is going on with this article?

オラクルマスターブロンズ12cまとめ

More than 1 year has passed since last update.

はじめに

オラクルマスターブロンズを取るために学習中
SQLは全くの素人なので、それぞれの式とかコマンド?とか変数がどう動くかおさらいしながらまとめます。

distinct

重複業の削除
フィールド名が複数あった場合は、それらを組み合わせて一意になるように重複行を省いて表示する。

distinct
select
distinct フィールド名[,フィールド名,・・・]
from テーブル名;

SQL関数

upper

アッパー。
引数に渡したものを全部大文字にする。

lower

ロウアー。
引数に渡したものを全部小文字にする。

initcap

イニットキャップ
引数に渡したものを頭文字大文字、ほか小文字と、いい感じに成型する。

select upper(last_name),lower(last_name),initcap(last_name)
from hoge;

upper(last_name),lower(last_name),initcap(last_name)
---------------- ---------------- ------------------
AUSTIN           austin           Austin
GRANT            grant            Grant

tkzm50
都内でSEをしていまス。 GWRE CC Education IntegrationTrainer. Education ConfigurationSpecialist.
https://powerplaylabo.hatenablog.jp/
Why not register and get more from Qiita?
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
Comments
No comments
Sign up for free and join this conversation.
If you already have a Qiita account
Why do not you register as a user and use Qiita more conveniently?
You need to log in to use this function. Qiita can be used more conveniently after logging in.
You seem to be reading articles frequently this month. Qiita can be used more conveniently after logging in.
  1. We will deliver articles that match you
    By following users and tags, you can catch up information on technical fields that you are interested in as a whole
  2. you can read useful information later efficiently
    By "stocking" the articles you like, you can search right away
ユーザーは見つかりませんでした