topic Re: Difference between $( <command> ) and `<command>` in Operating System - HP-UX

Difference between $( ) and ``

Paul_212 — Fri, 11 Mar 2005 09:54:18 GMT

Hi all,

Since a POSIX course at HP I learned to write proper POSIX, so I always use $( ).
But today I tried to fill a variable with an SQL*PLUS query and came up with an issue.
With the following example I will try to explain the problem:

$export SQLDBA='sqlplus -s'
$echo $( ${SQLDBA} <<-EOF
/ as sysdba
set head off
select value from v\\$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
EOF )
sh: nls_parameters: Parameter not set.

echo ` ${SQLDBA} <<-EOF
/ as sysdba
set head off
select value from v\\$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
EOF `
AL32UTF8

I thought it wouldn't matter which method to use. Did I just find a crop circle?

I prefer to use the $( ) method, so can anyone explain this behaviour and tell me how to use $( )? In fact I want to fill a variable, so in my script the “echo” will be replaced by “VAR=”

Thanks in ad

Re: Difference between $( ) and ``

A. Clay Stephenson — Fri, 11 Mar 2005 11:02:11 GMT

I see tons of errors in your first example:
$export --> export
$echo ---> echo
heredocs <<-EOF but terminated by EOF
An extra backslash before $

This should be much closer to functional code:

export SQLDBA='sqlplus -s'
echo $( ${SQLDBA} <<-EOF
/ as sysdba
set head off;
select value from v\$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
-EOF
)

Re: Difference between $( ) and ``

c_51 — Fri, 11 Mar 2005 11:27:55 GMT

I'd say those extra $ are probably just command line prompts and for a heredoc
if <<- is used, leading tabs are ignored

as it looks like they are running this from the command line it would be interesting to know if the results are the same from a file.

Re: Difference between $( ) and ``

Victor BERRIDGE — Fri, 11 Mar 2005 11:28:54 GMT

Hi Paul,
I cant find my docs...but your issue is with encapsulated variables (variable of (variable...))
not very posix...
I remembered going through such cases and the way out is using eval...
now an elegant way would be:
alias sq='sqlplus -s'
export SQLDBA='sqlplus -s'
echo $( ${SQLDBA} <<-EOF
/ as sysdba
set head off;
select value from v\$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
-EOF
)

All the best
Victor

Re: Difference between $( ) and ``

Victor BERRIDGE — Fri, 11 Mar 2005 11:31:20 GMT

Sorry
alias sq='sqlplus -s'

echo $( ${sq} <<-EOF
/ as sysdba
set head off;
select value from v\$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
-EOF
)

Was what I wanted...

All the best
Victor

Re: Difference between $( ) and ``

A. Clay Stephenson — Fri, 11 Mar 2005 11:52:09 GMT

You are quite correct about the <<-EOF although my "standard" heredocs marker is always !EOF! because it stands out so well and there is no possible confusion of dashes and tildes on small fonts.

Re: Difference between $( ) and ``

Bill Hassell — Fri, 11 Mar 2005 14:09:32 GMT

The grave accent marks `` are deprecated (not recommended) in all the POSIX shell man pages (sh-posix, ksh, etc). $(...) are strongly recommended for two reasons:

1. `` is much too easily confused with '' so copying a script (by someone unfamiliar with the proper usage of grave accent marks) usually has a lot of errors, and

2. grave accent marks cannot be nested so you can't use the result of one process (command substitution) as a parameter to another process which is itself being used as a command substitution.

Re: Difference between $( ) and ``

Paul_212 — Fri, 11 Mar 2005 17:23:03 GMT

Hi guys,

Thanks all for the quick responses. I'm sorry for the leading '$'. That was only the prompt copied and pasted. Maybe that wasn't really handy...
The extra minus sign in my heredoc was indeed to ignore leading tabs.
The code is in a function in a script and will be used by another function (which is still in the pen).
If executed from a script (with the braces), an "l" (like ls with IFS=\040) of the current working is given, together with an ORA-902 ERROR.

Like I asked before: Why does the POSIX method act differently (thus incorrect) than the Bourne method while using the identical syntax??

