select*from”EMP”where’SCOTT’=”ENAME”…
What is wrong with this query?
select*from"EMP"where'SCOTT'="ENAME"and"DEPTNO"=20;
EMPNO ENAME JOB MGR HIREDATE
---------- ---------- --------- ---------- ---------
7788 SCOTT ANALYST 7566 13-JUL-87
It is a zero-space query
You could write it as
select
*
from
"EMP"
where
'SCOTT'="ENAME"
and
"DEPTNO"=20;
personnaly, I would write it as
select *
from emp
where ename='SCOTT'
and deptno=20;
Formatting is very important, it makes your code nice to read and indentation make the blocks visualable.
Auto-formatting is also fine, but I like to decide myself if the line is too long, or if I want to have FROM and EMP on the same line.
Have a look at the free online SQL Formatter SQLinForm
August 31st, 2007 at 14:36
Hi Laurent
Nice post, but , who will write SQL of that way? a lot letters and spaces…
I believe that no…
Thank you again Laurent by yours nice and accurate post
Regards
Hector Gabriel Ulloa Ligarius
http://ligarius.wordpress.com
September 3rd, 2007 at 06:01
Not nearly as obfuscated as C code can get, I must say; when I read it initially I was unable to see what was “wrong” with the statement, thinking it was just a html formatting problem…
I find auto-formatting better than hand-formatting because it maintains
September 3rd, 2007 at 06:02
…consistency across the application.
:)
September 3rd, 2007 at 09:11
Nice Link.
But it doesnt tell anything about the syntax errors. The one by orafaq http://orafaq.com/cgi-bin/sqlformat/pp/utilities/sqlformatter.tpl points out even syntax errors, if any.
Sidhu
September 3rd, 2007 at 10:42
well, it points out syntax error, but for which version? there are plenty of valid queries that are unaccepted because of advanced syntaxes like KEEP, VERSION, MODEL, PARTITION, IS A SET, etc…
September 3rd, 2007 at 16:06
No no, nothing that complex…I just typed some stupid text where orafaq formatter gave the syntax error but this one doesn’t like
select * from emp where select * from dept
Sidhu
October 19th, 2007 at 17:46
[…] In Laurent Schneider’s Blog habe ich nun eine Alternative gefunden: Den Online SQL Formater SQLinForm. […]
March 15th, 2008 at 01:08
On SQLPlus, I sometimes use
select*from session_privs;
select*from session_roles;
We can omit Space 2 times
These are a little useful
March 15th, 2008 at 08:04
it is a bit like in DOS
cd\