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 8-)

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

11 thoughts on “select*from”EMP”where’SCOTT’=”ENAME”…”

  1. 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

  2. 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

  3. 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…

  4. 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

  5. On SQLPlus, I sometimes use
    select*from session_privs;
    select*from session_roles;

    We can omit Space 2 times 8-)
    These are a little useful ;-)

  6. select ename,deptno,sal from emp e
    where 2>(select count(m.sal) from emp m where e.deptno=m.deptno and e.sal<m.sal
    please
    how can it execute the process kindly tell the answers…

Leave a Reply

Your email address will not be published.


*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>