久しぶりにOracle PL/SQLをいじり中
なぜかSelect文でコンパイルエラー
SELECT A.Column1
FROM TableName AS A ← ここでエラー
悩むこと30分
SELECT A.Column1
FROM TableName A
でした
自分のあほさ加減に絶望した
ちなみにSQLServerでは
上の書き方でもOK
フィードバック
# re: [SQL]テーブル名の別名定義
2007/07/12 11:08 by
アホ……とは思わなかったりしますですよ。
OracleとSQLServer、まぁここにDB2が混じってきたとしても、大阪弁と関東弁と東北弁ぐらいに方言が違うし、ACCESSが入ってくるとさらに混乱の坩堝が待ってますし(^^;
標準SQLと方言SQLの違いって種類こなさないと見えてこないんですよね(遠い目)
# re: [SQL]テーブル名の別名定義
2007/07/12 11:17 by
SQLServerとAccessでも似たようなことやったりです。^^;
MySQLとかいろいろ使える語句が違うし、混乱しますよ。
# re: [SQL]テーブル名の別名定義
2007/07/12 11:30 by
ISAMをやっている私は、人間失格ですか?
って言った冗談はおいといて...
片桐さんもおっしゃっていますが、格DBのSQLの方言ですからね。
慣れていただくしかないですよね。
(Oracle10gってうまいのか?)
# re: [SQL]テーブル名の別名定義
2007/07/13 9:00 by
>片桐様
ありがとうございます。
DB2!!
一度は触ってみたいDBMSです。
忘れっぽい私は毎回方言違いで時間取られて困ってます^^;
>Zee様
ありがとうございます。
MySQLもありますねぇ。
これも触った事ないなぁ。
あとPostgreSQLもあるのか。
>HiJun
ありがとうございます。
ISAM!!!
聞いた事はありますが、実際見たことないです。
すごいです。
Oracle10gは今回初めて触ってますが、
DBAな方が、いろいろパラメーターが変わってて苦労されてます。
SQLServerの様に自動で管理するパラメーターが増えてきているとか。
各DBMSで使えるSQLの比較表とかあったら便利なのかな
作るとしたら逆引きっぽいのがいいかな?
# VqCJPwjhCBqwctUpe
2011/12/13 18:30 by
Right from this article begin to read this blog. Plus a subscriber:D
# dsihNrPLBrJXQENuz
2014/07/19 11:55 by
YPvP3h I really enjoy the article.Much thanks again. Keep writing.
# GmEcPXNoSfICaqrBP
2014/08/02 11:06 by
UxIdad Thanks so much for the blog article.Really looking forward to read more. Awesome.
# Great blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your design. Thanks
2021/09/03 18:46 by
Great blog! Is your theme custom made or did you download it from somewhere?
A design like yours with a few simple adjustements would really make my blog
stand out. Please let me know where you got your design.
Thanks
# Great blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your design. Thanks
2021/09/03 18:47 by
Great blog! Is your theme custom made or did you download it from somewhere?
A design like yours with a few simple adjustements would really make my blog
stand out. Please let me know where you got your design.
Thanks
# Great blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your design. Thanks
2021/09/03 18:48 by
Great blog! Is your theme custom made or did you download it from somewhere?
A design like yours with a few simple adjustements would really make my blog
stand out. Please let me know where you got your design.
Thanks
# Great blog! Is your theme custom made or did you download it from somewhere? A design like yours with a few simple adjustements would really make my blog stand out. Please let me know where you got your design. Thanks
2021/09/03 18:49 by
Great blog! Is your theme custom made or did you download it from somewhere?
A design like yours with a few simple adjustements would really make my blog
stand out. Please let me know where you got your design.
Thanks
# What's up, of course this post is in fact pleasant and I have learned lot of things from it concerning blogging. thanks. scoliosis surgery https://coub.com/stories/962966-scoliosis-surgery scoliosis surgery
2021/09/14 2:59 by
What's up, of course this post is in fact pleasant and I have learned lot of things from it
concerning blogging. thanks. scoliosis surgery
https://coub.com/stories/962966-scoliosis-surgery scoliosis surgery
# I enjoy what you guys are usually up too. This type of clever work and exposure! Keep up the superb works guys I've incorporated you guys to my blogroll. https://parttimejobshiredin30minutes.wildapricot.org/ part time jobs hired in 30 minutes
2021/10/22 22:40 by
I enjoy what you guys are usually up too. This type of clever work and exposure!
Keep up the superb works guys I've incorporated
you guys to my blogroll.
https://parttimejobshiredin30minutes.wildapricot.org/ part
time jobs hired in 30 minutes