« first day (464 days earlier)      last day (2390 days later) » 

11:00 PM
Whether the help-center described that very well is now fixed.
 
> I wish I could post my predecessor's code for reviewing here. But that wouldn't be nice.
Good question, so, it goes two ways, in my opinion - 1) you are not a real legal expert, and you cannot decide whether it really is compatible. 2) you really can say for sure it is OK to post someone elses code... then, it will still be off topic, not for legal reasons though, but because the code review will be criticizing someone who is not aware they are being scrutinized (the legal reason is only one of the reasons it is/may be off-topic) — rolfl ♦ Feb 14 at 5:11
@rolfl These two things suggest otherwise in that linked question.
 
I have found a new method of studying
I have to learn PLSQL for an exam in a few weeks so I just added the SQL and PLSQL tags to the list of tags I use in my search query
I won't even have to study!
Just wait for the questions and answers to naturally pass me by and read them
it's genius, really
 
This is how I've learned most of what I know about programming, through doing this on StackOverflow.
If I can understand the question, I'll hang around and wait for answers which I'll probably also understand. Each time I read and understand an answer, my knowledge has expanded and I'll be able to look at a slightly more complicated question next time.
 
nhgrif, I am still mulling things over here....
 
@JeroenVannevel I'm guessing you mean PL/pgSQL?
 
11:11 PM
@nhgrif Yeah, that's my general approach as well. But I haven't found much use for it in my classes yet, sadly enough
PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's procedural language extension for SQL and the Oracle relational database. PL/SQL is available in Oracle Database (since version 7), TimesTen in-memory database (since version 11.2.1), and IBM DB2 (since version 9.7). Oracle Corporation usually extends PL/SQL functionality with each successive release of the Oracle Database. PL/SQL includes procedural language elements such as conditions and loops. You can declare constants and variables, procedures and functions, types and variables of those types, and triggers. You...
 
I would assume PLSQL is Oracle-based sql
 
What Dan says
 
Oh, that may be the case
 
11:12 PM
I have no love for it :|
 
0
Q: Switching between tabs inside of a web application

BasI'm making a web application for the administration of a restaurant kind of type. The purpose of this application is to make customers, and the orders of those customers, which has products in it, etc... This application is written in PHP combined with jQuery. I have many tabs, such as: Displ...

0
Q: Random "programming language"

Vladimir PutinI decided to write my own programming language, of sorts. Essentially, you write code into a text file and the program will run the code inside the text file. The file is provided through a script argument. # Basic programming language from operator import eq, ne, lt, gt, le, ge from random imp...

0
Q: Loading and Using Lua Scripts

bazolaI have been experimenting with integrating Lua into Objective-C. I have tried to do the bare minimum to get Lua to compute values and return them. I did not want to use any external libraries so I have avoided those. All that is required to make this work is to add the Lua files to the project ...

 
Damn @CaptainObvious
 
Calm down, Captain
 
monking all
 
@DanLyons What's wrong with it?
 
11:12 PM
bazola is over 1k rep now... and he only has like 3 posted answers...
 
There are a lot of non-standard components when compared with ANSI SQL. For example, PL/SQL joins are different, and the (+) syntax for outer joins is odd.
 
It's probably not a good sign that I can't recall any plus sign or strange joins
What exactly is uncommon about them? techonthenet.com/oracle/joins.php
 
Oracle has tried to improve their parsing of ANSI SQL over the years, but that's been rather half-hearted. Sometimes you just cannot get around using PL/SQL, though I suppose that could have changed with 11 or 12
 
oh wait, it says it in the OLD SYNTAX section
yeah, thank god they moved away from that
I've only had to use the normal syntax
 
If you have nested queries, sometimes you have to use the old syntax :/ At least, that was true up to 10g
 
11:17 PM
@mjolka Hello!
 
bah, all the PLSQL code from 2 months ago at the exam looks so foreign right now
I'll have to actually go over it again
 
just come back... i've actually got a query for the room, if anyone is interested.
 
My interest is piqued (proper English)
 
@bazola Is that question code you made working from a tutorial?
 
11:22 PM
0
Q: Wrapper for jQuery Ajax to ensure redirects occur on clientside - Round 2

