Open cursors
Can we set a limit to the number of open cursors per oracle user? thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Programming languages that make DBA's lives easier
PLSQL, java and shell scripting. Can't say perl...have yet to start learning it.
I don't know if you guys are having problems with your batch programs in
Windows...
but a few of the old DOS commands I used to use don't work on Win2k anymore...
like choice. And whenever I search for more information regarding Windows
scripting...
I stumble on WSH.
Any thoughts on this scripting language? Is this worth a DBAs time?
=)
Janardhana Babu Donga wrote:
> What are the good books you guys recommend for Shell Programming? I have old
> edition of UNIX shells by example (by Ellie Quigley). I need to replace this
> with some good book.
>
> Do I need to learn perl before reading PERL for DBAs? If so, what are the
> good perl books do you guys recommend?
>
> -- Babu
>
> -Original Message-
> Sent: Tuesday, February 18, 2003 1:04 PM
> To: Multiple recipients of list ORACLE-L
>
> I thought it might be worthwhile to say WHY I prefer ksh for most scripting.
>
> As one writer put it, use a language you know. I've used ksh for years, so
> that is certainly one big factor in preferring it. But, that aside, if you
> use mostly the Bourne Shell syntax and stay away from the some of the Korn
> Shell syntactical candy that doesn't do anything extra, then your scripts
> are very easy to read, and are mostly self-documenting. For me, that is a
> big advantage.
>
> If you use ksh, then you need to become reasonably proficient with a few of
> the more important utilities such as sed and awk/nawk/gawk and become
> familiar with good old regular expressions (wonderful stuff!).
>
> One area where ksh is weak is its inability to set up a two-way socket with
> a child process like sqlplus. Perl can do this (for example, by using
> IPC::Open2). With ksh, you can send to the child, and you can receive from
> the child, but you can't converse with the child. Even with the coprocess
> (which is a pain to use), you still have one-way communication at any given
> time. However, 99% of the time, ksh will work fine. For that other 1% (OK,
> maybe 2%), you either figure out a workable compromise with ksh, or you use
> perl.
>
> If you want some reading material, my recommendation is:
>
> Unix System V: A Practical Guide
> by Mark G. Sobel
>
> (There is also a version for BSD)
>
> This is a outstanding overview of Unix including sh, ksh, and csh
> programming; as well as good introductions to sed, awk, and regular
> expressions. It also has chapters on emacs and vi ("Remember, vi is your
> friend."). Amazon has the 3rd edition listed with a publish date of 1995.
> So there probably is some rather outdated info in the book on stuff like
> gopher, archie, possibly Mosaic (Oh hey, cool!). Just ignore this. All
> the other stuff is still completely relevant and presented in what I think
> is the perfect level of detail -- not too verbose; not too terse -- with
> good examples.
>
> Eventually, to get seriously cooking with sed and awk, you will need to get
> something like the O'Reilly sed and awk book. But, for ksh programming: If
> you work through the Bourne Shell and Korn Shell chapters of the Sobel book,
> it is likely that this book is all you will ever need. Another wonderful
> thing about this book is that it doesn't use the current trend of big fonts
> with big margins and thick paper to create a monster sized book. Instead,
> you get lots of information in a book that takes up little shelf space.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Stephen Lee
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Janardhana Babu Donga
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
&g
Re: RMAN: I don't trust it
Going back to the topic. I've been trying to avoid using RMAN for a long time... I've always been confident with my own scripts... But once you start getting more and more servers...more and more databases and on different platforms...you can get tired making separate scripts for windows and unix. Checking it one by one and when you change something...change it on each server. And another thing I liked about RMAN is that it checks each block for corruption and it copies only used blocks. Saves a lot of space. You can't do that with a file backup. =) Michael Fontana wrote: As a longtime Oracle DBA who has used many products, including RMAN, I find myself guilty of a paradoxical mistrust of RMAN, dating back from the time when Oracle has tried several products, including integration with Legato and other hardware/software backup vendors, without a consistent direction. In the little I've used RMAN, it seems quite complex and kludgy. Even the nomenclature and commands used by Oracle within the product are a challenge to learn. While I can get RMAN to work for most simple, basic and predictable recovery scenarios, true recovery situations are never so neat and clean. This is not an advertisement for any particular product, but we've had great success in my shop with a product called SQL*Backtrack from BMC. I've also heard that Veritas makes a good product, but I've not used it. From what I've seen of RMAN, at least so far, I feel far more confident with the home-cooked scripts I've been using for years. Any comments, or other interesting experiences? Perhaps we can do a list poll of favorite/preferred backup software? -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit of victory."
Re: RMAN: I don't trust it
I too have seen too many DBA wannabes...mainly because of the pay Once they're in to it...only then do they see how complicated the job really is... Lyndon Tiu wrote: > On Wednesday 12 February 2003 08:14 am, DENNIS WILLIAMS wrote: > > Lyndon > >A rule of thumb in job-seeking is when you don't have experience, your > > education counts all the more. > > I agree. No Comp. Sci. education means - To quote Oracle 9i: "Unemployable, > Can't break-in, Just can't get it". > > > This applies when you are just starting your > > career or when you are changing careers. I haven't seen too many DBA job > > postings that require a BSCS (always glad to be educated, though), but I > > can see if there were two candidates who had no Oracle experience or other > > IT experience, the one with a BSCS might be selected. > >Have you considered getting the OCP? > > I have OCP, SCJP, LPI, SCSA, SCNA, EIEIO. I do believe that these > certifications are worthless without job experience. > > Order of importance: > > 1) People you know (i.e. kiss ass) > 2) Experience > 3) Education > 4) Certifications > > > One heck of a lot less effort than > > a BSCS, and might carry more weight when being considered for a position. I > > don't think the OCP is a cure-all, but I think it can demonstrate a sincere > > interest in an Oracle career. Think of it as a way to separate yourself > > from other wannabes. > > I work for a company where a third are wannabes, and they kiss ass better than > me : \ > > >My impression is that during the dot-com wave a lot of people crowded > > into the IT field, and some of them jumped on Oracle. That might leave the > > field crowded at the moment, but any field has turnover. Some people become > > discouraged, others find other careers that suit them better, etc. If you > > take a 20-year perspective, the Oracle DBA field has nearly always had more > > demand than supply. Hey what am I saying . . . no way! If anyone on this > > list is getting discouraged, this is the time to pursue that truck driving > > career you've always dreamed of. Go! Hurry! ;-) > > > > I will be while before things get cleared up. By then, I'll be a pensioner. > > -- > Lyndon Tiu > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Lyndon Tiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit of victory." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN: I don't trust it
And with ascii files, security becomes an issue. Its easy to change data and load it back without errors... And its easy to see confidential data too. =) [EMAIL PROTECTED] wrote: > Lyndon, > > Beacuse it's proprietary. Any dunce can create a flat ascii text file, > which probably accounts for the wide audience it gets. But it takes a PHD to > read a binary one. BTW: IBM and M$'s dump files are binary as well. > > Also, Oracle's default installation does scale, although not as well as it > should. And to boot that's the reason your boss pays you. Look at as job > justification. > > Dick Goulet > > Reply Separator > Author: Lyndon Tiu <[EMAIL PROTECTED]> > Date: 2/11/2003 10:34 AM > > Quoting [EMAIL PROTECTED]: > > > Lyndon, > > > > True, an export file is peculiar to Oracle. The difference > > between a > > commercial database and an open source one. IBM and MicroSludge do > > the same. > > The functional purpose though is the same. > > Question: > > Why a binary file? More efficient? I find the plain text output more > useful and easy to store. Recovery is easier as well, just cut and > past the relevant lines of script and run it. > > -- > Lyndon Tiu > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Lyndon Tiu > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit of victory." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle License for Training
Hello Mogens, I really got interested with your reply. You seem to know a lot about how Oracle works with their licenses. Is this information just your opinion or you know it for a fact? I'd really appreciate if you could give your "legal" opinion, about what we plan to do. For starters, we plan to offer on-site trainings. I would be using Oracle software on my laptop. And maybe have the trainees install Oracle software on each of their PC's. I may or may not provide them the software. In any case, we would need at least one Oracle installation available for demos and hands on exercises. Eventually, we will be offering training for individual clients. Once we get the money to set up a place and get machines. But when we do, I am sure we still cannot afford to buy full use licenses for Oracle on those machines. We plan to make everything legit, including business registration, taxes, contracts with clients etc. Do you think we would have problems with Oracle with our use of downloaded software on a laptop for trainings? Why do you think that the licensing terms (for training) would not hold up in court? Is this loophole based on an international law or agreement or something? I really appreciate this information you are sharing. Thank you very much. =) Mogens Nørgaard wrote: > When Klaus Andersen (the guy who hired me into Oracle Denmark in 1990, > and now is Managing Director of Microsoft Denmark) was head of Oracle > Education world-wide he put into the standard license terms that you > cannot use Oracle software for training of 3rd parties. > > Klaus is a very smart guy. I think he knew back then that those sort of > conditions would never hold up in court - but it kept a lot of > competitors out of the arena for many years because they were afraid of > big, bad Oracle Legal. > > Combine that with the fact that Oracle Education's terms for partners > are much worse than Microsoft's, and you get the idea: Oracle want to > keep competition out. > > That doesn't hold up very well in courts around the globe. > > If you challenge this foolish provision (or rather: If Oracle really > dares take you to court over it) I don't think you have to worry. In > fact I think I know you don't have to worry :-). > > Yes, doing on-site training is a workaround. So is doing seminars with > demo's on your laptop. But if you have valid licenses and want to teach > various people in your garage, I don't think they can do anything about it. > > Do I sound like a guy who's spent some time on this topic? Yep. :-). > > You're most welcome to call me (consider the time - I'm on Central > European Time) on +45 2527 7100 if you have any questions. > > Best regards, > > Mogens > > Maria Aurora VT de la Vega wrote: > > >A couple of friends and I are thinking of putting up a small training > >company here in the Phils. > >(When we say small...its really small with almost 0 > >capitalization...just sheer guts and technical knowhow) > >We have looked at OTN and checked the licensing terms for the use of the > >software for training. > >We have stumbled on this provision: > >You may not: > >·use the programs to provide third party training; > >I was wondering if any of you know if there is a different licensing for > >training institutions? > >How does a non-oracle partner acquire license to use Oracle DB software > >for training? > >I am looking at partnering with Oracle, but we are just starting and > >partnering costs $$. > >I dare not call Oracle Philippines just yet...If there is a need to > >purchase, and if we have the money, only then will we contact them. > > > >Thanks. > > > >=) > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ----- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "Failure is only postponed success as long as courage 'coaches' ambition. The habit of persistence is the habit of victory." -- Please see the official ORACLE-L FAQ: h
Re: Oracle License for Training
Interesting idea! =) I'll look through the license agreement (OTN) again. Then find a lawyer who's willing to be a partner... And who knows... Thanks a lot to Dennis W, Tim G, Dick G, Stephane F, jeremy P and Markus R! Thanks to everyone! I'm still open to any input/ideas/partnerships(?). Feel free to email me. I'll let you guys know how this little venture goes. =) DENNIS WILLIAMS wrote: > Markus - That is what I call a creative solution! I'm no lawyer either, but > excellent! > > Dennis Williams > DBA, 40%OCP > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, February 05, 2003 9:34 AM > To: Multiple recipients of list ORACLE-L > > Did you ever consider that your (prospective) trainig candidates get the > (for testing purposes freely downloadable) oracle software themselves and > install it themselves (or assisted by you) on a good (linux - one might hope > ;-)) box and then you assist them by getting along with this? > > I think this means, that you would not provide the software yourself - this > is done by your traning candidates. > > As I am neither a jurist nor a lawyer, so I hope this is not pure nonsense - > especially regarding the license agreement on technet.oracle.com. > > Apologies for any typing mistakes I failed to notice > > Markus Reger > > Oracle Applications DBA > Webmaster > MBC > University for Music and Performing Art > Vienna > >>> [EMAIL PROTECTED] 02/05/03 06:15 AM >>> > A couple of friends and I are thinking of putting up a small training > company here in the Phils. > (When we say small...its really small with almost 0 > capitalization...just sheer guts and technical knowhow) > We have looked at OTN and checked the licensing terms for the use of the > software for training. > We have stumbled on this provision: > You may not: > ·use the programs to provide third party training; > I was wondering if any of you know if there is a different licensing for > training institutions? > How does a non-oracle partner acquire license to use Oracle DB software > for training? > I am looking at partnering with Oracle, but we are just starting and > partnering costs $$. > I dare not call Oracle Philippines just yet...If there is a need to > purchase, and if we have the money, only then will we contact them. > > Thanks. > > =) > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Markus Reger > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: DENNIS WILLIAMS > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega
Oracle License for Training
A couple of friends and I are thinking of putting up a small training company here in the Phils. (When we say small...its really small with almost 0 capitalization...just sheer guts and technical knowhow) We have looked at OTN and checked the licensing terms for the use of the software for training. We have stumbled on this provision: You may not: ·use the programs to provide third party training; I was wondering if any of you know if there is a different licensing for training institutions? How does a non-oracle partner acquire license to use Oracle DB software for training? I am looking at partnering with Oracle, but we are just starting and partnering costs $$. I dare not call Oracle Philippines just yet...If there is a need to purchase, and if we have the money, only then will we contact them. Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Reports: email
thanks everyone. we'll try this one more time. Shuja wrote: set all the parameters in the reports (desname=email, desformat=pdf, destype=email). In client server mode, client systems must be configured for the email, eg on windows Outlook or netscape as default email client, with all the smtp settings etc. Mails get sent using that account. Shuja -Original Message- From: Maria Aurora VT de la Vega [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 04, 2003 3:24 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Reports: email This is quite OT in a DBA forum. More of a developer question. How do I configure email in Oracle Reports. I have created the procedure but I need to know where do I place the SMTP host name? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more."
Oracle Reports: email
This is quite OT in a DBA forum. More of a developer question. How do I configure email in Oracle Reports. I have created the procedure but I need to know where do I place the SMTP host name? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tricky query question (oops)
Oops. Sorry...incomplete query...missed the dateinserted column...try this select prev.dateinserted "date", prev.status "orig_status", curr.dateinserted "change_date", curr.status "new_status" from (select rank() over (order by dateinserted asc) id, primarykey, status, dateinserted from table) curr, (select rank() over (order by dateinserted asc) id, primarykey, status, dateinserted from table) prev where curr.id-1 = prev.id and curr.status <> prev.status; -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more." Mark Richard wrote: > Hi All, > > This is a question for those who like writing tricky queries as a single > SQL... > > Assume I have a table with the following structure (imaginary table to keep > example simple): > > primarykey number(8) > status char(1) > dateinserted date > > > A row is inserted into this table any time one, or more, fields change for > the record. What I'm trying to determine is the "dateinserted" for each > time the value of "status" changed - remembering that there might be 50 > records for the primary key and five of those include a change in status - > I want the dates of those five records (plus the value of status at each > date). > > Is there any way to achieve this within a single SQL statement? I realise > that I could cursor through each record in date order and use a variable to > store the previous value of status - but I'd love to compress this to a > single statement. I've seen the syntax "OVER" used in some queries and > suspect this may be useful but I really don't understand it enough to know. > > Thanks in advance if you can help me on this one, > > Mark. > > PS: Sorry if this appears more than once - I've been getting mail server > failures all day > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message >(or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender >by reply e-mail or by telephone on (61 3) 9612-6999. >Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tricky query question
Here's a trick for you. Let me know if it works. select prev.dateinserted "date", prev.status "orig_status", curr.dateinserted "change_date", curr.status "new_status" from (select rank() over (order by dateinserted asc) id, primarykey, status from table) curr, (select rank() over (order by dateinserted asc) id, primarykey, status from table) prev where curr.id-1 = prev.id and curr.status <> prev.status; -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more." Mark Richard wrote: > Hi All, > > This is a question for those who like writing tricky queries as a single > SQL... > > Assume I have a table with the following structure (imaginary table to keep > example simple): > > primarykey number(8) > status char(1) > dateinserted date > > > A row is inserted into this table any time one, or more, fields change for > the record. What I'm trying to determine is the "dateinserted" for each > time the value of "status" changed - remembering that there might be 50 > records for the primary key and five of those include a change in status - > I want the dates of those five records (plus the value of status at each > date). > > Is there any way to achieve this within a single SQL statement? I realise > that I could cursor through each record in date order and use a variable to > store the previous value of status - but I'd love to compress this to a > single statement. I've seen the syntax "OVER" used in some queries and > suspect this may be useful but I really don't understand it enough to know. > > Thanks in advance if you can help me on this one, > > Mark. > > PS: Sorry if this appears more than once - I've been getting mail server > failures all day > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message >(or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender >by reply e-mail or by telephone on (61 3) 9612-6999. >Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tricky query question
Here's a trick for you. Let me know if it works. select prev.dateinserted "date", prev.status "orig_status", curr.dateinserted "change_date", curr.status "new_status" from (select rank() over (order by dateinserted asc) id, primarykey, status from table) curr, (select rank() over (order by dateinserted asc) id, primarykey, status from table) prev where curr.id-1 = prev.id and curr.status <> prev.status; -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more." Mark Richard wrote: > Hi All, > > This is a question for those who like writing tricky queries as a single > SQL... > > Assume I have a table with the following structure (imaginary table to keep > example simple): > > primarykey number(8) > status char(1) > dateinserted date > > > A row is inserted into this table any time one, or more, fields change for > the record. What I'm trying to determine is the "dateinserted" for each > time the value of "status" changed - remembering that there might be 50 > records for the primary key and five of those include a change in status - > I want the dates of those five records (plus the value of status at each > date). > > Is there any way to achieve this within a single SQL statement? I realise > that I could cursor through each record in date order and use a variable to > store the previous value of status - but I'd love to compress this to a > single statement. I've seen the syntax "OVER" used in some queries and > suspect this may be useful but I really don't understand it enough to know. > > Thanks in advance if you can help me on this one, > > Mark. > > PS: Sorry if this appears more than once - I've been getting mail server > failures all day > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> >Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message >(or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender >by reply e-mail or by telephone on (61 3) 9612-6999. >Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN backup - basic Qs
does this make RMAN hot backups faster or slower than when backing up file in backup mode? [EMAIL PROTECTED] wrote: > To better answer the original question, my understanding of this difference > is as under: > > Why do you put the tablespace in backup mode during normal hot backups > without RMAN? This is to avoid backing up "split blocks". Say, you have a > database with a block size of 16K. And that a block is in the process of > being backed up, with reads happening in chunks of say, 512 bytes. Assume > a user transaction updates this block while the backup is in progress. This > could result in an inconsistent version of the block being backed up, or > what is called as "split blocks". Putting a tablespace in backup mode, is > primarily, a flag which tells Oracle to copy the entire block into the redo > stream, and not just the changed vectors or deltas, which it would have > done otherwise. This is so that, in case of recovery, the entire block can > be read from the redo stream, and applied. Hence, this results in an > increase in the redo size during normal hot backups. > > RMAN however, does not place the tablespaces in hot backup mode. They use > the same read consistency mechanism used by the SQL statements. Hence, no > excessive redo is generated. > > Hope this helps. > > Raj > > Original Message- > Sent: Thursday, January 16, 2003 1:54 PM > To: Multiple recipients of list ORACLE-L > > Rman uses the same construct to get the right data in a hot backup as > sqlplus, the SCN of the database. It reduces excess redo because you don't > have to put the datafile in backup mode with a begin backup and take it out > > with and end backup. > > HTH, > Ruth > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 16, 2003 12:35 PM > > > > > Is Excessive Redo Generated during RMAN OPEN Database backup using backup > > sets as happens in case of HOT Backup ? > > > > If NOT , Why ? > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: VIVEK_SHARMA > > INET: [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega Oracle DBA Philippine Stock Exchange, Inc. "If you don't risk anything, you risk even more." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
career questions
Gurus, I have been an Oracle DBA for almost 5 years and would like very much to venture into independent Oracle consulting (part-time). As i have spent most of these 5 years as a sole DBA for different companies, studying and learning the ropes of Oracle Administration through books, magazines, test machines and this list, I feel confident enough to handle most Oracle issues. At the same time, I still have that feeling of inadequacy. I am not sure if I am good enough to offer my services to local companies. That said, I'd like to ask every one who are into consulting (on their own or as a part-time gig) what are the technical and soft skills necessary before I even think about consulting. How would you know that you're "technically" ready for it. And how do I get started. Tips are welcome too! Thanks everyone. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle book
Anybody read the book "Database Administration: The Complete Guide to Practices and Procedures" by Craig Miller? any opinions? i'm planning to buy it...i'd like to know if its worth it. Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SunFire v100
Hello everyone. Just want to ask if anybody tried to use a SunFire v100 as a database server. I was told this is a headless server, but otherwise, very similar to any other sun servers. Looks like an oracle database on this baby can work enough as a development server. Would like to get anybody's opinion. Will oracle work on this or not? Thanks. =) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Materialized view selection.
Depends mostly on your users needs. If most of the time your users would want monthly sum of measures, you give them a materialized view for that. You can also use the summary advisor feature of oracle (dbms_olap) to find out which mviews oracle thinks is needed based on usage. =) Chuan Zhang wrote: > Hi, All, > >Just wonder what's tool or methodology you are using to select materialized view >in Oracle data warehouse environment? > > Many thanks in advance, > > Chuan > > >Name: InterScan_Disclaimer.txt >InterScan_Disclaimer.txtType: Plain Text (text/plain) >Encoding: 7bit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
E business Suite 11i - for Apps DBA's
Hello Application DBA's I'd like to know where I can get/buy E-business Suite 11i documentation with the ERD and data dictionary of the tables. Thank you so much. -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Financials Client question
We have outsourced implementation and setup of a scaled down Oracle Applications 11i (rel 11.5.5) for Suse Linux... I have received a memo from the implementation team's application DBAs and they have informed me of a certain limitation for the specs of the client PC's. I was informed that the clients must either be Pentium 3s and below or all Pentium 4s. Mixed network of Pentium 3 and 4s will not work. I was told it was because of the JInitiator being invoked from the server. to quote: "Let us further clarify that, through our proven installation/setup experience, the Shooman Application works on a network environment of "mixed" Pentium 3s and earlier computers. As of this writing, we have yet to prove that Shooman works properly in a network of Pentium 3 (or older) workstations mixed with Pentium 4s. However, we have proven that the application works if ALL workstations are Pentium 4s. It therefore follows that, should you purchase the latest Pentium 4 computers, you must issue ALL your Shooman users with this model in order for the system to work properly." (Shooman refers to the Oracle Application residing on a server named Shooman) I am completely ignorant of Oracle Applications as I have 0 experience in managing it. I'd really appreciate your opinion if we are being fooled or not. I am very concerned about this because as we all know PCs become obsolete in months... time will come we will have to change PCs...maybe move on to Pentium 5/6... This can pose a problem for us. Thanks a lot! -- Maria Aurora VT de la Vega OCP Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: awk problem
thanks everyone for the help. =)
Sergey V Dolgov wrote:
> Hello Maria,
>
> You should look at your file in some hex editor, this symbols might be
> symbols with hex code 0A or 0D 0A (it means new line).
> So you have to set correct RS value.
>
> Wednesday, May 15, 2002, 3:28:38 PM, you wrote:
>
> MAVdlV>
> MAVdlV> I'm hoping that there are awk gurus also in this list.my problem:
> MAVdlV> when I use awk, it cuts off a part of the line
>
> MAVdlV> $ cat -n *0509*|awk '{if
> MAVdlV> ((substr($0,34,2) == "1I")(length($0)) == 107) {print $0}}'|sort
> MAVdlV> 1248 110
> MAVdlV> 2002050990910931381IF110 201 9091PCORAJ
> MAVdlV> S1 1
> MAVdlV> 1.7600MD
> MAVdlV> 1249 110
> MAVdlV> 2002050990920931511IF110 201 9092PCORAJ
> MAVdlV> S1 1
> MAVdlV> 1.7800MD
> MAVdlV> 1250 110
> MAVdlV> 2002050990930931591IF110 201 9093PCORAJ
> MAVdlV> S2 2
> MAVdlV> 1.8000MD
>
> MAVdlV> i am supposed to get
> MAVdlV> a longer line
> MAVdlV> getting line 1248 as
> MAVdlV> an example:
>
> MAVdlV> $ grep "110 2002050990910931381IF110
> MAVdlV> 201 9091PCOR" *0509*
> MAVdlV> 110 2002050990910931381IF110
> MAVdlV> 201 9091PCORAJ
> MAVdlV> S1 1
> MAVdlV> 1.7600MD C0905L
>
> MAVdlV> if I look at the file in windows notepad, this same line has 4box characters
> MAVdlV> between 1.7600MD and C0905L
> MAVdlV> I am not sure what those 4 box characters are.
>
> MAVdlV> help.
>
> MAVdlV> Thanks.
>
> MAVdlV> =)
> MAVdlV> --
> MAVdlV> "Never attribute to malice that which can be adequately explained by
> MAVdlV> stupidity."
>
> MAVdlV> Maria Aurora VT de la Vega OCP
> MAVdlV> Database Specialist
> MAVdlV> Philippine Stock Exchange, Inc.
> MAVdlV> --
> MAVdlV> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>
> --
> Best regards,
> Sergeymailto:[EMAIL PROTECTED]
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Sergey V Dolgov
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
"Never attribute to malice that which can be adequately explained by stupidity."
Maria Aurora VT de la Vega OCP
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: OT: awk problem
thanks for the info.
right now, i cannot do anything about the terminal that inserts those characters.
i am working with an extract file from a legacy system.
i need to extract some lines from the file and load the data into the database.
btw, we cannot change the extract program so I have to do a workaround.
thanks.
Stephane Faroult wrote:
> Nothing to do with awk, probably just your terminal which inserts carriage returns.
>Shouldn't do that if you redirect to a file or set your terminal width to 132.
>
> >- Original Message -
> >From: Maria Aurora VT de la Vega
> ><[EMAIL PROTECTED]>
> >To: Multiple recipients of list ORACLE-L
> ><[EMAIL PROTECTED]>
> >Sent: Wed, 15 May 2002 00:23:22
> >
> >I'm hoping that there are awk gurus also in this
> >list.
> >
> >my problem:
> >when I use awk, it cuts off a part of the line
> >
> >$ cat -n *0509*|awk '{if ((substr($0,34,2) == "1I")
> >&& (length($0)) ==
> >107) {print $0}}'|sort
> > 1248 110 2002050990910931381IF110 201
> >9091PCORAJ
> >S1 1 1.7600MD
> > 1249 110 2002050990920931511IF110 201
> >9092PCORAJ
> >S1 1 1.7800MD
> > 1250 110 2002050990930931591IF110 201
> >9093PCORAJ
> >S2 2 1.8000MD
> > 1251 110 2002050990940932551IF110 201
> >9094PCORAJ
> >B1 1 1.6800MD
> > 1253 110 2002050990950933021IF110 201
> >9095PCORAJ
> >B1 1 1.6600MD
> > 1254 110 2002050990960933091IF110 201
> >9096PCORAJ
> >B2 2 1.6400MD
> > 1255 110 2002050990970935361IF110 201
> >9097MERBAJ
> >S1000100000040.5000MD
> > 1256 110 2002050990980935421IF110 201
> >9098MERBAJ
> >S1000100000041.MD
> > 1257 110 2002050990990935491IF110 201
> >9099MERBAJ
> >S1000100000041.5000MD
> > 1258 110 20020509909000100936101IF110 201
> >90900010MBT AJ
> >S1000100000041.5000MD
> > 1259 110 20020509909000110938211IF110 201
> >90900011FPH AJ
> >S1000100000027.5000MD
> > 1260 110 20020509909000120938291IF110 201
> >90900012FPH AJ
> >S1000100000028.MD
> > 1261 110 20020509909000130938561IF110 201
> >90900013PCORAJ
> >S1 1 1.7400MD
> > 1262 110 20020509909000140939271IF110 201
> >90900014MERBAJ
> >S1000100000040.5000MD
> >
> >i am supposed to get a longer line
> >getting line 1248 as an example:
> >
> >$ grep "110 2002050990910931381IF110 201
> >9091PCOR" *0509*
> >110 2002050990910931381IF110 201 9091PCOR
> > AJ
> >S1 1 1.7600MD C0905L
> >
> >^^^^^^
> >
> >LOST PART
> >
> >if I look at the file in windows notepad, this same
> >line has 4box
> >characters between 00001.7600MD and C0905L
> >I am not sure what those 4 box characters are.
> >
> >help.
> >
> >Thanks.
> >
> >=)
> >--
> >Maria Aurora VT de la Vega OCP
> >Database Specialist
> >Philippine Stock Exchange, Inc.
> >
>
> Regards,
>
> Stephane Faroult
> Oriole
--
"Never attribute to malice that which can be adequately explained by stupidity."
Maria Aurora VT de la Vega OCP
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
OT: awk problem
I'm hoping that there are awk gurus also in this list.
my problem:
when I use awk, it cuts off a part of the line
$ cat -n *0509*|awk '{if
((substr($0,34,2) == "1I") && (length($0)) == 107) {print $0}}'|sort
1248 110
2002050990910931381IF110 201 9091PCOR AJ
S1 1
1.7600MD
1249 110
2002050990920931511IF110 201 9092PCOR AJ
S1 1
1.7800MD
1250 110
2002050990930931591IF110 201 9093PCOR AJ
S2 2
1.8000MD
i am supposed to get
a longer line
getting line 1248 as
an example:
$ grep "110 2002050990910931381IF110
201 9091PCOR" *0509*
110 2002050990910931381IF110
201 9091PCOR AJ
S1 1
1.7600MD C0905L
if I look at the file in windows notepad, this same line has 4box characters
between 1.7600MD and C0905L
I am not sure what those 4 box characters are.
help.
Thanks.
=)
--
"Never attribute to malice that which can be adequately explained by
stupidity."
Maria Aurora VT de la Vega OCP
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
OT: awk problem
I'm hoping that there are
awk gurus also in this list.
my problem:
when I use awk, it cuts
off a part of the line
$ cat -n *0509*|awk '{if
((substr($0,34,2) == "1I") && (length($0)) == 107) {print $0}}'|sort
1248 110
2002050990910931381IF110 201 9091PCOR AJ
S1 1
1.7600MD
1249 110
2002050990920931511IF110 201 9092PCOR AJ
S1 1
1.7800MD
1250 110
2002050990930931591IF110 201 9093PCOR AJ
S2 2
1.8000MD
1251 110
2002050990940932551IF110 201 9094PCOR AJ
B1 1
1.6800MD
1253 110
2002050990950933021IF110 201 9095PCOR AJ
B1 1
1.6600MD
1254 110
2002050990960933091IF110 201 9096PCOR AJ
B2 2
1.6400MD
1255 110
2002050990970935361IF110 201 9097MERB AJ
S1000 1000
00040.5000MD
1256 110
2002050990980935421IF110 201 9098MERB AJ
S1000 1000
00041.MD
1257 110
2002050990990935491IF110 201 9099MERB AJ
S1000 1000
00041.5000MD
1258 110
20020509909000100936101IF110 201 90900010MBT AJ
S1000 1000
00041.5000MD
1259 110
20020509909000110938211IF110 201 90900011FPH AJ
S1000 1000
00027.5000MD
1260 110
20020509909000120938291IF110 201 90900012FPH AJ
S1000 1000
00028.MD
1261 110
20020509909000130938561IF110 201 90900013PCOR AJ
S1 1
1.7400MD
1262 110
20020509909000140939271IF110 201 90900014MERB AJ
S1000 1000
00040.5000MD
i am supposed to get
a longer line
getting line 1248 as
an example:
$ grep "110 2002050990910931381IF110
201 9091PCOR" *0509*
110 2002050990910931381IF110
201 9091PCOR AJ
S1 1
1.7600MD C0905L
&nb!
!
sp;
^^
LOST PART
if I look at the file in windows notepad, this same line has 4box characters
between 1.7600MD
and C0905L
I am not sure what those
4 box characters are.
help.
Thanks.
=)
--
Maria Aurora VT de la Vega OCP
Database Specialist
Philippine Stock Exchange, Inc.
interview questions
Hello Gurus. I would like to ask anyone who were at one point worked as Oracle Developers... or anyone who can give their opinion... I will be interviewing applicants for Oracle Developer position. Since I'm the only Oracle person in this shop, I was tasked to handle this interview. I have 0 experience with the use of any Oracle Development tools... And for me, as long as they know how to SQL and PLSQL...and respects their DBA... they're OK. I am not sure if there are other things I should ask.. Inputs Please! thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OAS help
we have a problem with our OAS... in the admin page (OAS node manager ?!) there is a tree where there is list of HTTP listeners... now there is no entry under the HTTP list... 0 experience in using OAS... help! thanks. =) -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
oracle on linux vs oracle on NT
pros and cons of each please... stability, performance, management, etc... for small scale oracle financials implementation (125 users max) and what would be the best and most reliable linux distribution to use. on Compaq proliant hardware no experience on oracle on linux but with experience with NT (very disappointing) Any input will be very much appreciated. =) -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
using hints on views
i find the ordered hint extremely helpful... so i usually find myself using this hint... what is your opinion on using hints inside views? thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AHA!!! Re: ORA-00904 on a valid view when using count(*)
hahaha! i found it! i found the answer to my problem the part that causes the error was the order by clause using an alias... i tried to change the sql for the view using the whole exp (((sq.last_trade_price - sq.previous)/sq.previous) * 100) in the order by clause instead of the "perc_change" alias... and it worked! almost a week of thinking about this problem... i was itching to touch my database...while everyone else were sooo into the new year celebrations... now I can celebrate! =) this looks like a bug...if anyone of you is working for oracle...kindly take note of this... Maria Aurora VT de la Vega wrote: yup. tried to validate...no luck, tried to rebuild...no luck, tried creating a new base table (CTAS)...and create new views (same sql as orig views)...still no luck...problem can be recreated... here's the objects involved SQL> desc stock_quote Name Null? Type - SECURITY_ID VARCHAR2(10) BID NUMBER(12,4) ASK NUMBER(12,4) PREVIOUS NUMBER(12,4) OPEN NUMBER(12,4) HIGH NUMBER(12,4) LOW NUMBER(12,4) CLOSE NUMBER(12,4) LAST_TRADE_PRICE NUMBER(12,4) TOTAL_VOLUME NUMBER(18,4) TOTAL_VALUE NUMBER(18,4) PROJECTED_OPEN NUMBER(16,4) SPECIAL_VOLUME NUMBER(18,4) SPECIAL_VALUE NUMBER(18,4) TOTAL_FOREIGN_BUYING NUMBER(16,4) TOTAL_FOREIGN_SELLING NUMBER(16,4) TOTAL_OUTSTANDING NUMBER(16,4) CURR_FOREIGN_SHARES_AVAIL NUMBER(16,4) SECURITY_SYMBOL VARCHAR2(12) SQL> desc company Name Null? Type - - COMPANY_ID NOT NULL VARCHAR2(10) NAME VARCHAR2(60) TELEPHONE VARCHAR2(200) FAX VARCHAR2(40) URL VARCHAR2(50) EMAIL VARCHAR2(30) PROFILE_FNAME VARCHAR2(100) SUBSECTOR_ID VARCHAR2(8) LOGO VARCHAR2(100) INCORP_DATE DATE LISTING_DATE DATE ADDRESS VARCHAR2(250) SQL> desc security Name Null? Type - SECURITY_ID NOT NULL VARCHAR2(10) SECURITY_SYMBOL VARCHAR2(12) ISIN VARCHAR2(12) SUBSECTOR_ID VARCHAR2(8) ALIAS VARCHAR2(15) COMPANY_ID VARCHAR2(10) SECURITY_TYPE CHAR(1) CEILING NUMBER(12,4) FLOOR NUMBER(12,4) PRIOR_CLOSE NUMBER(12,4) LAST_TRADED_DATE DATE PAR_VALUE NUMBER(12,4) BOARD_LOT NUMBER(16,4) BIG_LOT NUMBER(16,4) DESIGNATED CHAR(1) SUSPENSION CHAR(1) DELIST CHAR(1) HALT CHAR(1) SPLIT CHAR(1) BENEFIT CHAR(1) EX_DIVIDEND CHAR(1) EX_RIGHTS CHAR(1) FOREIGN_ID_REQUIRED CHAR(1) TOTAL_OUTSTANDING_SHARES NUMBER(16,4) FOREIGN_OWNABLE_SHARES NUMBER(16,4) CURRENT_FOREIGN_SHARES NUM
Re: ORA-00904 on a valid view when using count(*)
NUMBER(16,4) COUPON_RATE NUMBER(10,4) NEXT_COUPON_DATE DATE LAST_UPDATED DATE STATUS CHAR(1) SECURITY_NAME VARCHAR2(25) YTD_VOLUME NUMBER(17,4) YTD_VALUE NUMBER(17,4) HIGH_52_WEEK NUMBER(12,4) LOW_52_WEEK NUMBER(12,4) SECURITY_RSI NUMBER(16,4) SECURITY_PER NUMBER(16,4) SECURITY_EPS NUMBER(16,4) create or replace view trade_quotes_vw as SELECT "SECURITY_ID","BID","ASK","PREVIOUS","OPEN","HIGH","LOW","CLOSE", "LAST_TRADE_PRICE","TOTAL_VOLUME","TOTAL_VALUE","PROJECTED_OPEN","SPECIAL_VOLUME", "SPECIAL_VALUE","TOTAL_FOREIGN_BUYING","TOTAL_FOREIGN_SELLING","TOTAL_OUTSTANDING", "CURR_FOREIGN_SHARES_AVAIL","SECURITY_SYMBOL" FROM stock_quote WHERE last_trade_price > 0; create view gain_vw as SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, sq.open, sq.high, sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume, sq.total_value, (((sq.last_trade_price - sq.previous)/sq.previous) * 100) AS perc_change, (sq.last_trade_price - sq.previous) AS value_gain FROM trade_quotes_vw sq, security sec, company co WHERE sq.security_symbol = sec.security_symbol AND sec.company_id = co.company_id AND NVL(sq.previous,0) > 0 AND (NVL(sq.last_trade_price,0) - NVL(sq.previous,0)) > 0 ORDER BY perc_change DESC; looks like everythings ok here...but it still won't work! Stephane Faroult wrote: Maria, The only cases I have seen so far of one query working and the other one failing miserably were linked to a change in the execution plan (for one query Oracle uses a safe path, and stumbles along the way when it uses a different one). The only stumble-block I can think of is indexes, which are unlikely to be used in a SELECT * (without any condition) but might be scanned in the other cases. I don't think that a query which fails will show any execution plan with SET AUTOTRACE ON, unfortunately. If I were you I would try to check the indexes on all the tables involved, perhaps VALIDATE them or rebuild them, or even (if tables are not too big) drop and recreate them. I have also noticed that when a function-based index is used, a weird column name appears in DBA_IND_COLUMNS, which could explain ORA-0904 if improperly managed during parsing. Do you have any? If this is the case, drop it and try again, to see if it is the culprit. This is about all I can think of. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc.
Re: ORA-00904 on a valid view when using count(*)
so sorry, that was i typoi was reading gain_vw as gain_view... Kimberly Smith wrote: > Hum, its early and really I am more interested in my friend > getting here and going snowboarding but why are you expecting > gain_vw to work? Or is that a typo? > > -Original Message- > Aurora VT de la Vega > Sent: Friday, December 28, 2001 11:05 PM > To: Multiple recipients of list ORACLE-L > > we have view named gain_view > which was created with this sql > SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, > sq.open, sq.high, >sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume, > sq.total_value, >(((sq.last_trade_price - sq.previous)/sq.previous) * 100) AS > perc_change, >(sq.last_trade_price - sq.previous) AS value_gain > FROM trade_quotes_vw sq, security sec, company co > WHERE sq.security_symbol = sec.security_symbol >AND sec.company_id = co.company_id >AND NVL(sq.previous,0) > 0 >AND (NVL(sq.last_trade_price,0) - NVL(sq.previous,0)) > 0 > ORDER BY perc_change DESC > > when we do a select * from gain_view we get the correct results > but when we use select count(*) from gain_vw we are getting ORA-00904 > > any ideas? > > -- > Maria Aurora VT de la Vega (OCP) > Database Specialist > Philippine Stock Exchange, Inc. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00904 on a valid view when using count(*)
follow-up on this one... it seems that everything else won't work like select max(open) from gain_view or select name from gain_view or select max(length(security_name)) from gain_view... except for select * from gain_view... tried these for almost all columns and am still getting 904 error... btw, trade_quotes_vw is valid Maria Aurora VT de la Vega wrote: > we have view named gain_view > which was created with this sql > SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, > sq.open, sq.high, >sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume, > sq.total_value, >(((sq.last_trade_price - sq.previous)/sq.previous) * 100) AS > perc_change, >(sq.last_trade_price - sq.previous) AS value_gain > FROM trade_quotes_vw sq, security sec, company co > WHERE sq.security_symbol = sec.security_symbol >AND sec.company_id = co.company_id >AND NVL(sq.previous,0) > 0 >AND (NVL(sq.last_trade_price,0) - NVL(sq.previous,0)) > 0 > ORDER BY perc_change DESC > > when we do a select * from gain_view we get the correct results > but when we use select count(*) from gain_vw we are getting ORA-00904 > > any ideas? > > -- > Maria Aurora VT de la Vega (OCP) > Database Specialist > Philippine Stock Exchange, Inc. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00904 on a valid view when using count(*)
follow-up on this one... it seems that everything else won't work like select max(open) from gain_view or select name from gain_view or select max(length(security_name)) from gain_view... except for select * from gain_view... tried these for almost all columns and am still getting 904 error... btw, trade_quotes_vw is valid Maria Aurora VT de la Vega wrote: > we have view named gain_view > which was created with this sql > SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, > sq.open, sq.high, >sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume, > sq.total_value, >(((sq.last_trade_price - sq.previous)/sq.previous) * 100) AS > perc_change, >(sq.last_trade_price - sq.previous) AS value_gain > FROM trade_quotes_vw sq, security sec, company co > WHERE sq.security_symbol = sec.security_symbol >AND sec.company_id = co.company_id >AND NVL(sq.previous,0) > 0 >AND (NVL(sq.last_trade_price,0) - NVL(sq.previous,0)) > 0 > ORDER BY perc_change DESC > > when we do a select * from gain_view we get the correct results > but when we use select count(*) from gain_vw we are getting ORA-00904 > > any ideas? > > -- > Maria Aurora VT de la Vega (OCP) > Database Specialist > Philippine Stock Exchange, Inc. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Maria Aurora VT de la Vega > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-00904 on a valid view when using count(*)
we have view named gain_view which was created with this sql SELECT co.name, sec.alias, sec.security_name, sec.security_symbol, sq.open, sq.high, sq.low, sq.close, sq.previous, sq.last_trade_price, sq.total_volume, sq.total_value, (((sq.last_trade_price - sq.previous)/sq.previous) * 100) AS perc_change, (sq.last_trade_price - sq.previous) AS value_gain FROM trade_quotes_vw sq, security sec, company co WHERE sq.security_symbol = sec.security_symbol AND sec.company_id = co.company_id AND NVL(sq.previous,0) > 0 AND (NVL(sq.last_trade_price,0) - NVL(sq.previous,0)) > 0 ORDER BY perc_change DESC when we do a select * from gain_view we get the correct results but when we use select count(*) from gain_vw we are getting ORA-00904 any ideas? -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Generating a SQLLDR Sequence Number
tated, opinions expressed in this e-mail are those of the >author and are not endorsed by the author's employer. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumar, Dharminder > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > -------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: Oracle DBA/Developer Position]
--- Begin Message --- I am looking for an Oracle DBA/Developer for a position here in Dallas. It is a very difficult req to fill. I have attached a copy of this positions requirements. This is a very specific Designer/2000 & PL/SQL Programmer position, utilizing Oracle 6i "Web Generation" (60% of time) and Development-DBA position (40% of time). This position is not a DBA-Only position (the candidate must have development experience), and the majority of time will be spent in the developer role, utilizing the areas listed below. T he DBA aspects of this position are very developmental in nature, as well. This is NOT a traditional DB setup & monitor position, but is heavily involved in development DBA areas, such as data analysis & troubleshooting, SQL-Tuning, data mining & manipulation for 25-million row DB's. Must have 3+ Years in Oracle "Web Generation" or "Forms" and 3+ Years in a development-DBA role If you do have this specific experience, and is the type of job you're looking for, please respond to my questions below, specifically describing your pertinent experience to these position requirements: 1. Designing & Developing HTML-based applications specifically using Designer2000 Version 6.0.3.4 & 6i "Web server Generation" Modules: [Describe your specific experience here, with examples, and total years for each bullet] 2. DBA experience Overall: 3. DBA with specialties in tasks of: - Data Mining & Manipulation: - Data Warehousing: - Data Analysis: - Replication: - SQL-Tuning & DB-Process Tuning: - DB Troubleshooting: - Other DBA/Data Related Tasks of large-scale databases (20-30 million rows): - PL/SQL Coding Experience (no less than a 9-out-of-10): - Designer/2000 baseline & customization Experience: - JavaScript & HTML Experience: - Developer2000 Reports experience - Communication skills: - Other Related Experience: - JSP & Servelets Experience (Nice to have, not Mandatory): Erik N. Carlson Carlson Corporate Research, Inc. 214.828.4039 [EMAIL PROTECTED] --- End Message ---
Re: SQL Query OutPut
SQL> break on DeptNo Robertson Lee - lerobe wrote: > Look up group by clause in the SQL Reference Manual. > > Regards > > Lee > > -Original Message- > Sent: 15 November 2001 10:05 > To: Multiple recipients of list ORACLE-L > > Hi, > > I need the Query for the following result. > If any body help it will be very great. Its very urgent. > > the output needed is > > DeptNoEmpNo > > 101 > 2 > 3 > 4 > 5 > 2011 > 12 > 13 > > The DeptNo should not repeat for all the employees. > Thanks in advance > > Regards > > Pruthvi > > _ > Do You Yahoo!? > Get your free @yahoo.com address at http://mail.yahoo.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Pruthvi > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > The information contained in this communication is > confidential, is intended only for the use of the recipient > named above, and may be legally privileged. If the reader > of this message is not the intended recipient, you are > hereby notified that any dissemination, distribution or > copying of this communication is strictly prohibited. > If you have received this communication in error, please > re-send this communication to the sender and delete the > original message or any copy of it from your computer > system. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Robertson Lee - lerobe > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
quick q re: column default
how do i remove a column's default value? thanks. -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
slightly OT: visual c++ and null values
hello!
our developers here are requesting that I put defaults (' ' for
chars/varchars, 0 for numbers, etc) in place instead of nulls in all
columns that would supposedly allow null values...
they are using visual c++ and they say that they cannot make visual c++
retreive null values...
i am very hesitant in implementing this...
i have no knowledge whatsoever of visual c++ and don't know if this is
true...
i'd like to know if anyone had encountered this same problem before?
or maybe someone can tell me if there is any truth to what our
developers are saying...
oracle817 on solaris7
thanks =)
--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Write to file in XML format
use XDK... particularly "XML SQL Utility for PL/SQL" - generates an XML Document from SQL queries wth the following features: 1. Outputs text or Document Object Model from a SQL query string or a JDBC ResultSet object 2. Writes data from an XML document into a database table or view i think there are sample codes in technet... "Cale, Rick T (Richard)" wrote: > Hi All, > > I wanting to read data from table(s) and then create an output file in XML > format. > I have never done it so does anyone have good examples or point me to some > good resources. > > Thanks > Rick > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Cale, Rick T (Richard) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rash of shared memory errors
are you using oracle 8.1.7?
if you are, this is caused by a bug on this version.
you will only need to add another parameter in your init.ora...
search metalink for the details of how to fix this...
hth
=)
Arn Klammer wrote:
> Hi,
>
> Just recently, we have been frequently receiving errors like the following in our
>development database:
>
> ERROR:
> ORA-04031: unable to allocate 4096 bytes of shared memory ("shared pool","BEGIN
> DBMS_OUTPUT.DISABLE; E...","PL/SQL MPCODE","BAMIMA: Bam Buffer")
>
> The size of our shared pool is not too small (I think); it's larger than our test
>and maintenance databases, for example.
>
> shared_pool_reserved_sizestring 80
> shared_pool_size string 1600
>
> What could be causing this level of frequent fragmentation? We have been developing
>a new application in the database, but this has been ongoing for some months; the
>errors appeared only in the last week or so.
>
> What should I be looking for to solve this?
>
> Thanx for any advice.
>
> -arn
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
>
> This footnote also confirms that this email message has been swept by
> MIMEsweeper for the presence of computer viruses.
>
> www.mimesweeper.com
> **
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Arn Klammer
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Maria Aurora VT de la Vega (OCP)
Database Specialist
Philippine Stock Exchange, Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Maria Aurora VT de la Vega
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Intermedia question
yes, its possible. although, from my experience indexing a bfile takes a lot longer than indexing a blob... and why not try using IFS for this? [EMAIL PROTECTED] wrote: > Good day, > > I have an application that has many documents (Word, Excel, pdf, email etc) stored >on a Solaris file system. I want to be able to search the contents of those document. >Is it possible to create some tables in the database that has BFILE > columns that reference those documents outside the database and use InterMedia to do >searching? > > I am not familiar with LOBs and Intermedia, that's why I ask this basic question. > > Thanks > Long > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Maria Aurora VT de la Vega (OCP) Database Specialist Philippine Stock Exchange, Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Maria Aurora VT de la Vega INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
