logs archiveIRC Archive / Freenode / #oracle / 2010 / June / 23 / 1
hypno
oh, you can consider yourself lucky. you've evidently not been in the unix business long enough to go from "strange" to "boring" to "depressing" to downright "sucicidal". :)
m0t3jl
hypno, i've been there for almost 10 years ;)
hypno
heh.
Trengo
i did that a while ago, all it took was asking google
m0t3jl
Trengo, what did you ask Google? I tried everything, nothing pop up...
gigasoft
how to count words in the column cell
archangle25
is it possible to update a column based on its type.. eg varchar2?
Xgc
archangle25: I don't know what you mean by that. But you certainly can determine the type of a column.
I just don't know what "update based on type" means.
archangle25
Xgc, so for every row in a table, I want to set all integers to say 1;
or varchars2 to "blah"
         

Xgc
archangle25: There's a DEFAULT column specifier that can do that in the CREATE TABLE statement.
There is only one type per column per table. So there's really no concept of variable column type.
archangle25
ahh.. doh
wood for the trees
Xgc
So for each column in your CREATE TABLE statement, just provide whatever DEFAULT you wish.
archangle25
I'm just trying to put together a series of tests to hammer the DB so we can get a baseline for our new SAN
(before we accept signoff )
Xgc
Oh. In that case, you'll want to populate differently for each table anyway. Use the same method for all rows in any specific table.
archangle25
so you mean for the 100+ tables, update the varchars on the 1st table, then the ints on the second... or something similar?
mix it up to get a decent combination??
tynar
Hello, can someone tell me what is the difference between using vairables in query and using constant? if I put a variable to where clause i.e. "where date between (:start_d) and (:end_d)" in toad , the query is very slow (14 min). If I write there "where date between to_date() and to_date() result is coming in 190 msec. How can I speed it up? Views are used
mgolisch
did you use the same value for to_date ?
tynar
mgolisch: yep
mgolisch
or are you saysing that using variables the same statement executes slower?
tynar
yes, I wanted to put it to APEX, but since it is slow, I am extracting from database manually
mgolisch
and :start_d and :end_d have the same value you passed to to_date?
tynar
yes, when I hit F9 (run) I enter the same value
explain plans are a bit different, costs when I use variable is high
abhi_nav
is creating account in oracle is free? do i need to pay to creat account or to download oracle 11g?
tynar
abhi_nav: download xe
abhi_nav
what is 'xe'?
tynar, hey what is 'xe' i dont understand
??
tynar, can you please explain?
sytse
abhi_nav: you have two free options: oracle xe (express edition; which you are free to use for many things, but I do advise you to read the license terms well), and the full-blown most modern oracle package, which has none of the limitations that oracle xe has (xe is an old version, and has a long list of limitations built into it), but you're only allowed to use it for development purposes, and only for development of things you're not ...
... actually going to *use*, for if you want to use software developed on non-xe oracle, you're going to have to pay for a license
http://www.oracle.com/technology/products/database/xe/index.html
abhi_nav
sytse, actually I am a student. and I want oracle for education purpose. thats why I want free version. can you please give me alink to donnwload free oracle. i am not usign it for commercial purpose.
sytse
so developing open source software or indeed anything you actually want to use internally or externally, can initially be done on an unpaid oracle 11g, but you're going to have to pay as soon as you use it (or switch to oracle xe I guess)
abhi_nav: the limitation on using the oracle 11g software without a paid license are much more severe than 'don't use it for commercial purposes'.. even providing a free-to-use website without ad revenue or indeed any kind of revenue based on oracle 11g, or using an application you developed for yourself only based on oracle 11g, is not allowed
abhi_nav
no no
         

sytse
abhi_nav: http://www.oracle.com/technology/products/database/oracle11g/index.html <-- there's a download link there too
abhi_nav
I am not doing anyting of that
i just need to do project. we have subject called advanced database and i need oracle to learn and to implemetn assignments teach in college ec
ok
which I should download? western european or universal? I live in india
sytse, ^^
sytse, for that free account also it ask me to sign up. and it ask for home address telephone etc
should i create account?
*for that free download also...*
sytse
yes, iirc you do need to create an account to download it for free
btw, installing and properly configuring an oracle database is not for the faint of heart ;-)
starting out with mysql or postgresql is much easier
mgolisch
any idea why some of my sheduler jobs fail?
it says key has expired
and the error message is /bin/sqlldr : no such file or directory
doesnt seem to happen eveerytime
whats even more weird is i do source a file that sets oracle_home the sid and whatnot
so $ORACLE_HOME/bin/sqlldr should work allways
any ideas?
no one?
srm
Hi #oracle. Running 10.2 where I have a table with a LONG field. I tried to select this field using to_clob or to_lob, but both functions throw an error at me: Inconsistent datatypes. "expected - got LONG" for to_lob and "expected NUMBER got LONG" for to_clob. The query is plain "SELECT to_lob(field) FROM table". What am I missing here?
The main problem is, that I want to move these values into a new table, where I have declared the corresponding field to be CLOB. IIRC, I've worked with this approach using 9i - don't know what I did different back then ... Any hints appreciated.
I've solved this for now by using COPY but that still doesn't explain this behavior to me -.-
Dormir
LONG != LOB
sorry, meant to say LONG does not function the same...it's an odd datatype. is to_clob supposed to work with LONG
read the docs. it explains how to_clob and to_lob can be used
srm
Right, to_clob would be wrong, but "to_lob( long_column )" is expected to work.
as usual, if there are docs, use them. http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/functions185.htm quote: "You can apply this function only to a LONG or LONG RAW column, and only in the select list of a subquery in an INSERT statement."
« prev next »