|
Wow, thanks for the really long answer and all the recommendations.
I use SQL Developer as my main tool now. It makes so much more sense than the internal tool I've been using!
I'll just be creating some small tables and procedures for now, so no query analyzing, handling massive real-time data and other hard stuff.
I did run into the mandatory FROM TABLE stuff, didn't really need it though so I didn't bother with it. Good to know it's FROM DUAL
Also found out Oracle doesn't know the bit/boolean data type (although PL/SQL does)
I've noticed Oracle has A LOT of features I don't know yet. Seems I'll need to read some Oracle book if I get to do more with it
|
|
|
|
|
Sander,
My Pleasure.
I would read Expert oracle by Tom Kyte. You can find it as a PDF probably.
I probably need to read it again... With a bottle of Red Wine... Ahhhh...
The boolean field is really a number(1) which can hold 0-9 (and null). If it is a boolean,
I usually put DEFAULT(0) value on it.
Another gotcha. A Unique constraint allows 1 null key value. That blew my mind.
I would have thought that a unique constraint would prevent. But you need both NOT NULL
and UNIQUE. Keep that in mind. I just fixed someones bug last week over this.
Enjoy!
|
|
|
|
|
|
Sander Rossel wrote: Say goodbye to good tooling.
Say goodbye to civilized (T-)SQL (I think the PL in PL/SQL means Oracle outsourced the language to some cheap Polish labor... (no offence to Polish people)).
Say hello to steep learning curve.
Could be worse. Way worse. Could be one of the no-sql bandwagon monsters.
|
|
|
|
|
jschell wrote: no-sql bandwagon monsters. Actually those are pretty fun!
|
|
|
|
|
You might want to start wallpapering your cubicle with Oracle error message translations like I had to.
Errors like "Bad END statement" really means "Label Not Found" (Honestly I wrote better parsers in high school) I'm guessing the parser found the END statement before the label and therefore blamed the END statement.
I had covered half a wall with these translations when I worked at an Oracle shop. I used to tell head hunters NEVER to send me to any place that was using Oracle.
I hoped the A-Team wrote the database engine, but it seemed the F-Troop wrote the user interface.
Psychosis at 10
Film at 11
Those who do not remember the past, are doomed to repeat it.
Those who do not remember the past, cannot build upon it.
|
|
|
|
|
The only times I've ever had to use Oracle I was very thankful for the tool called "Toad". Here's a link to one of the versions for Toad[^]. Hope that helped.
Mark-Harrington.Where(i => i.Was == "Here")
|
|
|
|
|
Looked at Toad and found it to be a little too expensive.
Maybe this freeware version can offer what I need, thanks!
|
|
|
|
|
I tried to paint something but don't fucs on that 2 much
|=8=/}->=
Hint 1: It's most effective at night!
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Telescope?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
If not for KSS rules, my answer would have been little more accurate
cheers,
Super
------------------------------------------
Too much of good is bad,mix some evil in it
|
|
|
|
|
Wow, was it that easy ?
You are up tomorrow
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Oh.
Bugger. It was a guess based on the clue and the pattern - I'm no good at these things!
So now I have to work out how to create one...damn.
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
...and I thought it was Mega Maid.
If you're having a bad day, stare at your feet and smile.
|
|
|
|
|
OriginalGriff wrote: I'm no good at these things!
You are good at solving
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Luck, pure and simple I assure you!
I have an idea, but would you mind if I ran it past you and you tell me if it's too simple, too complex (hah!) or just generally rubbish?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
You could do that I just don't know how you want to message me
Rules for the FOSW ![ ^]
if(this.signature != "")
{
MessageBox.Show("This is my signature: " + Environment.NewLine + signature);
}
else
{
MessageBox.Show("404-Signature not found");
}
|
|
|
|
|
Griff will send the message by carrier pigeon sheep.
|
|
|
|
|
We don't send carrier sheep to Europe: either the French set fire to them, or they get eaten by illegal immigrants...
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
On it's way already, going by today's news[^]..
How do you know so much about swallows? Well, you have to know these things when you're a king, you know.
modified 31-Aug-21 21:01pm.
|
|
|
|
|
If you are personally familiar with ThingWorx, (like, you've actually written a piece of code in an embedded device, and used ThingWorx) then...
Please give me your SHORT opinion, quick off the top of your head, about it.
Let's say, ten sentences max, with 75 words max.
Good stuff ? Bad stuff ? Made you money ? Lost you money ? Saved the day ? Ruined the world ?
|
|
|
|
|
Who meets my giant muscular programmers arms!
Last year I started working out, and for the first time ever pretty serious!
I think I held out for about two to three months, but I stopped and never picked up those dumbbells again...
Until about a month ago.
Unfortunately I couldn't lift what I lifted last year, so I took off some weight and started going at it again.
I just added the weights again and had a successful workout
Looking to buy some new weights as I start adding new workouts to my routine
|
|
|
|
|
Glad to hear it man. As devs, it's really important we stay physical like that to counter-balance all the sitting on our arses we do. So, rock on!
Jeremy Falcon
|
|
|
|
|
Thanks, will do!
|
|
|
|
|
Code with one arm, do curlups with the other then switch. Butt clenches. You could do your programming in one of those training chairs where you push weight with your legs. Or hold laptop with one arm, use other to type and do squats. It could be a new thing, out with the coffee and in with the smoothies and protein shakes.
|
|
|
|