I have oracle 10g installed on RedHat Entreprise 5.
i have 2 users that uses oracle :
uid=501(user1) gid=502(group1) groupes=500(oinstall),501(dba),502(group1)
and
uid=500(oracle) gid=500(oinstall) groupes=500(oinstall),501(dba),502(group1)
when a user tries to stop a listener that was st...
I have a table called Objects which contains some files, say:
User
Teacher
There is another table (States) which holds the possible states of these objects, like:
Active
Idle
Teaching
Resting
Authoring
And there is a third table (junction table) which logs each state change of each object...
@Phil @JackDouglas @rfusca I have to publicly apologize for mocking Oracle. In the end, it was the DBA's information that was incorrect and not the server.
@Lamak i guess i got flagged for OT or too chatty or not constructive or something. i felt like it was extremely constructive to demonstrate the levels of a game of "most on the post" that the community was going through
Im trying to get users total visits number per each web URL page that stored in my database.
Bellow is my SQL query that will show total unique users where URL contains that keyword.
SELECT COUNT(DISTINCT userId) as title1TotalVisitors
FROM someTable
WHERE urlCol LIKE '%Url-Title-1%'
Now I hav...
Question: Being fairly new to stackexchange, I wanted to ask about proper etiquette for responding to questions. If I want to answer a user's question, and I have my own blog post that explains the answer in detail, can I post that link? Or is it better just to answer the user's question in detail on stackexchange?
@swasheck Yes. Startups have very little money and I had to physically reposess an XW9300 I built as a dev server for them. Someone I worked with told me that they had been stiffed by 3 smaller firms.
Apart from that they tend to have a nice, laid-back atmosphere and (in the best case) all the nice things the silicon valley wonks rave about when they start waxing lyrical on startups.
@rfusca And real men can install pre 8.1 oracle by figuring out which shared libs to scrounge from RedHat and link into the image. Hyper-real men can work out which SCO Unix shared libs they need to install 7.3.
I have an imaginary component, which makes me complex. This also means I'm allowed to eat quiche.
@swasheck Perhaps you are transcenental or surreal?
@swasheck Depends on the risk profile you want. If the compny succeeds you're the 'fourth employee' and will have a pretty nice wicket. If it goes titsup you're buggered. Some people get off on working for startups.
If I had (say) John Carmack's programming talent I'd probably be into startups.
However, I'm way past any lofty ambitions of changing the world and I'm settling for contract work in a relatively stable and cash rich market that I happened to get into by coincidence.
Actually, getting Oracle 8.0 working on Linux wasn't that hard. There were plenty of Oracle-on-Linux HOWTOs on the web with a pretty short time after Oracle released 8.0 on Linux. There were even HOWTO docs on using the SCO libs on Linux to run 7.3 on it.
@swasheck Sales and marketing companies are pretty crap to work for. If you go back far enough I've even worked for a little cowboy sales outift. They're almost always scum.
that was what i thought too "I wanted to reach out to you regarding a new opportunity we just got word of. It is a new client of ours called Swiftpage. It is a email marketing company, around 30 employees, younger, entrepreneurial environment; casual work environment; very collaborative, 'family-oriented' team (often tossing a ball back-and-forth to each other while brainstorming ideas)."
May be crap. May be OK. I think the faux-'90s dot-com symbolic capital sounds a bit try-hard. Maybe evidence of a bit of corporate hypocricy going on; trying to convince themselves that they're really the next comong of Amazon.com
I think I can make a reasonable claim to have actually done real creative work. Edison's take on invention being 90% perspiration is spot on. Brainstorming sessions and throwing stress balls around sounds a bit like people trying to convince themselves that they're really creative.
Although it can involve team work - often thrashing out stuff on a white board with somebody. I've never really had much joy from big team brainstorming sessions, though.
Sorry to sound negative but the whole 'tossing a ball while brainstorming' stuff is straight out of hollywood. I doubt even scriptwriters actually do that.
@swasheck Question: What use does an outfit like that have for a DBA or back-end developer. Do they have a high volume .com site that needs a database tuned and running 24x7?
If they do then they might have a decent role for you.
What does it do - maybe they grab stats off web sites and have some analytics hidden behind the login. If so maybe they have a genuine requirement.
Reading the feature set on the web site it gives the impression that they have some sort of hosted turnkey e-commerce system. Maybe they have a genuine requirement for uptime and performance.
@bluefeet if he has your email address, you can reference @AaronBertrand and you get a cryptic email back. i think it's a viral marketing campaign for his new in-memory distributed RDBMs
I read an aphorism that goes something like: If the company is run by the people who make the product then you're sweet. If the company is run by the people who sell the product then you're probably still OK If the company is run by accountants then you should start looking for another job. If the company is run by lawyers then you should get out of there as quickly as posible. Run. Don't walk.
They didn't have anything specific to say about when the company is run by Bain Capital.
@swasheck If they come across like tossers they probably are.
@swasheck Was in response to a conversation with HGLEM where it came out she is a lady. She pointed out that with my username and picture my gender was not obvious so I put it into my profile.
I need to delete some rows from a table, based on a mixed where statement from two tables.
I tried this:
delete from tblI t1, tblS t2
where t2.rcode = 'ALA' and t1.sid > 5
but I get a syntax error. Please help me figure this out
Changed it to JOINS:
delete from tblI
inner join tblS
on t...
I'm looking for information about both products and your experience would be a big help. I'm aware that Oracle RAC and MySQL Cluster uses different architecture and that Oracle RAC has single point of failure where MySQL doesn't, RAC scales vertically, MySQL Cluster horizontally, but in practice,...
@bluefeet: What exactly is the average population per city? I would expect the cities table to have one row per city, so what is the meaning of average?
Does anyone actually go to user group meetings? Or are they just things sales people hold so they can buy a bunch of free food under the guise of talking to users?
I have two tables, X and Y, with identical schema but different records. Given a record from X, I need a query to find the closest matching record in Y that contains NULL values for non-matching columns. Identity columns should be excluded from the comparison. For example, if my record looked ...
@BenBrocka I always thought it should have been called "join". The company was app.net before they even had this product. And the signup page was join.app.net.
app.net sounds like a redistribution site for table/phone apps
@BenBrocka dont know really as UX/UI is not really my strong point, but i go there and i think ... "man, did they just take facebook's style sheet and change the font?" maybe it's just a matter of perception, and i'm totally wrong.
I need to connect an application to Oracle. In the installation guide for that application it says that it requires 64 bit version of Oracle Data Access Component,more specifically 10.2.0.3 . I have tried installing it but I am continuously getting the error attached in the image when ever I try ...
@swasheck I often wonder how many of these "I need to make sure my theoretical app will scale to facebook or google size" actually ever even end up with any product at all
I have oracle 10g installed on RedHat Entreprise 5.
i have 2 users that uses oracle :
uid=501(user1) gid=502(group1) groupes=500(oinstall),501(dba),502(group1)
and
uid=500(oracle) gid=500(oinstall) groupes=500(oinstall),501(dba),502(group1)
when a user tries to stop a listener that was st...
I have a table called Objects which contains some files, say:
User
Teacher
There is another table (States) which holds the possible states of these objects, like:
Active
Idle
Teaching
Resting
Authoring
And there is a third table (junction table) which logs each state change of each object...
Im trying to get users total visits number per each web URL page that stored in my database.
Bellow is my SQL query that will show total unique users where URL contains that keyword.
SELECT COUNT(DISTINCT userId) as title1TotalVisitors
FROM someTable
WHERE urlCol LIKE '%Url-Title-1%'
Now I hav...
I need to delete some rows from a table, based on a mixed where statement from two tables.
I tried this:
delete from tblI t1, tblS t2
where t2.rcode = 'ALA' and t1.sid > 5
but I get a syntax error. Please help me figure this out
Changed it to JOINS:
delete from tblI
inner join tblS
on t...
I have two tables, X and Y, with identical schema but different records. Given a record from X, I need a query to find the closest matching record in Y that contains NULL values for non-matching columns. Identity columns should be excluded from the comparison. For example, if my record looked ...
