$ sqlplus.exe "/ as sysdba"
SQL*Plus: Release 9.2.0.1.0 [...]
SQL> select value from v$parameter where name='user_dump_dest';
VALUE
-------------------------------------------------------------
C:\oracle\admin\TUA7\udump
But if I put the result in variable :
Code:
$ ret=`sqlplus.exe -s "/ as sysdba" <<_eof_
set pagesize 0 linesize 200 feedback off
select value from v\\\$parameter where name='user_dump_dest';
_eof_`
$ echo $ret
C:\oracledmin\TUA7\udump$
The result is truncated ("\a" lost) and prompt appears at the end of line
Hey guys,
Any chance of getting a thread under 'Special Interest Topics' for Interix/SFU? This has to be one of the most poorly documented pieces of software floating around and it works great for interoperability of windows systems with the rest of your unix/linux network rather than having to... (3 Replies)
Just installed SFU in my PC running under Windows XP Pro. Could someone tell us how to change directory and to its subdirectories either by Korn Shell or C Shell?
I tried, cd f:\ or chdir f:\ but it didn't work. (1 Reply)
I tried to run my ksh scripts in SFU and it always says "not found" as in the example below:
$ .file
/bin/ksh: .file: not found
Did I miss something in the SFU Installation? (2 Replies)
I'm trying to ftp a file from Solaris to Windows XP Pro using SFU and the command that I used is as follows:
ftp -n “host” << cmd
user “loginname” “password”
cd Directory
ls filename error
bye
cmd
If the filename does not exist, it shows the following output:
Output to local-file:... (2 Replies)
hi guys
i am trying using this awk command which works perfectly on unix
awk '$1>=dt' dt="2007-12-03" filename
but when i run same command for same file under SFU it does nothing simply prints the file ( just like cat command ) i am not getting why ?
any way i used sed for same ( little... (5 Replies)
I am new in UNIX so pardon me if I am asking this question. We are using SFU in Windows to have a Windows folder mounted over UNIX. While we can see the mount, everytime i cd on the mounted folder (e.g. cd CONFIG) I always get Permission denies error. Does anyone know why I cannot go inside the... (11 Replies)
Hi all
How can I use ps command on korn shell emulated by SFU on Windows Server ?
All others commands work fine, but this one I don't know :confused:
Many thanks
---------- Post updated at 11:28 AM ---------- Previous update was at 10:12 AM ----------
Ok, it works fine in fact, I'm... (0 Replies)
Hi, I support a small lab of older HP UX 9 and 10 boxes. We have some older NT 4.0 machines at each UX box, with a old ZFS Server programs hosting two mounted directories. (Each UX and NT machine is on its own private network via crossover cable). Due to hardware failure/support EOL on NT, I have... (3 Replies)
Hi all,
i am currently setting my windows XP environment to use with Services for Unix (NFS Client) to mount my unix file system as a network drive. However, though i could mount the unix file directory successful, but the folder is empty (which is not). Why is this so? i have imported my unix... (6 Replies)
Hi all,
When I execute ps command with SFU (Microsoft Windows Services for UNIX), the result is returned as an empty line.
Other commands will return correct results.
How can I get the result of ps command correctly?
Thank you. (2 Replies)
Discussion started by: tcx731
2 Replies
LEARN ABOUT DEBIAN
sql::reservedwords
SQL::ReservedWords(3pm) User Contributed Perl Documentation SQL::ReservedWords(3pm)NAME
SQL::ReservedWords - Reserved SQL words by ANSI/ISO
SYNOPSIS
if ( SQL::ReservedWords->is_reserved( $word ) ) {
print "$word is a reserved SQL word!";
}
DESCRIPTION
Determine if words are reserved by ANSI/ISO SQL standard.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either "SQL:1992", "SQL:1999" or "SQL:2003".
is_reserved_by_sql1992( $word )
Returns a boolean indicating if $word is reserved by "SQL:1992".
is_reserved_by_sql1999( $word )
Returns a boolean indicating if $word is reserved by "SQL:1999".
is_reserved_by_sql2003( $word )
Returns a boolean indicating if $word is reserved by "SQL:2003".
reserved_by( $word )
Returns a list with SQL standards that reserves $word.
words
Returns a list with all reserved words.
EXPORTS
Nothing by default. Following subroutines can be exported:
is_reserved
is_reserved_by_sql1992
is_reserved_by_sql1999
is_reserved_by_sql2003
reserved_by
words
SEE ALSO
SQL::ReservedWords::DB2
SQL::ReservedWords::MySQL
SQL::ReservedWords::ODBC
SQL::ReservedWords::Oracle
SQL::ReservedWords::PostgreSQL
SQL::ReservedWords::SQLite
SQL::ReservedWords::SQLServer
ISO/IEC 9075:1992 Database languages -- SQL
ISO/IEC 9075-2:1999 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)
ISO/IEC 9075-2:2003 Database languages -- SQL -- Part 2: Foundation (SQL/Foundation)
AUTHOR
Christian Hansen "chansen@cpan.org"
COPYRIGHT
This program is free software, you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.8.8 2008-03-28 SQL::ReservedWords(3pm)
04-26-2010