drezaA while back I posted an code review on handling ajax and redirects when a server side error occurs. Wrapper for jquery ajax to ensure redirects occur on clientside Since that post I've been using this module extensively (in MVC.net projects) and it works really well in conjuction with some ser...

ha, it's not actually an interesting query. it's self related
i posted a question, and was wondering how I could make it better to get some answers.
 
nevermind, he may or may not be alive
Schrodingers' Williams
 
@JeroenVannevel was that real?
 
Appearantly social media were going wacky
 
What is SELECT ... FROM DUAL in Oracle?
 
@Phrancis Dummy X
The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. In Oracle, the table has a single VARCHAR2(1) column called DUMMY that has a value of 'X'. It is suitable for use in selecting a pseudo column such as SYSDATE or USER. == Example use == Oracle's SQL syntax requires the FROM clause but some queries don't require any tables - DUAL can be readily used in these cases. == History == The DUAL table was created by Charles Weiss of Oracle Corporation to provide a table for joining in internal views: I created the DUAL table as a...
 
11:30 PM
yar dummy because Oracle can't omit the from clause
 
gutted. What a great actor
 
where in SQL Server you can just say SELECT 'dummy', in Oracle, you'd do SELECT 'dummy' FROM dual
 
Ah
That's a PITA
Or sounds like it, anyways.
   WITH cte1
        AS (SELECT 1 ID_100,
                   1 ID_200,
                   1 ID_300,
                   '600 Level 1' RESULT
              FROM DUAL
What's the purpose of the 1 in front of ID_100 etc.?
 
presumably 1 is the value, and ID_100 is the column name
 
@nhgrif sort of, I started from this luanova.org/ioswithlua and did the do it yourself method and tailored it to what i wanted to accmplish
 
11:35 PM
25
Q: What does it mean by select 1 from table?

Chirag FanseI have seen many queries with something like this.. Select 1 From table What does this 1 mean and how will it be executed and what will it return? Please also guide me in what type of cases this can be used??? Thanks in advance

I assume it just returns the value 1?
 
Yea, but there's more than just that.
IF EXISTS (SELECT 1 FROM Table WHERE Conditions)
This is mostly what it's useful for
You don't want the db wasting time actually figuring up columns or values for the columns
 
It seems to indicate true for a specific condition that allows you to not have to return actual data
 
Yea, sort of, but depending on the flavor of SQL, the ones I'm used to, you can't just treat it as "true"
That's what the EXISTS keyword does in my example there
 
I think this OP may be using it differently...? codereview.stackexchange.com/questions/27640/…
 
dear yuck
 
11:38 PM
Though with the amount of code he has, no wonder this takes so long
 
Holy that is confusing...
 
This is why I don't use SQL statements longer than 10 lines of code
 
Subquery much?
 
I've used very long SQL statements before... but you have to write it in a way that makes sense
 
If he's running 63 SELECT .. UNION ALL right off the bat... I would pick a CROSS JOIN over that
Maybe.
 
11:42 PM
Can you do recursive CTE in this flavor he's asking about?
Actually... if the CTE he's building is this big, he needs to just put a table in the database.
 
http://www.marinsheriff.org/uploads/854.pdf
http://www.sfgate.com/file/877/877-Marin%20Sheriff%20investigation%20into%20death%20of%20Robin%20Williams.pdf
http://www.bbc.com/news/world-us-canada-28749702
Looks like it's true after all
I trust the BBC
 
Actually, that^ is pretty bad... here's from SO
3
Q: Recursion In Oracle

myahyaI have the following table in an oracle: Parent(arg1, arg2) and I want the transitive closure of the relation parent. That is, I want the following table Ancestor(arg1, arg2) How is this possible in Oracle? I am doing the following: WITH Ancestor(arg1, arg2) AS ( SELECT p.arg1, p.arg2...

 
Well, it's pretty easy to tell when someone is trying to use a C or C++ library in Objective-C because holy god do C/C++ library authors have the absolute most cryptic of function names...
 
@nhgrif i agree! by the way, I do have 6 answers at least :)
 
Maybe they were written during an obfuscated code contest
 
11:58 PM
@nhgrif Definitely doesn't describe me at all....
 

« first day (464 days earlier)      last day (2390 days later) »