Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

sql::reservedwords::oracle(3pm) [debian man page]

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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Unix Oracle

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)
Discussion started by: dhananjaysk
15 Replies

2. Shell Programming and Scripting

Calling SQL scripts through Shell Script

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)
Discussion started by: madhunk
18 Replies

3. UNIX for Advanced & Expert Users

Capturing Oracle Shutdown error

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)
Discussion started by: ganapati
15 Replies

4. UNIX for Dummies Questions & Answers

Problem with while loop and SQL

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)
Discussion started by: nandajk
20 Replies

5. UNIX and Linux Applications

Oracle return codes?

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)
Discussion started by: pludi
16 Replies

6. UNIX for Dummies Questions & Answers

UNIX, Linux and Sun Solaris Dummy

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)
Discussion started by: jimmyysk
14 Replies

7. Shell Programming and Scripting

Shell script to catch PL/SQL return values

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)
Discussion started by: monie2717
27 Replies

8. Shell Programming and Scripting

Finding a specific word

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)
Discussion started by: rpatty
16 Replies

9. Solaris

IPMP on Private interconnects

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)
Discussion started by: goose25
17 Replies

10. UNIX for Dummies Questions & Answers

Number of word occurences in a file?

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)
Discussion started by: satish51392111
18 Replies

11. Shell Programming and Scripting

Permission to Oracle server to create a directory in a particular path

i need to give permission to ORACLE SERVER to create a directory in a particular path. How to do it?Oracle server is installed on SOLARIS (16 Replies)
Discussion started by: rafa_fed2
16 Replies

12. Solaris

New Oracle Home

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)
Discussion started by: newborndba
21 Replies

13. UNIX for Dummies Questions & Answers

Unable to configure Oracle sqlplus V12 properly. Need Help. Resources could'nt be found elsewhere .

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)
Discussion started by: arjunmayilvagan
14 Replies

14. Shell Programming and Scripting

Finding all Oracle SW installations on a host

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)
Discussion started by: user052009
14 Replies

15. UNIX for Beginners Questions & Answers

Shmem problem installing Oracle 12 C on Ubuntu 18.04

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)
Discussion started by: Marika
15 Replies