The SET DEFINE OFF command in Oracle prevents Oracle from doing any variable substitution.
Use the SET DEFINE OFF command in Oracle to prevent Oracle from interpreting the ampersand for variable substitution.
The SET DEFINE ON command turns variable substitution back on.
Filed under: Database, Oracle, Programming, SQL, Software, Technology, pl/sql | Tagged: blog, blogging, coding, database, Oracle, pl/sql, techsaints | 1 Comment »
The Oracle DUAL table is a table created by Oracle and is used for selects statements that do not have a table name to go along with them.
For example, the DUAL table can be used to select pseudo columns, such as getting the currval or nextval from an Oracle sequence.
SELECT myseq.nextval FROM DUAL;
The DUAL table [...]
Filed under: Database, Oracle, Programming, SQL, Software, Technology, pl/sql | Tagged: dual, Oracle, tables | Leave a Comment »
The following syntax demonstrates how to create an Oracle tablespace:
CREATE TABLESPACE myTablespace
DATAFILE ‘/oracle/ts_mytablespace.dbf’
SIZE 100m
AUTOEXTEND on
NEXT 10m
MAXSIZE 500m;
The size of this tablespace is defined as 100 megabytes. By having the AUTOEXTEND attribute set to “on,” the statement is specifying that if the tablespace size exceeds 100 megabytes, more space will be allocated for the tablespace. The [...]
Filed under: Database, Oracle, Programming, SQL, Software, Technology, pl/sql | Tagged: database, Oracle, SQL, tablespaces, techsaints | Leave a Comment »
A tablespace is the Oracle way of referring to a database file. A tablespace is a file set up to contain tables and is the primary logical storage structure for Oracle databases. Logical storage means the tablespace itself cannot be seen in the file system of the database server. The tablespace relates database objects to [...]
Filed under: Oracle, Programming, SQL, Software, Technology, pl/sql | Tagged: data files, database, Oracle, pl/sql, SQL, system, tablespaces | Leave a Comment »
When a large amount of alphanumeric data needs to be stored in one record, the CLOB data type should be used.
CLOB stands for “Character Large Object.” The CLOB data type allows for the storage of up to 4GB of data. It’s basically the same as the VARCHAR2 data type, with the exception that it allows [...]
Filed under: Oracle, Programming, Software, pl/sql | Tagged: clob, data types | 1 Comment »
To list all stored procedures in MySQL, simply execute the following command:
SHOW PROCEDURE STATUS;
Filed under: MySQL, Programming, php | Tagged: MySQL, procedures, SQL, status, stored procedures | Leave a Comment »
A database diagram can be created in Toad for Oracle by using the “ER Diagram” tool. This can be access by clicking “Database” on the menu bar, then “Report”, then “ER Diagram.”
A blank area will then appear in the center of the screen. Tables listed in the “Object Palette” can be dragged onto the area. [...]
Filed under: Oracle, Programming, Software, pl/sql | Tagged: database, diagrams, er, Oracle, toad | 1 Comment »
This will fix the “javax.net.ssl.sslpeerunverifiedexception: peer not authenticated” errors thrown in ColdFusion.
In my case, I purchased a secure certificate from godaddy.com. If you’ve purchased a certificate from another source or if you are unsure you can check where to go to by viewing the certificate and looking at the certificate’s certification path.
Download Certs from Go [...]
Filed under: ColdFusion, Uncategorized | Tagged: CF8, CFMX, ColdFusion, java, Programming, ssl certificate | Leave a Comment »
A unique constraint is used to ensure that a singular value occur only once in a column or that a distinctive combination of values occur only once across a series of columns.
A unique constraint in Oracle can be disabled using the following syntax:
ALTER TABLE my_table DISABLE CONSTRAINT my_constraint;
Filed under: Oracle, Programming, SQL, Software, Technology, pl/sql | Tagged: constraints, database, disable, SQL, unique | Leave a Comment »
A unique constraint is used to ensure that a singular value occur only once in a column or that a distinctive combination of values occur only once across a series of columns.
A unique constraint in Oracle can be dropped using the following syntax:
ALTER TABLE my_table DROP CONSTRAINT my_constraint;
Filed under: Oracle, Programming, pl/sql | Tagged: Oracle, pl/sql | Leave a Comment »
