SQL::ReservedWords::Oracle(3pm) User Contributed Perl Documentation SQL::ReservedWords::Oracle(3pm)NAME
SQL::ReservedWords::Oracle - Reserved SQL words by Oracle
SYNOPSIS
if ( SQL::ReservedWords::Oracle->is_reserved( $word ) ) {
print "$word is a reserved Oracle word!";
}
DESCRIPTION
Determine if words are reserved by Oracle Database.
METHODS
is_reserved( $word )
Returns a boolean indicating if $word is reserved by either Oracle7, Oracle8i, Oracle9i or Oracle10g.
is_reserved_by_oracle7( $word )
Returns a boolean indicating if $word is reserved by Oracle7.
is_reserved_by_oracle8( $word )
Returns a boolean indicating if $word is reserved by Oracle8i.
is_reserved_by_oracle9( $word )
Returns a boolean indicating if $word is reserved by Oracle9i.
is_reserved_by_oracle10( $word )
Returns a boolean indicating if $word is reserved by Oracle10g.
reserved_by( $word )
Returns a list with Oracle versions 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_oracle7
is_reserved_by_oracle8
is_reserved_by_oracle9
is_reserved_by_oracle10
reserved_by
words
SEE ALSO
SQL::ReservedWords
<http://www.oracle.com/technology/documentation/>
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::Oracle(3pm)
Check Out this Related Man Page
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)
Through a shell script ...
I am invoking sql plus..
Code is as follows...
echo " set feedback off verify off pagesize 0
select column from table " | sqlplus -s/@dbname | read var_col
Now if oracle throws an exception for above select statement ...then how can i catch it ?... (15 Replies)
Oracle and Scripting gurus,
I need some help with this script...
I am trying to add the query
SELECT * FROM
ALL_SYNONYMS
WHERE SYNONYM_NAME = 'METADATA'
in the current script....
Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Hi,
Iam calling 3 sql scripts through one shell script 'rmia.sh'.
Till now this was working fine, but last time while calling the SQL scripts,
Oracle was down. But amazingly the exit status was '0' (success)!!!
Below is the shell code:
#!/usr/bin/ksh -x
assign_file asql a.sql 1... (15 Replies)
Connected to oracle database
sqlplus << EOF
$CONNECTSTR
set heading off
set trimspool on
set feedback off
select ID,DATE from sysadm.TEST where VALUE = 'A' order by ID;
value_id = ID
value_date = DATE
EOF
1. Is it possible to reference the values, ID,DATE in unix shell script.
2.... (20 Replies)
Having searched high and low through Oracles documentation, I came to think that they're very scripting-averse, as there's (apparently) no list of possible return/exit codes for their various command line utilities.
Is anyone here in possession of such a list, or knows where to find one? It... (16 Replies)
My name is Jimmy. My company support a client that using Sun Microsystems and Oracle. I'm totally zero knowledge about it. Only know installation a bit in Debian Linux and some commands. Do anyone here can help me at least some idea how to operate the Sun Microsystems. Please correct me if i'm... (14 Replies)
I tried searching the forum for similar posts but its closed now.
Would appreciate any help on this.
I am trying to capture return value from a select query into a variable.
DB is Oracle
I am able to spool it to a file but I donot intend to use it.
Here is my script that does not work ;)
I... (27 Replies)
Hi,
I am trying to develop a script which should find a word if a particular word exists.
Below is the content of the file.
insert_job: test_job ----> job name
days_of_week: all
start_times: "16:00"
date_conditions: 1
insert_job: test_job2 ----> job name
days_of_week: all... (16 Replies)
I have a Oracle dbase running in a Solaris 10 cluster and have two private interconnects that are being used for communication. Is there any way to connect these two interconnects together using IPMP for redundancy? I've made several attempts with no luck so far and was wondering if anyone had... (17 Replies)
Hello world,
Can anybody tell me how to count how many times does a word repeat in a file? There have been many threads on this but they all are heavy loads of Scripting for a starter like me. :D
So, I sat down today and after some hours of reading man pages, I found a simple one-line... (18 Replies)
How do I set ORACLE_HOME location?
When I type echo $$ORACLE_HOME it gives me
/u01/app/oracle//product/10.2.0/dbhome_1
which has been deleted.
I just installed Oracle 11g and this is supposed to be a new oracle home
/u01/app/oracle/product/11.2.0/dbhome_1
Any help from the community... (21 Replies)
I installed Oracle sqlplus on My Ubuntu 14.04 64bit version as per the instructions on:
help.ubuntu page (Unable to post the URL as i'm new user here).
I'm totally new to SQL and now i'm learning queries in my college.
I installed 64bit version of sqplus and run it executing the command:... (14 Replies)
Hi. I'm trying to find the best way to locate the latest version of Oracle on a Linux host.
There could be multiple SW installs or there could be none. It could be a client or a full RDBMS installation. I need to find and set the environment in order to run the sqlplus binary. Rather than just... (14 Replies)
Hi,
I'm a junior programmer. This is my first post here, please excuse me if that's not the correct place :)
For days now I've been trying to install Oracle DB 12c R2 on Ubuntu 18.04. I'm at my wits' end. The software itself installs fine and a Listener can be started but I can't start... (15 Replies)