261 reputation
1514
bio website
location
age
visits member for 3 years, 3 months
seen Nov 22 '13 at 2:55

Apr
25
comment Switching to NoSQL for native JSON use?
Thanks for your comments, I have upvoted this.
Mar
18
comment Defining constraints in `CREATE TABLE` statements
Phil/a_horse_with_no_name [BTW: Clint Eastwood parody? =P]: So it seems that there are some advantages with keeping things self contained, and other advantages (see answer by @MikeSherrill'Catcall') for keeping them separate. Maybe I just need to flex my Python knuckles and build a two-way script? :) - Leigh: Guessing that constraints incur less overhead? - Mike:\t\t\t\tIndentation FTW!
Mar
18
comment Defining constraints in `CREATE TABLE` statements
Wow, that's a very useful use-case that I hadn't considered! +1
Jun
5
comment Where do caching servers conceptually fit in my architecture?
Thanks for that, very well explained. [accepted & +1]
Dec
19
comment How can I generate an Entity-Relationship diagram and SQL DDL from natural language text?
Thanks, this is what I was looking for!
Nov
19
comment How can I generate an Entity-Relationship diagram and SQL DDL from natural language text?
Awesome, would you be able to share this?
Nov
8
comment PL/SQL problem statement for homework study
Thanks, can you reopen the question and post that as an answer?
Nov
7
comment PL/SQL problem statement for homework study
Nope, it's not for a certification. I have been learning PL/SQL at university, and we have an exam testing our PL/SQL skills (amongst other things). So what I am looking for is an "assignment" which I can do to gain experience with PL/SQL.
Oct
30
comment Generate sample data for an Oracle database
Didn't work for me. benefactor.bat 1> log1 2> log2 log1(pastebin.com/wk3RKhfj) log2(pastebin.com/Em0faE5H)
Oct
25
comment ORM-style server-side programming languages (OO replacement for PL/SQL?)
Doesn't need to be for multiple platforms, I should've used xor instead of or. An OO alternative would be nice, since procedural is less commonly used nowadays.
Oct
12
comment Automated UML2 Class Diagram generation from SQL?
Hmm, not sure what happened to the link. Anyways, here it is: forum-omondo.com/documentation_eclipseuml_2008/Eclipse_Database/…. Also of note, ObjectAID is apparently better than JPA; so try it out!
Oct
11
comment How do I create a database+tablespace+user in Oracle 11gR2?
Maybe it's because I'm running "Oracle Database 11g Express Edition", that it doesn't show up?
Oct
10
comment What's a good client tool to access Oracle RDBMS?
Downloading DBVI, can someone confirm David Mann's point?
Oct
10
comment What's a good client tool to access Oracle RDBMS?
"PL/SQL Developer" looks quite good, downloading it now. I've been running SQL Developer 3.0.04 (BUILD MAIN-04.32), seems stable enough. Thanks!
Oct
10
comment What's a good client tool to access Oracle RDBMS?
That I can't walk-through the debugger. If there's an error, I can't just click on the error and it jumps to the line.
Oct
10
comment What's a good client tool to access Oracle RDBMS?
I'm looking for a replacement to Oracle SQL Developer, the tool I currently use to connect to my Oracle database.
Sep
29
comment Automated UML2 Class Diagram generation from SQL?
Looks like I can build an OO model straight from the ER Diagram in PowerDesigner. This one however, doesn't have the getter and setter operations.
Sep
21
comment Oracle 11g - Create Database fails?
Unfortunately this didn't work. Output: pastebin.com/B1umZZYZ Please tell me how to make it work.
Sep
21
comment Oracle 11g - Create Database fails?
Thanks, but I can't find DBCA on Oracle 11g Express (Windows). Any ideas where I can download it?
Sep
21
comment Learning Oracle, does it matter if I install 10g or 11g?
Thanks. Windows 8 available here: msdn.microsoft.com/windows/apps/br229516. Just basic SQL and PL/SQL. I will install 11g, thanks for confirming.