SQL%found
It's in the manual. :)
Jared
"Hagedorn, Linda" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/13/02 12:34 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:
Title: RE: How to find out Server model on unix?
uname -a
sample output: SunOS synapse 5.8 Generic_108528-08 sun4u sparc SUNW,Ultra-2
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 13, 2002 3:09 PM
To: Multiple recipients of
Title: RE: DB2
DB2-L is at RYCI.com. You can subscribe through the web front end
http://www.ryci.com/db2-l/, or you can do it through generic listserv
instructions below.
I had to change the u to a * in the word below to avoid the listserv filter, so you'll have to change it to the prope
Title: Branching logic in PL/SQL, positive instead of exception
Thank you very much Alec. You brought an interesting light to
this. I have to test about 8 different conditions, each turns on the
output of the previous. I'll give it a shot. Thanks very much for
the idea. Linda
-Or
Title: Branching logic in PL/SQL, positive instead of exception
Hello,
I'm looking for an example of structured PL/SQL code that does not use exception logic for branching, but instead recognizes that data is found.
As a bad example,
Select col1 from test.table t where exists (selec
nction to look at what is really in the field. Good
luck!
Bill
Carle
AT&T
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
-Original
Message-From: Hagedorn,
Linda [mailto:[EMAIL PROTECTED]]Sent: Friday, January 18, 2002 1:57
PMTo: Multiple recip
!
Bill
Carle
AT&T
Database
Administrator
816-995-3922
[EMAIL PROTECTED]
-Original
Message-From: Hagedorn,
Linda [mailto:[EMAIL PROTECTED]]Sent: Friday, January 18, 2002 1:57
PMTo: Multiple recipients of
list ORACLE-LSubject: Need
idea to strip
Title: RE: HP-UX 11/8.1.6.x/Index-Organized Tables
Create as/Alter table rename prod to backup/Alter table rename new to prod/
-Original Message-
From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 18, 2002 7:31 AM
To: Multiple recipients of list ORACLE-L
S
Title: Need idea to strip tabs (chr(9) hex 9) and carriage return (chr(13) hex 0D) from fields
Hi,
Sometime in the past, data was loaded into tables from spreadsheets and the tabs and form feeds were included in the data. I can locate all the bad data, and am looking for a clear method t
ssage-
From: Connor McDonald [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 11, 2002 9:21 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Inserting raw ascii into a varchar2 field
Checkout UTL_RAW.CAST_TO_RAW to convert varchar2 to
raw datatypes
hth
connor
--- "Haged
Title: Inserting raw ascii into a varchar2 field
Hello,
Does anyone have an example of how to insert raw ascii into a varchar2 field?
For example,
CREATE TABLE LH_test
( col1 varchar2(10),
col2 varchar2(10),
col3 varchar2(10) )
PCTFREE 0 PCTUSED 80 INITRANS 1 MAXTRANS 255
Title: DDL alter in execute immediate pl/sql procedure - dynamic sql
If someone has a few minutes to read through this, I'd be most appreciative. I could use a second set of eyes looking this over.
This procedure is designed to maintain a table/sequence map, executed after an import and i
Title: PL/SQL, UTL FILE dynamic read v$parameter
Hello,
Is it possible in PL/SQL to read v$parameter and pass the value for utl_file_dir to the UTL_FILE.FOPEN statement? This is my current attempt, and it's failing with the error, below.
select value into v_utl_file_dir_name from v
' ||
v_owner||'.'||v_table_name||';'
-
use dbm_sql package, i.e. create the statement in a similar way as above and
run it;
-
use native dynamic sql (see for example http://www.oracle.com/oramag/oracle/00-nov/index.html?o60sql.html).
Djordje
-----Or
Title: PL/SQL question
Can anyone can tell me how to use PL/SQL declared variables in a select statement where a . has to be between the owner and table name, and the owner and table name are variables, I'd be most appreciative. The answer is probably obvious... Feel free to point it out.
Copying
the software is not supported under 8i.
The
oraInventory and the ORACLE_HOME are hardcoded in the inventory. As long
as these paths are
identical on both systems, the copy should be ok. If the paths are
different on the two machines, you will
be able
to run the database on t
Title: Perl code example
Hello,
I'm looking for a Perl example passing parameters.
The code below has the userids and passwords hardcoded in clear text in the system line, parms 3 and 5 (five lines from the bottom), and the Oracle sid is hardcoded also. The code has to be changed to 1)
Title: AMA DBA
Is the AMA (American Medical Association) DBA here? Please write to me directly.
Thank you. Linda
Title: Egregious coding
Significant documentation has already been produced showing the
overhead associated with the code. The effect of shutting off
'literal only' sql on the QA system would centralize the problem in a single
location, and allow the parties involved to correct the code befo
Title: Egregious coding
Has anyone thought of a clever way to fail every SQL statement that does not use a bind variable that I could switch on and off as required?
I'm looking at hundreds of thousands of queries in the v$sqlarea in production. I've taken engineering management to t
Title: RE: OT - Vaccines
Paraphrased from http://dailynews.yahoo.com/h/ap/20010821/us/religion_immunizations_1.html
Casper, Wyo. U.S. District Court Judge William Downes barred the state of Wyoming Dept of Health from holding hearings to determine the level of sincerity about some parents r
Title: RE: OT - Vaccines
The NY laws allow for religious exemption from vaccinations in the school system: www.health.state.ny.us/nysdoh/immun/guide/immguid.pdf, page 16, "NYS Requirements for School and Post-Secondary Institution Attendance".
While the state school representatives may thin
Title: RE: OT - Vaccines
Remember, there is always a medical exception to any vaccine.
If someone has said, 'It's required', remember the US is not a communist state. They cannot hold you down and give you a vaccine, nor can they force you to have your children vaccinated. They will also
Title: OFA (Optimal Flexible Architecture) in practice
Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point?
e.g..
/u02/oradata/db_name1/userdata
Title: Outer join
I'm sure the answer is in front of me, but I don't see it..
Outer join on two tables, one with 1000+ survey rows, one with 11 description rows. Problem is the user wants to see all eleven description rows for all surveys, whether or not there are rows for the descrip
uot; for a wealth of
information.
-Original Message-From: Hagedorn, Linda
[mailto:[EMAIL PROTECTED]]Sent: Monday, July 02, 2001 2:31
PMTo: Multiple recipients of list ORACLE-LSubject:
Disk layout for datafiles
I found and then lost a Metalink
docum
I found and then lost a Metalink document about laying out datafiles
under five or seven mount points. Does anyone have a link to this note, or
any regarding datafile naming conventions/path layouts for unix/sun?
Thanks, Linda
Title: Reorg wizard, batch mode, Solaris
Hello,
I'm looking for a reorg wizard job that I can put in cron to reorg two notorious tables while they are online. Has anyone written one, and if so, may I have a copy?
Thanks so much.
Linda
s
is a bitmap to indicate various statuses. dup: # of members in the group. ThanksRiyaj "Re-yas" ShamsudeenCertified Oracle DBAi2
technologies www.i2.com
"Hagedorn, Linda"
<[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]
Title: alter session set events 'immediate trace name redohdr level 10'
Hello,
I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example,
siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2
The size parameter is
Title: RE: Sun Solaris 8 - Listener failed to start a dedicated server p
It
could also be swap is filled. If you see Solaris Error: 12 in the
listener.log, there isn't enough space. Do a df -k and look for a mount
point that is 100% full. It is likely to be /tmp (swap).
Original
Title: RE: From SID to connected machine
I can get all the session info, but the machine name isn't externalized. By elimination I've found the problem machine is va8. Since I have the processes in place and they're not hurting anything, I have time to research.
Here is the sid/pid logic
Title: RE: From SID to connected machine
Thanks for the idea. It's not telling me the machine, though...
SID USERNAME OSUSER PROCESS MACHINE TERMINAL
-- -- -- - --- --
58 PALMAPP ora
Title: From SID to connected machine
Hello,
I'm looking to trace a sid from oracle to a pid on unix to a connection/socket/port to another machine. Server is Sun Solaris 2.8.
I'm trying to deimplement a userid and there is a connect string to it buried somewhere on one or more of eight d
Title: RE: DB Link Between Prod and Test?
I created a 'READER' id on production for our datawarehouse guys. The dblink connects from dw to production as user READER, and READER has select authority on the specific prod tables that they are supposed to be looking at.
DW has multiple ids. T
Title: Pl/sql loop assistance
Hello,
I'm having difficulty coding this loop and am hoping someone can see how this can be done.
I have two tables, one on each instance reg.docalert_responses@ncp and reg.docalert_emails_05040@ncc
The requirement is to set ncp.reg.docalert_responses.
Title: RE: Exp/Imp Fromuser/Touser & Security
If the sys password file was chmod 400, only the owner can read it.
And, the next time it has to be changed, it would have to be changed
in a single place to be picked up by any calling script. Crons are
owned by the same userid, so it all works
Title: RE: DB2 forums/listserves
Also, DB2-L
Send note to: [EMAIL PROTECTED]
Subject: blank or space
Body of note: subscribe DB2-L
DB2 Level 1 and Level 2 monitor this list, and all the vendor company reps
participate.
-Original Message-
From: Marin Dimitrov [mailto:[
Title: v$session_longops join to v$sqlarea
Hi,
I'm trying to identify some of the longops queries I'm seeing:
sofar totalwork message
7.2058E+16 7.2058E+16 29-MAR-0
Title: Linux, Sqlplus worksheet?
Hi,
I have a user who works on Linux and wants a SQL interface other than command line sqlplus. Since I don't use Linux, I checked my disks for a SQLPLUS Worksheet or OEM version for Linux to no avail.
Can anyone recommend a gui/java/etc. SQL processor
Title: SMON behavior
Today, smon has been running at the top of topsessions, and disk iowait according to TOP (Unix tool on Sun 2.7) was 65%. The I/O went down to 7% just a few minutes ago, and I'm not sure why but think it's tied to SMON. Last night, I used 'alter table move' to move a bun
Title: RE: Dropping datafiles
If this datafile is one of a group of datafiles, that is to say tablespace TS1 has multiple datafiles along with the one created in error, do not offline drop the datafile. Oracle knows of the datafile and offline drop does not remove the information.
Story: A
Title: .trc file management
Has anyone written and is willing to share a shell which would:
find the list of .trc files, tkprof the files to output files, grep the output files for the total line and email the file of total lines?
And
find the current .trc files and rm the ones olde
Title: RE: Anyone using CA products?
I ordered the Erwin and Erwin Examiner products and received it in a couple of days. This is my rep, and he's really a good guy.
> For Information on our Enterprise Modeling Suite Products:
> http://www.cai.com/products/alm/products.htm
> Andrew W. Wint
Shafer
San Antonio, TX
> -Original Message-
> From: Hagedorn, Linda [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, February 08, 2001 10:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Enqu
Title: Enqueue types
Does anyone recognize enqueues JI, TC, and TX? (Steve, are you on?)
SELECT *
FROM x$ksqst
WHERE ksqstget > 0;
EVENT TOTAL_WAITS TOTAL_TIMEOUTS TIME_WAITED AVERAGE_WAIT
---
46 matches
Mail list logo
