Hallo,
I am trying to create this statement but dont get it work. I would like to check if a
field information from table one exists in table 2, and if that exists in table 2,
then procedure test_proc would run,
Please help me with this.
Thanks in advance
Roland
--
Please see the
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 9:54 AM
Note that ASSM bitmaps track freeness not fullness, to be correct in
terminology.
Hi Tanel,
At restaurants, I always say to the waiter that my glass of wine is only
Hi,
does anybody out there have a paper that describes how to set up 9i on a
Win2k cluster? We need to test the cluster capabilites fo the database.
Thanks,
Helmut
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Daiminger, Helmut
INET: [EMAIL PROTECTED]
Fat City
Running OS/2 on all our PCs...
Patrice.
-Original Message-From: Bellow, Bambi
[mailto:[EMAIL PROTECTED]Sent: Friday, November 07, 2003
3:30 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Uncle Larry, wake up!!!
And
seeing eachother at DECUS.
Hi Sami,
The issue you mention is a conundrum!. I think you need to consider
which is the greater risk and use your judgement to secure against this
particular issue.
I mention the same issue in the SANS book Oracle security step-by-step
that it is advisable to use a profile and set
Hi everyone,
I have recently written a paper on row level security in Oracle for
publication by security focus. This paper is a two part paper and the
first part is published, the second part will be published later this
week.
part one introduces row level security, talks about the various names
I cant find any specifics in the docs. I must be missing something. All I see is
'session specific information'?
Does this mean package variables? SQLPLUS bind variables? What does this mean?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET:
I checked v$db_object_cache on several of our instances and found that none of our
objects in the shared pool take up much space.
Does anyone have any objects need to to go to the reserved pool? Like what? All the
shared pool is storing are execution plans, etc... how could that take up enough
Wait for 10g. They say that you could just copy the datafiles and them plug
them in to he new database, even across platforms.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 12:24 AM
Hi List,
Could
Thanks, Richard. My PC died this weekend (it's getting CPR right now)
and I couldn't respond. I believe you now, but I still want to know
what Metalink has to say about it. The documentation didn't do a
very good job of explaining this thing.
On 11/10/2003 04:19:29 AM, Richard Foote wrote:
It raises an interesting question. As of today, we have datafiles which are OS
dependent and _not_ binary compatible from one system to another. We upgrade to 10g
and it will become magically binary compatible. Which means that the upgrade process
will do more intimate things than updating some
Yes, you are right, of course. Using large PL/SQL tables and
string manipulation (INSTR,SUBSTR and alike) are known to be
CPU intensive and there is no way around it. The only way
to help an application which uses those functions extensively
is to add a column which extracts portion of the
Hallo,
I would like to do the following with an sql( pl/sql) statement.
I have table1 and table2 andtable3.
I want to check whether field1 in table1 exists in table3. If so then I want an insert
statement to be run...insert into table3.
If it doesnt find that value then th escript will go
Hi Tanel,
It sounds like the sort of command that i will be adding to my security
audit checklists and scripts. If access to it were available to a
malicious employee he could kill the database without OS access!. Is
there a restriction that it can only be run locally? or when the
database is not
RTFM
RTFM
RTFM
RTFM
Do your homework! Read the oracle documents, buy a book from Amazon/Bookpool/Softpro
and put in a little effort.
If has_done_homework = 'Y'
then
list_answer = 'Y';
else
list_answer = 'NO!';
end if;
[EMAIL PROTECTED] wrote:
Hallo,
I would like to do the
In article [EMAIL PROTECTED], Vladimir Begun
[EMAIL PROTECTED] writes
Less number of inexpensive instructions is everytime better (I'm not talking
about lines of code).
Trace it -- 10046/12 + dump instructions using appropriate event.
Hi Rachel
In most Java applications I've seen so far, the issue of caching rows by an
id, which is usually the primary key, arises. JDBC v3 implements a method
which allows you to return a key after the insert completed (for example MS
SQL Server can do this). How do you get a hold of the PK,
in this particular app, we were registering new users and the pk didn't
need to be returned (email address was a unique field).
--- Stefan Jahnke [EMAIL PROTECTED] wrote:
Hi Rachel
In most Java applications I've seen so far, the issue of caching rows
by an
id, which is usually the primary
You can't just copy over the files with os commands and hope that Oracle
will somehow recognize them.
You have to use RMANs new convert tablespace command to do the byte order
conversion.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
insert into table (...) values (...) returning table_pk_column into :my_var
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
Hi!
From my previous post: it works only on exclusively mounted and not open
database, and with restricted session instance mode
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 10, 2003 5:19 PM
Hi Tanel,
It sounds like
Below are two dummy procs that are good enough to explain the issue (Jared
forgive me for posting this big code).
All the code in proc test_plsql1 is inside an IF clause that will not run.
Testing the proc call is done using this:
---
declare
a varchar2(1000);
b varchar2(1000);
Download the Oracle Failsafe for MSCS from OTN. It's all in there ...
-Original Message-
Sent: Monday, November 10, 2003 3:34 AM
To: Multiple recipients of list ORACLE-L
removed remove list e-mail in the Text body.
Hi,
does anybody out there have a paper that describes how to set up 9i
Tanel,
Any idea about speed and temporary storage requirements? Especially for 32G+
datafiles ;-) ?
Wondering if it will really be useful in practice, compared to what is available
today. Well, it may do for simpler operations, but not necessarily faster.
SF
- --- Original Message
hmmm me curious too ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original
Oracle has RETURNING clause for insert.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Stefan Jahnke
Sent: Monday, November 10, 2003 10:34 AM
To: Multiple recipients of list ORACLE-L
Hi Rachel
In most Java applications I've seen so far, the issue of caching rows by
an
id,
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
Hallo,
I would like to do the following with an sql( pl/sql) statement.
the answer to your question can be found by reading either the manuals or
any pl/sql book, with examples. this is the same thing as all the other
questions
... and for updates,delets as well ...
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
If the logic depends on multiple IF statements based on
which patterns the input strings match, it might be better
to store the patterns in a PL/SQL table and find out the
index of the matching pattern and then base the decision
on the index value and not by repeatedly using LIKE ...
something
Friends --
One of my associates came up to me Friday with a question. It seemed easy
enough. I mean, I've been doing stuff like this for years. The question
was, I have duplicate ids here, some with X field null, some without. I
want to get rid of all the duplicates where X field is not null.
I did a quick test with autotrace and here are the results. The bottom
line is that the inline query used 6 i/os, the subquery used 46. (Irepeated
this test multiple times, same result).
1 select e1.rowid,
2 e1.empno,
3 e1.ename
4 from emp e1,
5 (select empno, min(rowid)
min_rowid
6 from
Im sure on the DB side this is the same for Java and C/C++ also.
The OO guys pass us an array. When I write my code, I need to define a PL/SQL table
that maps exactly to the array correct?
Our middle tier is having problem doing bulk inserts since its doing one at a time and
I believe it
True,
Just in this case insert was a point of discussion.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Jamadagni, Rajendra
Sent: Monday, November 10, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
... and for updates,delets as well ...
Well, I don't know about it's performance, but I think this conversion
doesn't require any temporary space, because the byte values of some
structures in blocks have to be swapped, and this a trivial operation.
I think it may still be faster, especially if we are dealing with huge
amounts of
It is a little convoluted, but you can use an inline query. It is not a
correlated subquery, it may be more efficient, your mileage may vary, contents
under pressure...
Here is an example of the select using the old, reliable emp table that
Ipopulated with duplicates.
SQL> l
1 select e1.rowid,
Hi Davis Pete Finnigan,
Thank you so much for your response. Let me go through
Pete Finnigan's security related white papers.
-Sami
-Original Message-
To: [EMAIL PROTECTED]
Date: Mon, 10 Nov 2003 16:56:13 +
The type of attack you are suggesting is a problem that exists with all
Pete Finnigan wrote:
Less number of inexpensive instructions is everytime better (I'm not talking
about lines of code).
Trace it -- 10046/12 + dump instructions using appropriate event.
^
what instructions? and what events do you
SELECT id FROM test_table WHERE LENGTH(testcolu) = 0;
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
Seema Singh wrote:
What SQL I have to use.Is there any way can i know what are those
columns were updated
Thanks
Folks!
The
inline query, indeed, beat the correlated subquery.
Bambi.
-Original Message-From: Daniel Fink
[mailto:[EMAIL PROTECTED]Sent: Monday, November 10, 2003 11:34
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Life without a correlated subqueryIt is
You can't use a PL/SQL table in ODP.NET. ODP.NET currently does not
support object type or collection type:
http://forums.oracle.com/forums/thread.jsp?forum=146thread=211399tstart=0trange=15
Your best bet would be to use array binding i.e. bind an array to the
OracleParameter object and set
hmm
earlier in the year i was on a project where I wrote alot of backend PL/SQL that was
called through the middle tier. I have no idea how this works. I just assumed it came
straight through .NET.
any idea how they might have done that? The front end was a .NET architecture. Sorry
for
ignore most of my last question. I didnt see pl/sql 'table' just saw pl/sql
my bad. sorry
From: David Hau [EMAIL PROTECTED]
Date: 2003/11/10 Mon PM 01:44:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: passing an array variable from a .Net middle tier to a
Given that I've been developing in .NOT for the past 6 months, I figured I'd
chime in here
.NOT can call PL/SQL just fine. If you use Oracle's ODB.NET (that's Oracle
Data Provider for .NET -- a free download from otn.oracle.com), you can use
bind an array to a PL/SQL call. In fact, if you
sounds like your not a fan of .net, with the .not reference? why?
From: Kevin Toepke [EMAIL PROTECTED]
Date: 2003/11/10 Mon PM 02:09:27 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Re: passing an array variable from a .Net middle tier to a da
Given that
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find anything.
Thanks!
Ron Smith
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Smith, Ron L.
INET: [EMAIL
it's in the Schema Naming Rules (I think that's the section) of the SQL
Reference manual.
A little creative thinking got me to create user in the SQL manual
and from there to the hyperlink to the Naming Rules.
On top of that, you can write your own password verification routine
and put it in the
Look in the manual at table naming rules. As I recall Oracle passwords
follow the same general rules as table names.
--Walt Weaver
Bozeman, Montana
On Mon, 2003-11-10 at 12:19, Smith, Ron L. wrote:
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked
Ron,
additional info
Oracle Press Oracle 8i DBA Handbook pg 396 - 402
Ron
[EMAIL PROTECTED] 11/10/2003 2:19:26 PM
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find anything.
Thanks!
Ron
Version 8i.
The Oracle password complexity routine is activated if you run the
rdbms/admin/utlpwdmg.sql
It basicaly checks for passwords from a common name list, checks if the
password contains at least one char, one digit, and one punctuation. It
also checks if the new is different by 3
Smith, Ron L. wrote:
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find anything.
Thanks!
Ron Smith
Ron,
Passwords follow the same rules as identifiers, they are internally
Nope. I'm not a fan of .not.
Some of the reasons are the lack of power and flexibility of the exception
handling. The inconsistencey of calls, the fact that you need to do a
round-trip from the page to the server to do most tasks (Jscript is
available, but there is no integration with the
I created such a beast a few years ago.
The 'customer' gave me no choice. The unique ID for a record
had to be the current date+Id, and the idea had to start over every
day at midnight. That was an interesting bit of code. It certainly
wouldn't scale, but this was very low volume OLTP, so we
why? Smith
Neo
-Original Message-
Sent: Monday, November 10, 2003 1:19 PM
To: Multiple recipients of list ORACLE-L
Can anyone tell me the requirements and characters for a valid Oracle
password. I have looked through the Oracle 8i documentation CD and I
can't seem to find
In my past experiences we had a PK created from a source location name
ie: BOST,followed by the julian date,followed by a sequence number with
a max value . The maximun for the pk was 12 characters. Ho would
have more than 1 entries in a day from one location. The complete
testing of the
According to what you said, the OO guys already pass an array to the
database. In this case, they most likely are already using array
binding. With array binding, you don't need to define the variable to
be a pl/sql table on the DB side. All you need to make sure is you use
bind variables
How about using Minus? (I'm a set operator groupie.) It usually performs
well for me, though I've done no detailed analysis.
delete from theTable
where rowid in
(
select rowid from theTable where X is not null
minus
select min(rowid) from theTable where X is not null group by X
) ;
Jack C.
I have been working with Oracle on Unix - various platforms since Version 6.X.
For the first time a vendor has sent us an install that installs under the C-shell.
Up until this point I have always worked on and installed under the korn shell.
This introduces a different shell environment in our
I think you should make an issue, because Korn Shell (/bin/ksh) is de-facto
standard and the vendor should deliver either both shells (Korn and C) or
only Korn. Allegedly, bash can assume both personalities, but if you need
to modify the script, you need it to have it in Korn Shell language. Of
Paula --
If you want to change your shell, just enter the name of the shell on the
command line and press return. You will spawn a new session in that shell.
To revert to your previous shell, just exit the same as you would to end
your current session.
HTH,
Bambi.
-Original Message-
[EMAIL PROTECTED] wrote:
I have been working with Oracle on Unix - various platforms since Version 6.X.
For the first time a vendor has sent us an install that installs under the C-shell.
Up until this point I have always worked on and installed under the korn shell.
This introduces a
We are using Korn and I have for years used C, borne etc. Now we are converting all to
use Perl so we can only have one set of scripts to support over other platforms.. I
supposed its a good Idea but like you I hate to keep changing when you are at expert
level at one and have to start over.
For Linux, I use bash. For Unix (HP/Sun) accounts, I use Korn, where bash
typically isn't available. I like either, but am tending to like bash more
for the non-vi command line editing that uses cursor keys (I've been told
that this is set -o emacs in Korn, but it shore don't work like that on
Paula
Ensure the first line of the file has something like
#! /bin/csh
I agree with Brian that if you're simply installing this application with no
requirement to maintain it, then no worries. If you end up maintaining it,
beware. C-shell superficially resembles bourne/korn shell, but
Hi!
NAMESHARABLE_MEM
---
TEST_PLSQL1 185607
TEST_PLSQL5 9123
A lot of junk, right? :)
PL/SQL engine works with interpretive code, it does not have any
optimizations -- here I do simplify, so do not consider this statement
as an absolute truth -- like,
You can get current korn shell source from http://www.kornshell.com/
Jared
Jesse, Rich [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/10/2003 01:54 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: for
Hi Stephane,
The way you put it here would mean that the internal format of the
tablespaces will be big/little-endian independant.
That would mean either an extra amount of overhead in the low level IO,
or
Oracle-specific arithmatic everywhere in the kernel. I doubt
whether
Oracle would do that.
Hi!!
I am doing a query that have to result the top 1 from a nother
query. When I run the query it returns me this error:
ORA-00904:
"TB_EDORESULT"."ITEM":invalid idenfier
First I was thinking that was because something was misspell,
so I put comment (--) infront of
ictrans.item =
Hi LIST
Thanks Waleed fot the code. I did some extra tests, following Connor's
suggestion:
I created 4 extra versions of the testplsql5 procedure.
So I ended up with 5 versions, each with 4 parameters, the first having 4
in out parameters, the second 1 in parameter and 3 in out parameters and
Rich
So do you use bash for interactive or to write scripts? The trap many
fell into (and apparently still fall into) is that cshell is excellent for
interactive work, but isn't so great for scripting. That is the power of
korn, a friendly interactive face and a powerful scripting capability.
Check these links:
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:465407252404
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:406369945838
Also refer to
http://otn.oracle.com/pls/db92/db92.drilldown?remark=word=UGAbook=preference=
HTH
GovindanK
Oracle
Check this
http://asktom.oracle.com/pls/ask/f?p=4950:8:F4950_P8_DISPLAYID:531147287002
HTH
GovindanK
Oracle Certified Professional(8,8i)
Brainbench Certified Master DBA(8)
On Sun, 09 Nov 2003 20:59:25 -0800, Arvind Kumar
[EMAIL PROTECTED] said:
Hi all,
is there a way to monitor
Arup
I suggest you make it a two stage process.
- CTAS where rownum 1 to create the structure
and follow with
- COPY command.
quote
SQL set copycommit 1
SQL set arraysize 1000
SQL copy from dest_user/[EMAIL PROTECTED] -
insert dest_table -
using -
select * from source_table;
Array
See:
http://www.icsi.berkeley.edu/~fosler/csh-from-hell/csh-from-hell.html
http://www.grymoire.com/Unix/CshTop10.txt
DENNIS WILLIAMS [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
11/10/2003 03:54 PM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL
If the data volume is large, better import into one of the instances,
and use TTS to copy the datafiles to the other instance. That way
only one import will be taking place at a time and might result
in significant improvement in import time.
As Tanel suggested, you can build indexs in nologging
begin
select 'y' into dummy
where table3.column = table1.column;
insert into table3 blah blah;
exception
when no_data_found then
begin
select 'y' into dummy
where table2.column = table1.column;
insert into table2 blah blah;
exception
when no_data_found then
Carel-Jan Engel wrote:
It appears that the overhead caused by a 'call by reference' (in out)
will cost you some extra time. The 'call by value' appears to be cheaper.
PL/SQL User's Guide and Reference Release 2 (9.2)
8 PL/SQL Subprograms
Summary of Subprogram Parameter Modes
IN OUT -- actual
The question was not if it's a good or bad code. The question was why?
This is not the actual code that runs, just something that explains the
issue :)
So let's make it more interesting:
Let's keep the proc size unchanged while moving the end-if closer to the
main if clause, and changing if
Hello Roland,
Do you even need PL/SQL for what you want to do?
rsis I want to check whether field1 in table1 exists in
rsis table3. If so then I want an insert statement to be
rsis run...insert into table3
If the field *is* in table 3, you want to insert it into
table 3 again? I find that an
It seems it's not because of bad code :)
Replace any LIKE by = in the TEST_PLSQL1
it becomes ten times faster, although none of them gets executed!
Waleed
-Original Message-
Sent: Sunday, November 09, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
I had the same thought,
Khedr, Waleed wrote:
The question was not if it's a good or bad code. The question was why?
This is not the actual code that runs, just something that explains the
issue :)
I've provided a selfexplanatory fix of the 'bad' code, please review it.
You code uses standard.like, and a lot isntances of
80 matches
Mail list logo
