| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10
Comments:
<0> Hi all, i'm using oracle. Are there any GUIs that can accelerate the data insertion process
<1> wxrkny : ms-access
<0> how do i use access to work with oracle
<2> hrm, reflections pretty cool ... heh
<1> wxrkny : read the instructions
<3> zoul are you slacking at work again
<2> Darken|: I never do ... I take 'thought' breaks
<2> which, being as I mostly get paid to think ... is a good thing to the employer ;)
<3> so you say
<3> :P
<0> gunther would i use sql*loader?
<1> you could
<0> is that what you were talking about with access?
<1> no
<2> heh
<0> because i got nothing useful in access help when i searched for oracle
<1> i'm not surprised
<3> zoul check your PM
<0> can you please explain a little more about using access to work with oracle
<1> 'linked tables'
<0> thanks i look that up
<4> so, i know that im supposed to use Stored Procedures 'always' but..
<4> I just made a view that has every column i want in a SELECT query
<4> do i still need to make a SP to do the SELECT * FROM View...
<4> and call the SP from my client app?
<4> or would it be best to just use T-SQL in the app
<5> why are you supposed to use SP always?
<6> is there a way for me to join or connect to mulitple domains? for example, right now I have MY Computer and a domain
<4> because Yuppie kicks my *** if i say i dont
<5> is yuppi your BOSS?
<4> no, but im like level 1 and hes level 274
<4> in levels of noobness
<7> i'm trying to write some pl/sql.. i have a loop and within that loop, i say name := '&input';
<7> however, when it loops through, it doesn't re-prompt for the input
<7> how can I make it reprompt for the name value when it loops back through?
<8> hold Fizzter i bring the dba guy he will answah
<9> hello?
<7> hi
<9> Fizzter?
<9> wtf?
<10> in (MSSQL)T-SQL, is the only way to order by dynamically using CASE? It's incredibly limiting if it is
<5> whats t-sql?
<5> never 'worked' *cough* with mssql
<11> there's probably a way to either set the collation for a column or to create a custom type domain with a custom collation
<11> there is in postgres
<11> so one ***umes that MS-SQL has a similar feature
<12> interesting, yet scary solution
<12> works w/ mssql
<11> why scary?
<12> well maybe not scary, but creating a collation seems daunting for something seemingly as simple as custom sort order
<11> a custom type domain seems to be the thing you want
<11> a collation *IS* a custom sort order
<11> dufus
<12> but i didn't create the ones that came with mssql
<11> so?
<12> so? I didn't have to create the ones that came with mssql.
<11> for the ones that didn't... you'll have to create them
<13> yo yo good fellas
<12> so say you want product XR324 to sort before XF326 but after ZF405
<12> how would a collation handle that?
<11> that's up to you
<12> ah-ha, so in other owrds it cant or you dont know?
<11> there is nothing "natural" about A being "before" B
<13> lol
<13> yes there is
<12> so you would have to specify each "product" in this case
<13> the ascii value is smaller
<11> no, it's just convention
<13> ...obviously
<11> haha
<12> how would you go about keeping the collation up to date?
<11> phargle: that's your problem
<11> phargle: this is why people we call "programmers" get hired
<12> mm hmm.. so now your solution requires additional staff
<12> i dunno, there's got to be a btter way.
<11> what? magic?
<12> like adding a custom sort seq column to a table or something.
<12> would scale much nicer than collation
<11> that is one way to *define* a collation
<8> TALK TO THE DBA GUY PPL
<12> a collation as you mentioned is an object in the database, not a column in a table
<12> im not arguing that a collation would work, its an interesting preposition..
<7> one of my named columns is showing me ######## .. it's set up like SELECT var1 + var2 AS total FROM blah;
<7> how can I make it display the proper number?
<12> actually, lol.. the products in my example would could be sorted using most collations in descending order
<14> [using Access] using a SELECT INTO statement, is there a way to define column properties of the resulting table?
<11> [rb], you don't have to, they're defined by the select
<5> if you meant that your target table has wrong datatypes you need to do the cast in the select and improve your questions :)
<11> war is deception -- Sun Tzu
<14> rmah: I need the resulting table to have two columns that do not come from the original table, one of which would be an Autonumber
<14> ztod: nah, they're the correct datatypes :)
<11> you don't want to use SELECT INTO then
<14> rmah: doh.. it was so perfect otherwise. :)
<14> rmah: what I guess I really want to do is define a table, and select insert into it certain records from another
<11> do an: INSERT INTO new_table (col_list) SELECT col_list FROM old_table
<14> rmah: omg. duh. thanks.. (sorry, I quite doing this stuff years ago, now I'm just trying to use old skills toward a new task.. rusty brain)
<11> I only pretend to know SQL
<13> what else is new?
<11> I'm still feeling ill
<15> qantische
<15> ;)
<15> quantische*
<11> quantische?
<14> rmah: it totally worked, bad***, thanks!!
<11> it's only pretending to work
<13> rmah: he's french
<11> heh
<11> pity the europeans
<14> where is a good place to ask questions about non-sql related Access development?
<16> I got a live database and now one row in one table has been corrupted in some way. I cant look at it with enterprise manager or query analyzer or anything. And my application derails because of it. How can i remove a corrupted entry?
<17> do you know what the rows key is?
<18> "corrupted"?
<16> yes I have the key
<17> have you tried a delete?
<16> Halo_Four, query analyzer wont display it when asked for it
<16> delete, update didnt work
<18> error is?
<16> tried delete between this id and that id (where the corrupt id is in between)
<16> the error is our application derails when it uses the database, because one row is corrupt
<16> and query analyzer cant reach or affect it
<16> query analyzer hangs and gets a timeout when we try to remove the entry
<18> Try SELECT * FROM Table1 WITH (NOLOCK) WHERE ID = @id in QA
<16> trying it, thanks... hang on
<16> it worked to select it, now were gonna play with changing it. Big thanks !
<16> Okay we manage to select it, which is huge step in the right direction. But it wont allow the NOLOCK in anything but a select statement, so how can we remove or change it?
<18> The fact that you can select it with NOLOCK implies that another spid has a rowlock on that table which is preventing other statements from running.
<16> Thanks again ! We'll check on that
<18> sp_who2 and sp_lock will help, or try selecting it without NOLOCK and check EM to see what spid is blocking
<17> sp_who
<18> Probably a transaction left open somewhere
<16> Thanks we're checking it out
<16> The row is now finally deleted ! Not entirely sure what did it in the end tho ;-\ Anyways a huge thanks for the help !
<19> hey i got oracle 9i from my teacher, and i installed it on my pc, i'm trying to log in but can't figure out how. i only filled in two thing when i was installing like an sid, and a p***word, and i tried those numerous ways, but i still can't get in
<13> scott/tiger?
<19> what would eb the host string?
<19> oh it worked
<19> thanks
<19> and here i was all ready to uninstall it
<19> lol
<19> how would i add a new username?
<13> duno
<13> that's the only thing i know about oracle :)
<19> oh ok well i changed the p*** so thanks
<19> LOL
<13> scottie
<13> where's sqlserver license serial# stored in registry?
<13> how to get it
<20> haxor detected!!!!11!1oneone!
<12> lol
Return to
#sql
or
Go to some related
logs:
#nhl
freebsd slingbox
#politics
#windows
worlddatinghere
break dvr-ms copy protection
#hardware
find file asms
#politics
chineese firebird
|
|