var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Concatenate with a space in between fields
Could someone kindly help me
I am using SQL developer and I am trying to concatenate 2 fields together with a space in between so I can return the following results:
I have written the following, and get the subsequent results
SESSION_START || '' ||INTO_RECOVERY AS CHECKING
"invalid number of arguments"
Can someone help me with the correct syntex to use?
A "space" should be a "space", not an empty string:
In other words:
SQL> select ename || ' '|| job from emp;
See the difference?
YES: || ' ' ||
NO : || '' ||
I definately see the difference now..Gosh, how stupid was I
An objection, if I may: learn how to use
code tags. They will preserve formatting and make your code easier to read (see the difference between your code and mine?). Mistakes - just like the one you made - are much easier to spot when a code is formatted.