| |
| |
| |
|
Page: 1 2 3 4 5 6 7
Comments:
<0> Hi
<0> can you help me?
<0> I have a problem with Oracle 10g. I'm defining a PL/SQL function for retrieving rows from a table, matching some conditions. Fact is, there can be more than one row such as that... how can I have the function return all of these rows at one time?
<1> Tys you want a function to return rows?
<1> like an array?
<0> yes, precisely
<1> so make your function return an array
<0> but... fact is, i don't know how many rows the function will return!
<0> *the select will return
<1> look into type
<1> google 'oracle array type'
<2> CoJoNEs are you ignoring msges?
<1> no im just not paying much attention
<1> I just got on
<2> oh ok
<3> hey cojo
<1> hey
<4> hey
<3> indeed
<3> CoJoNEs : want to hear a story of someone making a CLM - career-limiting move?
<1> sure why not
<3> a week ago on wednesday, we had our bonuses and pay rises
<3> they were pretty much poor across the board, but one of the reasons given to us was that our team lacked 'visibility' to senior manaement
<1> bah what a joke
<3> so, last week i ordered 12 hi-vis jackets with our team name printed on the back - they arrive tomorrow
<1> hahah
<1> nice
<3> just in time for the new CIOs visit - we got an email last thursday saying that he's really keen to meet us... so keen in fact that he's only been with the company two months already, and has scheduled the meeting in a weeks time
<3> really 'keen'
<1> keen
<1> haha
<3> so, i don't expect i'll be rising up the corporate ladder any time son
<3> soon
<1> funny though
<3> well... seemed appropriate
<1> yeah I think so
<1> screw that crap, that no visibility is a crap line
<3> oh yeah...
<5> how do u get the current datetime in mssql?
<2> getdate()
<5> thnx
<6> an integer type is signed, is there a way to get a 32 bit unsigned type?
<2> unsigned type of what
<2> micros did you read the rules
<2> or should i just insult you now?
<6> sorry, mssql server
<2> thanks
<6> i would like to have an unsigned integer, 32 bit data type in my table
<6> i tried a bigint instead, but the vb app, using a long type doesnt like it
<7> Darken, glad to see I am rubbing off on you
<2> no you're not
<2> because I hinted to him
<2> he was not insulted
<2> micros as far as I know ms sql 2000 uses signed integers
<2> if you need a larger number try a bigint
<2> which should be more than plenty
<2> if all you're requesting is 32bit unsigned
<6> darken, yes i chose a bitint, but vb is complaining when i try to pull the bigint into a long datatype (the bigint is never ever bigger than 32 bit)
<6> woa. seems i was mistaken
<6> int's are 16 bit in vb, long is 32 bit.
<6> there is no 64 bit data type.
<6> therefore, can i not retrieve a bigint from the db?
<6> perhaps variant type
<8> try unsigned long in vb6
<8> int is 32bit
<8> int in vb6 is 16bit
<2> http://208.53.158.98/~nff/c-pictures/malevsfemaleshopping.jpg
<9> hahaha
<10> hi, anyone uses DTS/SSIS for their web app? why would anyone use it?
<2> uhm
<2> ssis is the successor to dts
<2> just to make that clear
<2> and they'd use it because they want to
<10> usually because an enterprise IT system is messy, having so many data formats, db servers etc.. etc... ?
<2> usually because they just want to use a visual package
<2> throwing around buzzwords like it means something is useless also
<2> "enterprise IT system" doesn't mean anything
<2> nor does having so many data formats mean anything
<2> there are many different data formats on any one given computer due to the complexity and the number of diverse developers who have made all the various applications
<11> If I have multiple tables, and each one has a primary key of int (without auto_increment) named "list_num" - is there a way to find the max of those "list_num"s without the use of another temporary table?...
<11> i've been brainstorming with multiple select statements, joins, and the max function, but i can't seem to think up any solution....
<2> max(list_num)
<2> do you want the maximum value across your tables?
<10> select * from myTAble where list_num = (select max(list_num) from myTable)
<2> or for each table
<2> why not run a loop and use a variable instead of a temporary table?
<12> right now i am using tsearch2/gist, but i want to do substring searches, does anyone have any suggestions?
<11> sounds like a good idea - i think i'll also take from what chen`chen mentioned... bbiab - thx guys :-)
<10> oh multiple tables
<10> ignore me
<11> chen`chen: yeah - i just looked at your code right now and ...yarrr.. not gonna' work... heh
<11> like, multiple tables with random int vals in a column... i'm trying to go through all those tables and find the highest column value regardless of the table its in
<10> do u get the table names thru sql ?
<13> Select TABLE_NAME, COLUMN_NAME from Information_Schema.Columns Where TABLE_NAME in (Select TABLE_NAME from Information_Schema.Tables where Table_Type = 'BASE TABLE')
<11> no, i'm actually writing a cgi script in perl - but nevertheless, i'd rather be able to find the max of list_num in x amount of tables through sql, rather than return the max of one tables primary key, and the next, etc... and then to finally find the greatest one
<10> if u have the table list, u can do like , select max(ID) from (select max(id) as [ID] from table1 union all select max(id) from table2)
<11> chen`chen: yeah, that was the original idea - but i was just seeing if anyone else knew of a way to do it without as many separate sql statements from my script - but i'll probably just use that (the original idea) to save myself the effort
<11> but it is an interesting problem... though once again... not sure if possible simply through sql
<11> i'd think it would be... i must just need to RTFM a bit more ;-)
<10> get some pot
<11> lol
<11> i'm sorry, is that an acronym? or literal?.. cuz if it's an acronym, i should probably find out now before i laugh at people telling me something coherent
<10> :(
<11> i wasn't puting you down or anything, i was just asking... if you meant i should smoke some pot, or if pot meant something else
<11> haha
<10> :~(
<11> chen`chen: why are you so sad? is it something i said? cuz if so, i'm sorry
<11> :-\
<10> no, just honry
<10> horny
<11> chen`chen: ah, i see... heh, bummer :-\.
<10> hmmmm "The multi-part identifier "dbo.fnUserInfo" could not be bound." what a weird error
<10> im just testing a UDF to return xml type, and voila
<14> Any good reads on designing a database for "tagging" based searches?
<11> in effort to solve a larger problem, here's a smaller problem: is it possible to somehow link several columns from separate tables into one, large column? o_O
<2> don't do that
<2> we're smarter than you
<2> and yes it is
<11> haha, ok, sorry - but it is? ...possible?
<2> please read
<11> can you at least refer me to a section of the manual or... a func?
<2> have you read the channel rules? "no"
<11> yes
<15> normal joins with string concatenations or whatever
<2> keirzev apparently you haven't read them because I'm not seeing an answer
<10> union all .....
<11> wait, i thought you were refering to the rule of "if we tell you to rtfm, then stfu and rtfm" or something like that - so i just said "yes"
<2> i'm referring to every single rule
<11> arghhh... i think i'm just really tired
<2> state your rdbms
<11> mysql
<2> read the other rule
<11> lol
<11> but you just told me to state my rdbms
<2> yes I did
<2> AND read the topic
<2> can I help you with anything else?
<10> darken is helpful :)
<2> heh
<11> i don't see why you had me re-read the rules... i learned nothing as to how i aggravated you... :-\
<11> thx though, i suppose...
<16> you should probably go back to school then
<16> and learn about reading comprehension
<2> Arrakis is he really that thick ?
<2> or is this a joke, am I on a hidden camera?
<16> which is where you don't just read something but you learn how to extract meaning and apply it to contextual or relative situations
<11> I'm very confused...
<2> we're going to have a new script in here, where first time users must read the rules and answer a question correctly before they are allowed to speak and ask a question in here
<11> I think there's just been a misunderstanding somewhere along the lines of what i said
<2> this should stop the high level of stupidity, we hope
Return to
#sql
or
Go to some related
logs:
#computers
#dsl
#slackware
#cph
#freebsd
#opengl
#gentoo
tesla motros
#politics
#linuxhelp
|
|
