RE: aix tools

hi... can you anyone tell me what is aix tools.. is it related with oracle tools... Please anyone tell me use of this tool. regards, Nirmal., -Original Message- From: Deshpande, Kirti [SMTP:[EMAIL PROTECTED]] Sent: Saturday, August 25, 2001 2:22 AM To: Multiple recipients of

tab ascii value

Hi lists how to find out the ascii value of tab, new line for new line it is 10 for tab it is 9 but how to get from the following statement. select ascii(??) from dual; srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED,

pl/sql examples

hi can anybody post me some sites that have example queries of pl/sql thnx in advance srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

OPS on LINUX

Hi, 1) I have set up a cluster of INTEL machines on INTEL PIII using LINUX Redhat 6.2 . 2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database is on raw devices. 3) When I try to install OPS option , I get a message saying OPS not supported on LINUX . Has any one been

v$sgastat

Hi lists what is the precision of the number datatype, if not in a table. is it 1 or 32. (in v$sgastat the column bytes doesn't have precision,scale mentioned. this column values should be stored in our routine tables.) If I take the maximum ,I may be wasting the space. can anybody advise

fire the trigger selectively when a column is updated

Hi everyone, One of my developers wanted to know if it is possible to write a trigger only if a particular column is changed, essentially making it a column level trigger.I gathered from the article below that it is possible in SQL server. Just wanted to know if this is possible in oracle.

CLUSTER_LISTENER !!!!!

Hi everyone I recently had a strange behaviour on the on database, I have donbe that on several occasions but nothing of the sort ever happened, maybe it's because I am not that familiar with databases on cluster machines. This is HP-UX. We had to replace a disk in one of that machine,

Re: OPS on LINUX

Shreepad Vaidya wrote: Hi, 1) I have set up a cluster of INTEL machines on INTEL PIII using LINUX Redhat 6.2 . 2) I have installed Oracle 8.1.6 on LINUX redhat 6.2 . The database is on raw devices. 3) When I try to install OPS option , I get a message saying OPS not supported

Re: Interesting Problem

Srikanth, What is the NLS_LANG setting of the clients using the front-end app? Sounds like they're set to US7ASCII so they would automatically replace any extended ascii characters with a '?'. I know at one point the default NLS_LANG setting for Windows clients was US7ASCII, but I can't

RE: aix tools

It means Tools for AIX (IBM's UNIX version). Not related to any of the Oracle Tools. top is a UNIX Operating System command (a program, if you will) that shows the top users of the CPU. It also summarizes the overall activity on the system related to memory, load and CPU etc. If you have

Re: OT - File System to Disk Mapping

On Thursday 23 August 2001 02:00, Jonathan Lewis wrote: A logical volume is not necessarily associated with a single disc I made a painful discovery in that regard one time. Well into a perl script to display drive/tablespace mappings, I discovered that the volume for my TEMP tablespace had

Re: OT RE: How do you audit a DBA?

If you're a DBA long enough, you can grow your own. :) Jared On Friday 24 August 2001 06:16, Thater, William wrote: Scott Shafer wrote: If the folding metal chair at my computer desk wasn't so cold, I wouldn't bother... --Scott two words: seat cushion.;-) -- Please see the official

Re: startup time v7

On Friday 24 August 2001 12:00, Scott Canaan wrote: The julian date is the year plus the day number of the year.nbsp; Today Scott, That's a popular misconception. While that may be a useful date string, it is not a Julian date. A julian date is somewhat more complex than that. If it

Re: system trivia (groove/programming): DOS prompt/etc and choppy sound

Here's a stab in the dark: Windows still doesn't know how to gracefully handle software interrupts? Jared On Friday 24 August 2001 18:15, Eric D. Pierce wrote: system trivia question: when using windows explorer, etc., dos prompt (e.g., sqlplus) and running music CD, the sound get choppy

OT : Writing Documentation

Hi everybody, Sorry, I realise this is a bit off topic - but I need to ask a question of all those developers out there. At the moment, the company I work for has a Web Developer position vacant (working with ASP/ColdFusion with a SQL 7 Database Server). SQL 7 isn't