API:EPrints/Database/Oracle - Revision history

Pod2wiki at 00:00, 12 January 2022

2022-01-12T00:00:31Z

Pod2wiki at 23:59, 11 January 2022

2022-01-11T23:59:44Z

Pod2wiki at 20:08, 25 December 2021

2021-12-25T20:08:29Z

Pod2wiki at 16:34, 25 December 2021

2021-12-25T16:34:18Z

Pod2wiki at 16:29, 25 December 2021

2021-12-25T16:29:13Z

Show changes

Tdb01r at 09:56, 22 January 2013

2013-01-22T09:56:38Z

Show changes

Tdb01r at 15:27, 16 December 2011

2011-12-16T15:27:08Z

Tdb01r at 10:47, 25 August 2011

2011-08-25T10:47:45Z

Tdb01r at 13:06, 17 June 2010

2010-06-17T13:06:59Z

Tdb01r at 15:13, 25 February 2010

2010-02-25T15:13:42Z

@@ Line 391: / Line 391: @@
   $type_info = $db-&gt;type_info( $data_type )
 See {{API:PodLink|file=DBI|package_name=DBI|section=type_info|text=DBI/type_info}}.  Oracle has is own type information mappings.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

@@ Line 15: / Line 15: @@
 <!-- Pod2Wiki= -->
 </div>
-<!-- Pod2Wiki=head_synopsis -->
+<!-- Pod2Wiki=head_description -->
-==SYNOPSIS==
+==DESCRIPTION==
-These settings are the default settings for the free Oracle developer version:
+Oracle database wrapper for Oracle DB version 9+.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
 <span style='display:none'>User Comments</span>
@@ Line 33: / Line 26: @@
 <!-- Pod2Wiki= -->
 </div>
-<!-- Pod2Wiki=head_description -->
+<!-- Pod2Wiki=head_synopsis -->
-==DESCRIPTION==
+===Synopsis===
-Oracle database wrapper for Oracle DB version 9+.
+These settings are the default settings for the free Oracle developer version:
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
 <span style='display:none'>User Comments</span>
@@ Line 48: / Line 48: @@
 Enable the HR user in Oracle XE.
-Set the <tt>ORACLE_HOME</tt> and <tt>ORACLE_SID</tt> environment variables. To add these globally edit <tt>/etc/profile.d/oracle.sh</tt> (for XE edition):
+Set the <tt>ORACLE_HOME</tt> and <tt>ORACLE_SID</tt> environment variables. To  add these globally edit <tt>/etc/profile.d/oracle.sh</tt> (for XE edition):
    export ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
@@ Line 64: / Line 64: @@
 <!-- Pod2Wiki=head_oracle_specific_annoyances -->
 ===Oracle-specific Annoyances===
-Use the GQLPlus wrapper from http://gqlplus.sourceforge.net/ instead of sqlplus.
+Use the GQLPlus wrapper from http://gqlplus.sourceforge.net/ instead  of sqlplus.
-Oracle will uppercase any identifiers that aren't quoted and is case sensitive, hence mixing quoted and unquoted identifiers will lead to problems.
+Oracle will uppercase any identifiers that aren't quoted and is case  sensitive, hence mixing quoted and unquoted identifiers will lead to  problems.
 Oracle does not support <tt>LIMIT()</tt>.
-Oracle does not support <tt>AUTO_INCREMENT</tt> (MySQL) nor <tt>SERIAL</tt> (Postgres).
+Oracle does not support <tt>AUTO_INCREMENT</tt> (MySQL) nor <tt>SERIAL</tt>  (Postgres).
 Oracle won't <tt>ORDER BY LOBS</tt>.
@@ Line 78: / Line 78: @@
 Oracle doesn't support <tt>AS</tt> when aliasing.
-When specifying char column lengths use (n char) to define character semantics. Otherwise oracle uses the <tt>nls_length_semantics</tt> setting to determine whether you meant bytes or characters.
+When specifying char column lengths use (n char) to define character  semantics. Otherwise oracle uses the <tt>nls_length_semantics</tt> setting  to determine whether you meant bytes or characters.
-{{API:PodLink|file=DBD/Oracle|package_name=DBD::Oracle|section=|text=DBD::Oracle}} can crash when using <tt>PERL_USE_SAFE_PUTENV</tt>-compiled Perls, see http://www.eprints.org/tech.php/13984.html.
+{{API:PodLink|file=DBD/Oracle|package_name=DBD::Oracle|section=|text=DBD::Oracle}} can crash when using <tt>PERL_USE_SAFE_PUTENV</tt>-compiled  Perls, see http://www.eprints.org/tech.php/13984.html.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
@@ Line 89: / Line 89: @@
 <!-- Pod2Wiki= -->
 </div>