The issue isn't really the heredocs or the aliases, but the fact that using a dollar {$} and quotes {'} make that POSIX doesn't work and Bourne is successful?

The actual code is:
# make this one global, it will be used more often
export SQLDBA='sqlplus -s'

function f_get_charset
{
CHARSET=$(
${SQLDBA} <<-EOF
/ as sysdba
set head off
select value from v\\$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
EOF
)
# End of f_get_charset
}

Any suggestions? I really want to use POSIX, because I like (good) standards and don't want to let my scripts getting messy.

Thanks in advance!

Re: Difference between $( ) and ``

c_51 — Fri, 11 Mar 2005 19:27:39 GMT

the $() method you need to use v\$nls_parameters (only one backslash)

the `` method you need to use v\\$nls_parameters (two backslashes)

why?
from the man page:
Command Substitution
The standard output from a command enclosed in parenthesis preceded by a dollar sign ($(...)) or a pair of grave accents (`...`) can be used as part or all of a word; trailing newlines are removed. In the second (archaic) form, the string between the accents is processed for special quoting characters before the command is executed. See the "Quoting" subsection.

Inside grave accent marks (`...`), \ quotes the characters \, `, and $.

as an example try this

echo "$(cat <<-ABC
from v\$nls_parameters
ABC
)"
echo `cat <<-ABC
from v\\$nls_parameters
ABC
`

Re: Difference between $( ) and ``

renarios — Tue, 15 Mar 2005 04:49:32 GMT

Hi Paul,

I Tried with a "set -x" at the first line of the function (That's debug mode).
When I try your syntax, I found out that the single qoutes are changed into double quotes.
Look in the man-pages in the section "Quoting" for a solution.

Cheers,

Rene

Re: Difference between $( ) and ``

Paul_212 — Tue, 15 Mar 2005 05:53:00 GMT

Hi guys,

Thanks a lot! I realy helped me until I added the where clause. It turns out that command subsitution with parenthesis $() turns hard quoting '' into soft quoting "", which Oracle can't handle. I can't find the solution in the sh-posix man pages.
I added the relevan part of the script.

Anyone ideas?

Thanks in advance!

Re: Difference between $( ) and ``

Bob_Vance — Tue, 15 Mar 2005 08:08:50 GMT

Since you're not using any variables in your hereis doc, try just quoting the EOF:

<<-"EOF"
/ as sysdba
set head off
select value from v$nls_parameters where parameter = 'NLS_CHARACTERSET';
exit;
EOF

The quoted EOF prevents evaluation of $vars and preserves the single quotes.

hth
bv

Re: Difference between $( ) and ``

Paul_212 — Tue, 15 Mar 2005 08:30:20 GMT

Hi Bob,

Thanks for your reply.
Alas is that not the solution to my case.
My issue is not the $, but the '
Let me try to explain it with an example:

If I type the following:

echo $(cat <<-"EOF"
'NLS_CHARACTERSET'
EOF
)
The reply I'd like is:
'NLS_CHARACTERSET' (single-quoted)
The reply I get is:
"NLS_CHARACTERSET" (double-quoted)

If I use ` ` in stead of $( ), it works fine!
How can I work around this issue?

Many thanks ins advance!

Re: Difference between $( ) and ``

c_51 — Tue, 15 Mar 2005 09:40:27 GMT

not exactly a solution, but it is a work around. try:

a="'NLS_CHARACTERSET'"
echo "$(cat <<-EOF
$a
EOF
)"

Re: Difference between $( ) and ``

Paul_212 — Tue, 15 Mar 2005 09:55:15 GMT

Thanks! That's it!

Ten points, dix points, tien punten!

Re: Difference between $( ) and ``

Paul_212 — Tue, 15 Mar 2005 09:58:23 GMT

closing thread now.
Solution is:

SQLDBA="sqlplus -s" # Use "silent" SQL*PLUS
function f_get_charset
{
par="'NLS_CHARACTERSET'"
CHARSET=$(${SQLDBA} <<-EOF
/ as sysdba
set head off
select value
from v\$nls_parameters
where parameter = $par;
exit;
EOF )
echo charset=${CHARSET}
}
f_get_charset