toad : Messages : 16723-16752 of 49354

Messages: Simplify \| Expand (Group by Topic)		Author	Sort by Date

16723	I want to format a number so that the decimal point is the comma. I'm using to_char(1234.056789, '99,990.9999') but it's displayed 1,234.0568. I want to be...	Jaime A Stuardo Baham... jaime_stuardo	Apr 1, 2003 1:11 pm
16724	Hi Jaime, Two methods : alter session set NLS_NUMERIC_CHARACTERS = ',.'; SELECT TO_CHAR(1234.056789, '99G990D9999') FROM dual; You need to specify the 'G' and...	Norman Dunbar normandunbar	Apr 1, 2003 1:23 pm
16725	Thanks a lot Norman !!...	Jaime A Stuardo Baham... jaime_stuardo	Apr 1, 2003 1:35 pm
16726	Or maybe this... SELECT TRANSLATE(TO_CHAR(1234.056789, '99,990.9999'),'.,',',.') FROM dual; ... From: Norman Dunbar [mailto:norman.dunbar@...] Sent:...	Borders Michael (dbm1... dbm1mxb@...	Apr 1, 2003 1:35 pm
16727	Hi again.. I have tried to do this: SELECT SUM(field1) INTO x, SUM(field2) INTO y FROM table WHERE condition but didn't work.. I had to split that statement...	Jaime A Stuardo Baham... jaime_stuardo	Apr 1, 2003 2:49 pm
16728	Hi, try select sum(field1), sum(field2) into x,y from table where Stefan ... condition...	stefaneppmann	Apr 1, 2003 2:52 pm
16729	Try Select sum(field1), sum(field2) into x,y FROM <table> WHERE etc Steve ... From: "Jaime A Stuardo Bahamondes" <jstuardo@...> To:...	Steve Jelfs stevejelfs	Apr 1, 2003 2:55 pm
16730	Try : SELECT SUM(field1), sum(field2) INTO x, y FROM table WHERE condition Cheers, Norman. ... Norman Dunbar Database/Unix administrator Lynx Financial Systems...	Norman Dunbar normandunbar	Apr 1, 2003 2:58 pm
16731	Hi... I have this select: select * from dist_fondo_poliza dfp, valor_cuota vc where dfp.fechaarchivo in (to_date(:ultimafecha, 'DD-MM-YYYY'),...	Jaime A Stuardo Baham... jaime_stuardo	Apr 1, 2003 7:58 pm
16732	Move the (+) to the other side like below. You want the outer join on the valor_cuota table not the dist_fondo_poliza table select * from dist_fondo_poliza...	Klinger, Edwin eklinger	Apr 1, 2003 8:03 pm
16733	HOW About: select * from dist_fondo_poliza dfp, valor_cuota vc where dfp.fechaarchivo between (to_date(:ultimafecha, 'DD-MM-YYYY') and to_date(:diahabil,...	dbusby@...	Apr 1, 2003 8:09 pm
16734	No.. the condition must be IN. The problem was the place of the (+), but thanks anyway :-)...	Jaime A Stuardo Baham... jaime_stuardo	Apr 1, 2003 8:35 pm
16735	John, thanks for the reply - maybe my original post wasn't terribly clear. The DDL that is run in step 3) is Toad generated. - version 7.4.0.3. I understand...	rw4412	Apr 1, 2003 9:41 pm
16736	Mike, Thanks for the offer for the scripts - I may just contact you about those. -Ralph...	rw4412	Apr 1, 2003 9:48 pm
16737	... It's a bug...and a tricky one to find (and even to recognize that it's a problem!) given Oracle's data dictionary. BUT...it is fixed in the current beta...	John Dorlon jdorlon3	Apr 1, 2003 9:55 pm
16738	Hi, try this: http://www.oracle.com/education ... Gunter ... Von: Jaime A Stuardo Bahamondes [mailto:jstuardo@...] Gesendet am: Dienstag, 1. April 2003...	Geserer, Gunter (OS I... Gunter.Geserer@...	Apr 2, 2003 9:30 am
16739	We have recently moved to oracle 9i and are now unable to compile certain packages in the proc editor. They will however compile under scheme browser. We are...	Dennis Tepe dtepe@...	Apr 2, 2003 1:29 pm
16740	Thanks all who answered.. I always had the confusion of where to place the (+) but it's clear now. Jaime...	Jaime A Stuardo Baham... jaime_stuardo	Apr 2, 2003 1:56 pm
16741	Dennis, i have a couple of guesses what you're problem might be, but any additional info you could provide would be helpful, i.e. a snippet of your code that ...	Jeff Smith wvcsee1999	Apr 2, 2003 1:57 pm
16742	We are not getting any error messages. The packages simply invalidate. We setup toad w/ longsrc. We can try to get a small piece of code using the scott tiger...	Dennis Tepe dtepe@...	Apr 2, 2003 2:33 pm
16743	Hi guys, Please a hint, is there a function to test if numeric... Thks a lot. Pierre...	mest6378	Apr 2, 2003 3:41 pm
16744	Is there a keystroke combination that equals the 'Cancel' button in the SQL editor? I started a query, left the TOAD screen to check mail, and the query is...	Tom Van Natta tom.vannatta@...	Apr 2, 2003 3:48 pm
16745	Afternoon Pierre, You need to use to_number() and trap any exceptions. This will happily trap stuff like converting '123.45.6' or '123..45' or '123x4.5' but...	Norman Dunbar normandunbar	Apr 2, 2003 3:51 pm
16746	One way is to move the data to a numeric field and check for errors. No errors = numeric data. Has the advantage of making Oracle do the work, not you....	Tom Van Natta tom.vannatta@...	Apr 2, 2003 3:51 pm
16747	Pierre: I don't believe there is one. We have created a generic function. It is simply a call to number and an exception on error code -6502 when the input...	REED-D-A@...	Apr 2, 2003 3:54 pm
16748	Not much in here... won't be a big problem for most of dev, but since it has been many years without using it, can't find the way to do it... Table A Item ...	The Decker the_decker_10	Apr 2, 2003 3:54 pm
16749	there is not a built-in one that I know of, but it should be easy to make one with a lookup in dba_tab_columns, given the table owner, table name and column...	John Dorlon jdorlon3	Apr 2, 2003 3:57 pm
16750	(sorry, I misread...thought you were after the column data type) ... From: John Dorlon [mailto:john.dorlon@...] Sent: Wednesday, April 02, 2003 9:57 AM ...	John Dorlon jdorlon3	Apr 2, 2003 3:58 pm
16751	Yup, outer join problem. Try: select a.info1, a.info2, b.check from table_a a, table_b b where a.item = b.item(+); Should do the trick. Check values are NULL...	Peter Jones Peter.Jones@...	Apr 2, 2003 4:06 pm
16752	And don't forget that CHECK will give problems as it is a reserved word :o) Cheers, Norman. ... Norman Dunbar Database/Unix administrator Lynx Financial...	Norman Dunbar normandunbar	Apr 2, 2003 4:07 pm

Yahoo! Groups Tips

Did you know...

Messages

Yahoo! My Yahoo! Mail
	Sign In New User? Sign Up
		Tech - Groups - Help

Yahoo! Groups Tips

Did you know...

Best of Y! Groups

Messages