-<!-- Pod2Wiki=head_todo -->
+<!-- Pod2Wiki=head_constants -->
-===TODO===
+==CONSTANTS==
-<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
+See [[API:EPrints/Database#CONSTANTS|EPrints::Database]].
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
@@ Line 108: / Line 100: @@
 <!-- Pod2Wiki= -->
 </div>
-<!-- Pod2Wiki=item_index_name -->
+<!-- Pod2Wiki=head_instance_variables -->
-====$name = $db-&gt;index_name( $table, @columns )====
+==INSTANCE VARIABLES==
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

@@ Line 248: / Line 248: @@
   $boolean = $db-&gt;has_column( $table, $column )
 Return <tt>true</tt> if the named database <tt>$table</tt> has the named  <tt>$column</tt>.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
@@ Line 310: / Line 312: @@
 ===prepare_regexp===
-  $sql = $db-&gt;prepare_regexp( $col, $_value )
+  $sql = $db-&gt;prepare_regexp( $col, $value )
-The syntax used for regular expressions varies across databases. This method takes two quoted string and returns a SQL expression that will apply the quoted regexp <tt>$value</tt> to the quoted column <tt>$col</tt>.
+Oracle use the syntax:
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

@@ Line 48: / Line 48: @@
 Enable the HR user in Oracle XE.
-Set the ORACLE_HOME and ORACLE_SID environment variables. To add these globally edit /etc/profile.d/oracle.sh (for XE edition):
+Set the <tt>ORACLE_HOME</tt> and <tt>ORACLE_SID</tt> environment variables. To add these globally edit <tt>/etc/profile.d/oracle.sh</tt> (for XE edition):
    export ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
@@ Line 68: / Line 68: @@
 Oracle will uppercase any identifiers that aren't quoted and is case sensitive, hence mixing quoted and unquoted identifiers will lead to problems.
-Oracle does not support LIMIT().
+Oracle does not support <tt>LIMIT()</tt>.
-Oracle does not support AUTO_INCREMENT (MySQL) nor SERIAL (Postgres).
+Oracle does not support <tt>AUTO_INCREMENT</tt> (MySQL) nor <tt>SERIAL</tt> (Postgres).
-Oracle won't ORDER BY LOBS.
+Oracle won't <tt>ORDER BY LOBS</tt>.
-Oracle requires special means to insert values into CLOB/BLOB.
+Oracle requires special means to insert values into <tt>CLOB</tt>/<tt>BLOB</tt>.
-Oracle doesn't support "AS" when aliasing.
+Oracle doesn't support <tt>AS</tt> when aliasing.
-When specifying char column lengths use (n char) to define character semantics. Otherwise oracle uses the "nls_length_semantics" setting to determine whether you meant bytes or chars.
+When specifying char column lengths use (n char) to define character semantics. Otherwise oracle uses the <tt>nls_length_semantics</tt> setting to determine whether you meant bytes or characters.
-DBD::Oracle can crash when using PERL_USE_SAFE_PUTENV-compiled Perls, see http://www.eprints.org/tech.php/13984.html
+{{API:PodLink|file=DBD/Oracle|package_name=DBD::Oracle|section=|text=DBD::Oracle}} can crash when using <tt>PERL_USE_SAFE_PUTENV</tt>-compiled Perls, see http://www.eprints.org/tech.php/13984.html.
 <div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>

@@ Line 1: / Line 1: @@
 <!-- Pod2Wiki=_preamble_
 This page has been automatically generated from the EPrints 3.2 source. Any wiki changes made between the 'Pod2Wiki=*' and 'Edit below this comment' comments will be lost.
-  -->{{API}}{{Pod2Wiki}}{{API:Source|file=EPrints/Database/Oracle.pm|package_name=EPrints::Database::Oracle}}[[Category:API|ORACLE]][[Category:API:EPrints/Database|ORACLE]][[Category:API:EPrints/Database/Oracle|ORACLE]]<div><!-- Edit below this comment -->
+  -->{{API}}{{Pod2Wiki}}{{API:Source|file=perl_lib/EPrints/Database/Oracle.pm|package_name=EPrints::Database::Oracle}}[[Category:API|ORACLE]][[Category:API:EPrints/Database|ORACLE]][[Category:API:EPrints/Database/Oracle|ORACLE]]<div><!-- Edit below this comment -->

← Older revision		Revision as of 13:06, 17 June 2010
Line 77:		Line 77:

	Oracle doesn't support "AS" when aliasing.		Oracle doesn't support "AS" when aliasing.
		+
		+	When specifying char column lengths use (n char) to define character semantics. Otherwise oracle uses the "nls_length_semantics" setting to determine whether you meant bytes or chars.

	<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>		<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce; padding: 0em 1em 0em 1em; font-size: 80%; '>