Oracle8: A Beginner's Guide - McGraw-Hill
Bookstore
SQL> insert into sales values (100,1994,2,1); 1 row created. SQL> ... SQL> insert into Y values ('5'); 1 row created. create or replace procedure samp (parm1 in ... www.mhprofessional.com/downloads/.../0078823935_code.txt
Note to readers: Mike Corey, Ian
Abramson, and
SQL>> insert into a values ('1'); 1 row created. SQL>> insert into a values ('2'); 1 row created. SQL>> insert into a values ('3'); 1 row created. SQL>> insert into b ... www.mhprofessional.com/downloads/.../0072192798_code.txt
Connected to: Oracle9i Enterprise
Edition Release 9.0 ... - Exzilla.NET
SQL> SQL> SQL> insert into myfriends values(1,'teddy','111111',to_date('10-10- 1970','DD-MM-YYYY'),1); 1 row created. SQL> insert into myfriends values(2 ... www.exzilla.net/docs/php-oci8/material/screen.shot.log.txt
EXAMPLES
SQL> SQL> INSERT INTO Students VALUES ('0602751127','Ethan Longwinder',' My Way 2'); 1 row created. SQL> INSERT INTO Students VALUES ... www.itu.dk/~pagh/IDB05/Constraints-examples-run.txt
SQL> -- To set
autotrace and timing on: SQL>
SQL> set autotrace on ...
Elapsed: 00:00:00.08 SQL> SQL> INSERT INTO myprojects (SELECT * FROM pagh.projects); 116641 rows created. Elapsed: 00:00:59.22 Execution Plan ... www.itu.dk/people/pagh/DBS05/Efficiency-examples-run.txt
cbl dll,thread,lib * IDENTIFICATION DIVISION
...
MOVE 0 to RETURN-CODE. IF TABLE-NUM = 1 EXEC SQL INSERT INTO JCOB. HELLOWLD01 VALUES ("HELLO WORLD") END-EXEC ELSE IF TABLE-NUM ... www-03.ibm.com/systems/resources/PTCOBHLW.txt
RELEASE NOTES FOR INFORMIX-ESQL/C 9.14.UC1 PRODUCT
...
indicator = 0; $insert into tab values (:vchar :indicator); Work around user must insert ... exec sql create table tabrow(col dbrow); exec sql insert into tabrow values ... publib.boulder.ibm.com/infocenter/ifxhelp/v0/.../esq0914r4.txt
SQL> SQL> /*
DOC>alter table modify constraint DOC ...
SQL> insert into test3_a values('e',4); 1 row created. SQL> alter table test3_a add constraint test3_a_u unique (c2); Table altered. SQL> SQL> alter table test3_a ... www.jusungyang.com/ORACLEfolder/.../UniqeConsSummary.txt
SQL> SQL>
drop table t1_a; drop table t1_a * ERROR at line 1: ORA
...
SQL> insert into t1_a values(2,'xx'); 1 row created. SQL> insert into t1_a values(3, 'xx') ... SQL> insert into t2_a values(3,'yy'); 1 row created. SQL> insert into t2_a ... www.jusungyang.com/ORACLEfolder/.../MergeConditional.txt
SQL> SQL>
drop table t1_a; Table dropped. SQL> drop table
t2_a ...
SQL> insert into t1_a values(2,'xx'); 1 row created. SQL> insert into t1_a values(3, 'xx') ... SQL> insert into t2_a values(3,'yy'); 1 row created. SQL> insert into t2_a ... www.jusungyang.com/ORACLEfolder/.../MergeAndExists.txt