Hmmm... Precompiled PL/SQL is LESS efficient than embedded SQL? Got metrics?
-Original Message-
Sent: Tuesday, January 15, 2002 7:20 AM
To: Multiple recipients of list ORACLE-L
Hello All
It is not efficient.
We are talking about sending one insert statement against: call procedure
How do you deactivate a procedure?
-Original Message-
Sent: Tuesday, January 15, 2002 6:20 AM
To: Multiple recipients of list ORACLE-L
Hello All
It is not efficient.
We are talking about sending one insert statement against: call procedure,
activate the procedure in the database
procedures instead of coding update/insert
SQL...huh?
Hmmm... Precompiled PL/SQL is LESS efficient than embedded SQL? Got
metrics?
-Original Message-
Sent: Tuesday, January 15, 2002 7:20 AM
To: Multiple recipients of list ORACLE-L
Hello All
It is not efficient.
We
think this is done just to eliminate part of your job, you
are looking at this totally wrong.
--- àãø_éçéàì [EMAIL PROTECTED] wrote:
Hello All
It is not efficient.
We are talking about sending one insert statement against: call
procedure,
activate the procedure in the database, parse
:
Sent by: rootSubject: Using procedures
instead of coding
update/insert SQL...huh?
01/14/2002
10:10 AM
Please
respond to
ORACLE-L
We have done some preliminary testing and found prepared statements about 20% faster
than stored procedures. We inserted 200,000 records at a time (28-50 columns in a
table ) using stored procedures and then used prepared statements for the same
dataset. Both of them were called from java
?
-Original Message-
Sent: Tuesday, January 15, 2002 6:20 AM
To: Multiple recipients of list ORACLE-L
Hello All
It is not efficient.
We are talking about sending one insert statement against: call
procedure,
activate the procedure in the database, parse and pass the
parameters, do
: Using
procedures
instead of coding
update/insert SQL...huh?
01/14/2002
10:10 AM
Please
respond to
ORACLE-L
I just joined a new Oracle/Java
How did you call the stored procedures from java/jdbc?
-Joe
At 10:55 AM 1/15/02, you wrote:
We have done some preliminary testing and found prepared statements about
20% faster than stored procedures. We inserted 200,000 records at a time
(28-50 columns in a table ) using stored procedures
The reason for that is the fact that with prepared statements you
can do array binds while that isn't possible with the stored procedures.
I don't like this kind of comparisons. I judge on case by case basis.
-Original Message-
Sent: Tuesday, January 15, 2002 10:55 AM
To: Multiple
PROTECTED] wrote:
How do you deactivate a procedure?
-Original Message-
Sent: Tuesday, January 15, 2002 6:20 AM
To: Multiple recipients of list ORACLE-L
Hello All
It is not efficient.
We are talking about sending one insert statement against: call
procedure,
activate the procedure
-
Sent: Tuesday, January 15, 2002 6:20 AM
To: Multiple recipients of list ORACLE-L
Hello All
It is not efficient.
We are talking about sending one insert statement against: call
procedure,
activate the procedure in the database, parse and pass the
parameters, do
the same
[EMAIL PROTECTED] wrote:
oh, now I owe you a royalty for naming a new book Zen and the Art of
Database Administration (my apologies to the author of Zen and the Art
of Archery)
somehow i don't think he'll mind.;-)
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL
To: Multiple recipients of list ORACLE-L
Subject: RE: Using procedures instead of coding update/insert
SQL...huh?
How about being an intuitive DBA. Sort of zen Buddhism and the
database administration? Can you feel the pain of your oracle database
when somebody executes a Cartesian product
of
coding update/insert
01/15/2002
You must be using Oracle 8.0 or earlier. Bulk/array binds are possible in
PL/SQL (stored procedures) starting with Oracle 8i
-Original Message-
Sent: Tuesday, January 15, 2002 11:40 AM
To: Multiple recipients of list ORACLE-L
The reason for that is the fact that with prepared
]
@oxhp.com cc:
Sent by: rootSubject: RE: Using procedures instead of
coding update/insert
noticed that the current version does some basic checks before
executing the INSERT/UPDATE/DELETE SQL. For example, it checks to see if
the record exists before executing the INSERT sql.
-Original Message-
Sent: Tuesday, January 15, 2002 12:17 PM
To: Multiple recipients of list ORACLE-L
you oughta apologize to Robert Pirsig, the guy who started the whole thing.
-Original Message-
Sent: Tuesday, January 15, 2002 12:35 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
oh, now I owe you a royalty for naming a new book Zen and the Art of
Database
They are possible, all right, with forall statement
and/or with passing an array as a parameter. How many
of your procedures do actually use that feature? Are you sure
that the guy who has tested the difference between prepared
SQL and PL/SQL procedure has done the necessary coding in order
to
]
@oxhp.com cc:
Sent by: rootSubject: RE: Using procedures
instead of
coding update/insert
01/15/2002
11:40 AM
Please
respond
]
@oxhp.com cc:
Sent by: rootSubject: RE: Using procedures
instead of
coding update/insert
01/15/2002
11:40 AM
Please
respond
Chris,
It is not that difficult to generate the code.
I recently wrote a procedure that generates code to insert into a table, you
provide the owner and table name. I wanted to create generic audit triggers
... but that is too much of work, so I wrote some code that would generate
the audit
There are standard (oracle supplied) predefined types like:
DBMS_SQL.NUMBER_TABLE
DBMS_SQL.DATE_TABLE
DBMS_SQL.VARCHAR2_TABLE
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, January 15, 2002 2:05 PM
Actually, we have many procedures that use the FORALL syntax. And, yes I am
the guy that tested the difference between the Java code sending a bulk
insert v.s., using PL/SQL FORALL. And Yes, there was a significant (10-25%)
improvement when using PL/SQL. The code was as close as we could get
Or, you could do what we do in once case (8.1.6 database)make 1000
procedure calls that populates a package index-by table. After 1000 calls,
it internally does another call that does the bulk insert. The first 999
calls take about 1 second.
-Original Message-
Sent: Tuesday, January
, we have many procedures that use the FORALL syntax. And, yes I am
the guy that tested the difference between the Java code sending a bulk
insert v.s., using PL/SQL FORALL. And Yes, there was a significant (10-25%)
improvement when using PL/SQL. The code was as close as we could get it.
I'll agree
-L
cgrabowy[EMAIL PROTECTED]
@fcg.comcc:
Sent by: rootSubject: Using
procedures
instead of coding
update/insert SQL...huh?
01/14/2002
:
Sent by: rootSubject: RE: Using procedures
instead of
coding update/insert
01/15/2002
11:40 AM
Please
respond to
ORACLE-L
PROTECTED]]
Sent: Tue, January 15, 2002 6:40 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Using procedures instead of coding update/insert
SQL...huh?
How about being an intuitive DBA. Sort of zen Buddhism and the
database administration? Can you feel the pain of your
I just joined a new Oracle/Java project using Tomcat app server. On this
project they decided to create an update procedure and insert procedure for
every table. This procedure is then called in the Java code with the
appropriate parameters passed, instead of simply coding the UPDATE or INSERT
Professional
-Original Message-
Sent: Monday, January 14, 2002 10:10 AM
To: Multiple recipients of list ORACLE-L
I just joined a new Oracle/Java project using Tomcat app server. On this
project they decided to create an update procedure and insert procedure for
every table. This procedure
We used it at a former site. The idea is, this makes the JAVA code
totally reusable if you end up changing database servers. All you would
have to do is change the underlying insert and update procedures and
recompile the application code.
I can see a use for it even if you aren't changing
It makes absolute sense to use this encapsulated approach, because you don't
have to keep changing your code for DML every time table structure changes,
plus this way you guarantee that everyone will use the same statement
promoting its reuse in the SGA.
Oracle designer likes to call this
Message-
Sent: Monday, January 14, 2002 10:10 AM
To: Multiple recipients of list ORACLE-L
I just joined a new Oracle/Java project using Tomcat app server. On this
project they decided to create an update procedure and insert procedure for
every table. This procedure is then called
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 09, 2002 07:40
hello everybody ,
would someone give me an example to insert/retrieve a bolb ?
please refer to Oracle9i Application Developer's Guide - Large Objects
(LOBs
hello guys ,
can someone give me an example , how to insert/retreive a blob ?
i am 816 / NT .
tia.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prem J Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
hello everybody ,
would someone give me an example to insert/retrieve a bolb ?
i posted the same query yesterday . No response yet :(
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Prem J Khanna
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
when a delete takes
place a row is inserted into archiveuser table in the Archive database.
Triggers work fine when A schema tables are in Archive database.
I need to grant some sort of insert permission but how. Grant insert on atable to
A@PROD doesn't work
tried to grant insert
Ok, I thought I had it but it is still not working.
Production user on Prod has dba privileges, has been granted insert on any table and
granted insert to all the archive user tables. He can see the view in Archive user in
Prod and can see the tables in Archive User in the Archive Database
using 'ifsdev'
/
drop table mytab;
create table mytab ( test_date date );
create or replace trigger mytab_biudt
after insert or update or delete
on mytab
for each row
declare
v_test_date mytab.test_date%type;
begin
if inserting then
v_test_date := :new.test_date;
elsif updating
insert or update or delete
on mytab
for each row
declare
v_test_date mytab.test_date%type;
begin
if inserting then
v_test_date := :new.test_date;
elsif updating then
v_test_date := :old.test_date;
elsif deleting then
v_test_date := :old.test_date;
end if;
insert
PROTECTED]
01/04/02 03:14 cc:
PM Subject: RE: FW: insert privilege across
db link
database is 8.1.7
how do I grant insert privilege to a user in a different database?
Note: the database link in place in both database and I can describe tables in each
just fine. In the trigger I already have the insert into b.address@bschema. When I
try to execute the
trigger I get
do I grant insert privilege to a user in a different database?
Note: the database link in place in both database and I can describe
tables in each just fine. In the trigger I already have the insert into
b.address@bschema. When I try to execute the
trigger I get insufficient privileges. I have
in the remote
db. in your case are you using the user b in your dblink?
babu
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 03, 2002 3:35 PM
database is 8.1.7
how do I grant insert privilege to a user in a different database
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, January 03, 2002 3:35 PM
database is 8.1.7
how do I grant insert privilege to a user in a different database?
Note: the database link in place in both database and I can describe
tables in each
in the Archive database.
Triggers were created under produser in the PROD database so when a delete takes place
a row is inserted into archiveuser table in the Archive database.
Triggers work fine when A schema tables are in Archive database.
I need to grant some sort of insert permission but how
:
Sent by: Subject: FW: insert privilege across db
link
[EMAIL PROTECTED]
om
Hello,
Effectively, your syntax perfectly function ...
Thanks again !
Jean Berthold
SIM/HAOUHACH a écrit :
I think that it is possible to use the next syntax:
insert into grandeur_mesure2
(ID_GRANDEUR,DATE_AQUISITION,VALEUR,VALIDITE,ID_TYPE_ACQUISITION,UTILISATION
NUMBER(15)
ID_TYPE_GRANDEURNUMBER(15)
ID_UNITENUMBER(1
I try to insert all the rows from the first table into the second table
and concat the
following fields:
describe grandeur_mesure.JOUR
describe
disys.comTo: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: Insert script generator
(1
I try to insert all the rows from the first table into the second table
and concat the
following fields:
describe grandeur_mesure.JOUR
describe grandeur_mesure.HEURE
describe grandeur_mesure.MINUTE
Into:
describe grandeur_mesure2.DATE_AQUISITION
Please, do you know which is the correct command
I think that it is possible to use the next syntax:
insert into grandeur_mesure2
(ID_GRANDEUR,DATE_AQUISITION,VALEUR,VALIDITE,ID_TYPE_ACQUISITION,UTILISATION
)
select
( ID_GRANDEUR, to_char(JOUR,'DD')||'
'||to_char(HEURE,'HH24')||':'||to_char(MINUTE, 'MI'), VALEUR
NUMBER(15)
ID_COMPTEUR NUMBER(15)
ID_TYPE_GRANDEURNUMBER(15)
ID_UNITENUMBER(1
I try to insert all the rows from the first table into the second table
and concat the
following fields
THANKS,
I
resolved the issue.
If
I use a script like the one below to test the trigger "for each row"
and "statement insert" it is
taken as multiple statements.
It
works fine now
I AM LEARNING ORACLE.
I CREATED A TABLE JUNK AS BELOW,
SQL CREATE TABLE JUNK
2 (NAME VARCHAR2(10),
3 EMPID NUMBER(5) ,
4 SALARY NUMBER(5,3) ) ;
Table created.
I NEED TO INSERT C:|JUNK.SQL ( I SAVED IN NOTEPAD ) WHICH LOOKS AS FOLLOWS :
HOW SHOULD I DO THAT ?
ABCDEFGHIJ 12345
[EMAIL PROTECTED] wrote:
I AM LEARNING ORACLE.
I CREATED A TABLE JUNK AS BELOW,
SQL CREATE TABLE JUNK
2 (NAME VARCHAR2(10),
3 EMPID NUMBER(5) ,
4 SALARY NUMBER(5,3) ) ;
Table created.
I NEED TO INSERT C:|JUNK.SQL ( I SAVED IN NOTEPAD ) WHICH LOOKS
AS FOLLOWS
To: Multiple recipients of list ORACLE-L
Subject: INSERT ROWS
I AM LEARNING ORACLE.
I CREATED A TABLE JUNK AS BELOW,
SQL CREATE TABLE JUNK
2 (NAME VARCHAR2(10),
3 EMPID NUMBER(5) ,
4 SALARY NUMBER(5,3) ) ;
Table created.
I NEED TO INSERT C
a simple program to format your
text file into DML statements, then just run these in SQL*Plus.
Alternatively, it would be simple in Perl or Java to write a program
that parsed the text file and fired off INSERT statements to Oracle in
one go, this would be easier if you need to do this a lot. Or use
--
From: Aldi Barco [EMAIL PROTECTED]
Date: Wed, 03 Oct 2001 04:10:28 +0700
Subject: Insert from text file
...
I want to insert a text file in my client machine (Win NT) into emp
(empno,ename, salary) table in unix machine from my client. I don't have
sqlloader
Hi listers,
I want to insert a text file in my client machine (Win NT) into emp
(empno,ename, salary) table in unix machine from my client. I don't have
sqlloader in my machine (client). How to do that ? Can we used utl_file
package ?
If yes , please give an example because I'm new
Another option would be to use perl/VB/shell and format the data into sql
insert
statements then apply these thru sqlplus. Very low tech and cheesy - but it
works.
-Original Message-
Sent: Tuesday, October 02, 2001 3:14 PM
To: Multiple recipients of list ORACLE-L
Hi listers,
I want
Hi, all
I posted an email about insert French characterset
problem days ago. Here is what I got right now: The
db is 817 running on Sun 5.6, and I use a sqlplus 815
running on NT4.0 to access the database.
If I do insert and select from sqlplus client,
everything looks fine:
SQL insert
Thank you Michael! set
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P9 in profile does
solve a part of my problem!
Now if I insert â from sqlplus on NT side and do a
select from sqlplus on Unix, I got â! Thank godness.
The only strange thing I have now is I cannot do
insert correctly from Unix
create table ff (dd raw(16));
SQL insert into ff (select hex_to_raw('234') from dual);
insert into ff (select hex_to_raw('234') from dual)
*
ERROR at line 1:
ORA-01465: invalid hex number
SQL select hex_to_raw('234') from dual;
HEX_TO_RAW('234
, Chelmsford 01863
-Original Message-
Sent: Tuesday, September 11, 2001 12:30 PM
To: Multiple recipients of list ORACLE-L
create table ff (dd raw(16));
SQL insert into ff (select hex_to_raw('234') from dual);
insert into ff (select hex_to_raw('234') from dual
on what version of Oracle you are running, you
could try and run the new version of dynamic sql.
you could change your statement to:
BEGIN
execute immediate 'INSERT INTO scan_contract ' ||
'SELECT CONTRACT_BEGIN_DATE, ' ||
'NSN, CONTRACT, CONTRACT_END_DATE
George ...
After insert you need a commit somewhere ... preferable after the
dbms_sql.execute only then number of rows actually written to the database
will increase.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni
;
g_statement_txt := 'INSERT INTO scan_contract ' ||
'SELECT CONTRACT_BEGIN_DATE, ' ||
'NSN, CONTRACT, CONTRACT_END_DATE, ' ||
'FUTURE_EFF_DATE, FUTURE_SELL_PRICE, ' ||
'SELL_PRICE, UPDATE_DATE, DODAAC
key is composed of:
DODAAC VARCHAR2(6)
NSN VARCHAR2(13)
CONTRACTVARCHAR2(14)
The results BEFORE I put the PK on the INSERT resulted in about 650,000
records. After I put the PK in I am getting:
ORA-1: unique constraint (SHOPPINGSA.SCAN_CONTRACT_PK) violated
How do
,
I am selecting information from 3 tables and inserting it into a new table.
My compound primary key is composed of:
DODAAC VARCHAR2(6)
NSN VARCHAR2(13)
CONTRACTVARCHAR2(14)
The results BEFORE I put the PK on the INSERT resulted in about 650,000
records. After I put
on the INSERT resulted in about 650,000
records. After I put the PK in I am getting:
ORA-1: unique constraint (SHOPPINGSA.SCAN_CONTRACT_PK) violated
How do I find the bad data ???
TIA
Al Rusnak
804-734-8453
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
duplicate values.
You could obviously use the 'distinct' clause in your insert statement to
produce unique PK's, but this may notbe what you want.
hope this helps
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Friday, September 07, 2001 8:41 AM
To: Multiple
selecting information from 3 tables and inserting it into a new table.
My compound primary key is composed of:
DODAAC VARCHAR2(6)
NSN VARCHAR2(13)
CONTRACTVARCHAR2(14)
The results BEFORE I put the PK on the INSERT resulted in about 650,000
records. After I put the PK
)
col3 table dummy3(colc).
there is no relation between dummy1 , dummy2, dummy3. We cannot join
these tables.
can I insert data into xyz in a single shot.
is there anything like
insert into xyz values((select cola from dummy1 where),
(select
).
there is no relation between dummy1 , dummy2, dummy3. We cannot join
these tables.
can I insert data into xyz in a single shot.
is there anything like
insert into xyz values((select cola from dummy1 where),
(select colb from dummy2 where
Hi friend
Currently I' doing a procedure to read about 60 column more from a table
and insert into another tables..
Since most of the table insert involve is 3 tables only..
will it be better I build up 3 procedure /function , so that everytime I
just pass in the variable and let
Singh Rathore [EMAIL PROTECTED] wrote:
Hi,
While using insert command on one of my table, In
V$SQLAREA I found below data for that table. Can
anybody help me why I am gettting this?
select
SQL_TEXT,ROWS_PROCESSED,DISK_READS,BUFFER_GETS
from v$sqlarea ;
SQL_TEXT
Hi,
While using insert command on one of my table, In
V$SQLAREA I found below data for that table. Can anybody help me why I am
gettting this?
select
SQL_TEXT,ROWS_PROCESSED,DISK_READS,BUFFER_GETSfrom v$sqlarea ;
SQL_TEXT
ROWS_PROCESSED
DISK_READS BUFFER_GETS
insert
PROTECTED] wrote:
Hi,
While using insert command on one of my table, In
V$SQLAREA I found below data for that table. Can
anybody help me why I am gettting this?
select
SQL_TEXT,ROWS_PROCESSED,DISK_READS,BUFFER_GETS
from v$sqlarea ;
SQL_TEXT
'''joy'''
-Original Message-
Sent: Monday, June 18, 2001 6:25 PM
To: Multiple recipients of list ORACLE-L
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Harvinder
--
Please see
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Harvinder
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
INET: [EMAIL PROTECTED]
Fat City Network
Hello Harvinder,
If you are doing the insert from SQL*Plus, double up on the
quote. For example:
insert into your table (name) values ('''joy''');
The resulting value will be (quotes included):
'joy'
BTW, this came in handy recently when I went to a web site
(I won't say whose) and tried
2001 15:25:22 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: how to insert quote in a column
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Harvinder
--
Please
;
and you will get 63,
and doing select chr(63) from dual; will get you a ?
hope it helps,
raja
--
On Mon, 18 Jun 2001 15:25:22
Harvinder Singh wrote:
Hi,
I have a column defined as varchar2..i need to insert name like 'joy' in
it with quote
how can we insert quote(') to column.
Thanks
Hi!
How do I insert a very long string of text (about 200k in notepad) into a
LONG column with a standard SQL insert command?
What would be the best way to achieve this?
This is 8.1.6 on Win2k.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Helmut
PL/SQL will let you go up to 32k, after that you're
into 3GL (for a LONG). If you use LOB's then you have
more options..
hth
connor
--- Helmut Daiminger [EMAIL PROTECTED] wrote:
Hi!
How do I insert a very long string of text (about
200k in notepad) into a
LONG column with a standard SQL
I am trying, for the first time, to use bulk binding on insert.
Assuming I have a type defined as MESSAGE_CONTENT%ROWTYPE INDEX BY
BINARY_INTEGER, and a variable, v_message_content, of that type: I've tried
the insert as
FORALL i in 1..fcount
insert into message_content values
;
v_message_content message_content%TYPE
INDEX BY BINARY_INTEGER;
FORALL i in 1..fcount
insert into message_content values (v_order_event_id(i),
v_message_field_id(i),
v_message_content(i));
Kevin
-Original
by tables:
v_order_event_idmessage_contentorder_event_id%TYPE
INDEX BY BINARY_INTEGER;
v_message_field_id message_field_id%TYPE
INDEX BY BINARY_INTEGER;
v_message_content message_content%TYPE
INDEX BY BINARY_INTEGER;
FORALL i in 1..fcount
insert
If the production environment is already available, you could use
DBMS_STATS.EXPORT_TABLE_STATS on the production table
and import those stats into your development instance.
Regards,
Chris Gait
On 18 Apr 2001, at 11:00, Murali Vallath wrote:
Thanks for the feedback, I am coming from the
Dear DBA Gurus,
I have Table A and Table B whose structures are almost similar except Table
B has a date-time field column. Whenever I insert a new record into Table A
I want to insert the same record into the Table B along with the date-time
stamp at which the new record is inserted
Hi Gurus,
I got the solution. Here is the modified code:
create or replace trigger trig_dept1 after insert on dept for each row
begin
insert into dept1(deptno, dname, loc, date_time) values(:new.deptno,
:new.dname,
:new.loc, sysdate);
end;
Thanks Rob Fegan and Amol Joshi
rows selected.
SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80)
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
BTW, the synonym is for the table so other users can
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80)
*
ERROR at line 1:
ORA-01732: data manipulation operation not legal on this view
BTW, the synonym is for the table so other users can access it without
I ATTRIBUTE PROMPTNAME SORTORDER
-- - -- --- -
T F SN Temic Accelerometer SN 30
T SN Actual Serial Number 10
A F SN Accelerometer SN 40
C F SN Customer SN 20
D F SN Daughter Board SN 60
S F SN Sensor SN 50
6 rows selected.
SQL insert
SN Temic Accelerometer SN 30
T SN Actual Serial Number 10
A F SN Accelerometer SN 40
C F SN Customer SN 20
D F SN Daughter Board SN 60
S F SN Sensor SN 50
6 rows selected.
SQL insert into MFGALIASTYPE values ('X', 'F', 'SN', 'Test', 80);
insert into MFGALIASTYPE values ('X', 'F', 'SN
();
con.setAutoCommit(false);
/*
stmt = con.createStatement();
strSQL = INSERT INTO SITE VALUES ( +pk_site_id +,
+fk_category +,
empty_clob(), '+url+', empty_clob(), +siteStatus+, +page_hits+,
'+editor_choice
();
con.setAutoCommit(false);
/*
stmt = con.createStatement();
strSQL = INSERT INTO SITE VALUES ( +pk_site_id +,
+fk_category +,
empty_clob(), '+url+', empty_clob(), +siteStatus+, +page_hits+,
'+editor_choice
201 - 300 of 342 matches
Mail list logo