| |
| |
| |
|
Page: 1 2 3 4
Comments:
<0> stupid question: there's a select top 10 * from table syntax in SQL server and I need the oracle 10g equivalent
<0> tried googling it but can't see the tree in the forest
<0> I just need to limit the records that the query comes back with
<1> HAVING ROWID < 10
<1> something like that
<0> oh
<0> huh, OK I'll give that a shot thanks
<0> SQL> select * from BV_DSCRP HAVING ROWID < 10 ;
<0> select * from BV_DSCRP HAVING ROWID < 10
<0> *
<0> ERROR at line 1:
<0> ORA-00932: inconsistent datatypes: expected ROWID got NUMBER
<0> SQL> select * from BV_DSCRP where rowid <10;
<0> select * from BV_DSCRP where rowid <10
<0> *
<0> ERROR at line 1:
<0> ORA-00932: inconsistent datatypes: expected ROWID got NUMBER
<0> SQL>
<0> didn't work
<2> anyone can recommand a report-php-maker with sqlsupport?
<0> didn't work
<3> flood more
<0> well I can see this is tons of fun
<0> yeah 16 lines in an Idle channel is flooding
<0> greeeaaaat
<0> you kids are really ****ing on top of things
<3> watch the language?
<4> heh guest2 remember you are the one asking for help
<5> lol
<0> and I can also see this channel's SQL chops are the finest in the land
<0> heh
<0> tenfou, how about go go off and buy a buttplug
<4> guest2 sorry nobody in here knows any sql
<3> don't ask for any more help here with a rude attitude
<4> looks like you'll have to just leave!
<4> we'll all miss you
<0> thats what IRC is all about rude attitude..apparently
<0> so kindly **** OFF
<5> no, just people who think everyone owe's them something
<3> bye guest2
<0> thats right put up a channel for questions and don't answer them and belittle them...well thats EFnet for ya
<6> #sql is for questions?
<4> i'm sorry, who's belittling who?
<5> where does it say or state that?
<0> yes, and cutting edge convo, it's obvious to me
<3> please everyone stop feeding the troll
<3> do not talk to it
<6> we are cutting edge. new typos invented here every day :)
<0> jesus, are you guys called larry moe and curly?
<7> guest2:: i think ignorance is bliss. stick with it
<0> yeah, we want NO SCROLL...not even a TROLL..we are so gawddam l33t we sit staring at idle channels
<1> guest2: simmer down
<0> d2d, good one..especialy from work
<0> ...don't give up your day job, you'll never become a comic buddy
<0> rmah, how about you go buy vibrator so your ex-gf can have some fun
<6> hmm so now the question is. do i tell guest his answer so he goes away..
<6> oh.. too late
<4> haha
<8> he didnt want rowid, he wanted rownum
<8> rowid isnt a number
<1> oh
<1> well, I was close
<6> and WHERE rownum not HAVING rownum
<1> and I'm no oracle guru
<8> :)
<8> and I dont careto tell him
<1> I think it has to be having since you wouldn't know which row in the where
<1> consider the case of group by's and such
<1> but whatever
<6> i think google coulda answer that quickly
<8> it could have
<1> google has probably banned that guy for being rude
<8> which is why I dont care
<6> heh. i googled for 'oracle top rows' and hit i'm feeling lucky and it gave me the answer
<1> so what's shakin' cojones... long time no see
<6> not to be condesending, but #sql seems to attract more trolls and retards than channels twice its size
<1> Slade: should we act like the guys on #java then?
<7> because they can't come up with channel names like #mysql...
<7> or #oracle whatevre
<6> rmah: not sure what that would be.. i'd have no reason to join a java channel
<7> rmah:: how do they act?
<6> but i can imagine :p
<1> d2d_w0rk: nasty, harsh, brutal and perverted
<7> i used to hang out there but well, i don't use java no more...
<7> oh no wonder i used to get kicked, bruised and abused
<1> heh
<7> :) well, ... i am not in it no more
<1> I think #sql is quite nice, generally speaking
<7> go .net! (and C#)
<7> well yeah, quiet peaceful
<6> rmah: i dont think its the people. i think its the name
<1> Slade: eh?
<6> sql seems to attract more of those kinds of people than say c or c++ or some other name
<7> i think people do tend to perceive "sql -eq database"
<1> oh
<1> could be
<6> d2d: yea theres that
<1> but the regulars here are, all in all, good men. not young punks.
<1> except for that romanian guy, of course
<1> or bulgarian or whatever
<7> well, at least i am not one of them..
<7> by "them", i was referring to "romanians" and "bulgarians", not those "young punks" you were referring to :)
<1> heh
<6> it also seems alot more people come in here not knowing anything of sql than say someone joins #c or #asm or anythign not knowing anything
<3> slade it seems you make a lot of ignorant judgements
<3> it seems you like to seem a lot
<1> well, that's because most people think that if you can do: "SELECT * FROM foo" you "know SQL" and if you can do: "WHERE a = 3" you're a SQL guru!
<6> just random observations of looking at the channel on and off over the past year
<3> which no one really cares for to be honest
<3> whoever comes here comes here
<9> Whoa whoa, hang on there tex. WHERE is like 5th year SQL.
<1> heh
<1> I'm not a texan
<6> Darken|: i'm not arguing that the flow will change. i'm just observing the data. ;)
<10> you mean they teach update before where?
<6> heh
<3> rmah is proud to be from florida
<3> rmah was actually the core designer of our previous voting software
<3> :/
<6> rmah: you're a floridian? :P
<7> i learned how to do "create database" before "select" since i had to know how to create a database to run 'select' statements
<1> I'm not from florida
<10> i've heard them refered to as floridiots
<1> haven't been to florida in years
<10> i think is the pc term
<6> i have the misfortune of being in florida atm :/
<1> whereabouts?
<6> orlando
<1> ah, mouse country
<6> mouse and old people
<10> lol
<1> some of the chicks who work at the house of mouse are sort of cute
<1> was there for a convention once and hooked up with a chick working at treasure island
<1> my opening line was, "do you ever get tired of smiling all the time?"
<6> yea. gotta remember tho that younger women here have a higher concentration of stds than anywhere else in the country
<1> heh, now you tell me
<3> slade that's a bunch of bull****
<3> stop making up lies
<1> haha
<3> the more you speak, the more stupid you look
<6> thats what they said on the news ;P
<3> and i'm tired of reading your trash
<6> Darken|: /ignore works well
<3> or i can tell you to shut up
<3> that works even better
<6> oh. you're in florida
<3> don't spread your stupid ideas to others
<1> are you two married or something?
<6> that splains alot ;)
<3> www.dictionary.com
Return to
#sql
or
Go to some related
logs:
#hardware
#3dsmax
#beginner
theklepto.com
#firebird
ktorent Debian
#politics
#nhl
zetanor
#freebsd
|
|