The 2nd Monitor

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.

Jeroen Vannevel

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

nhgrif

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.

rolfl

nhgrif, I am still mulling things over here....

Phrancis

@JeroenVannevel I'm guessing you mean PL/pgSQL?

Jeroen Vannevel

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

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...

Dan Lyons

I would assume PLSQL is Oracle-based sql

Phrancis

a.k.a. postgresql

rolfl

What Dan says

Phrancis

Oh, that may be the case

Jeroen Vannevel

yup

Dan Lyons

11:12 PM

I have no love for it :|

Captain Obvious

0

Q: Switching between tabs inside of a web application

I'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"

I 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...

python python-2.7 interpreter

0

Q: Loading and Using Lua Scripts

I 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 ...

objective-c modules lua

Damn @CaptainObvious

Calm down, Captain

monking all

@DanLyons What's wrong with it?

nhgrif

11:12 PM

bazola is over 1k rep now... and he only has like 3 posted answers...

Dan Lyons

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.

Jeroen Vannevel

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

Dan Lyons

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

Jeroen Vannevel

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

Dan Lyons

If you have nested queries, sometimes you have to use the old syntax :/ At least, that was true up to 10g

syb0rg

11:17 PM

@mjolka Hello!

Jeroen Vannevel

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

dreza

just come back... i've actually got a query for the room, if anyone is interested.

syb0rg

My interest is piqued (proper English)

Jeroen Vannevel

news.kron4.com/news/…

nhgrif

@bazola Is that lua question code you made working from a tutorial?

dreza

11:22 PM

0

Q: Wrapper for jQuery Ajax to ensure redirects occur on clientside - Round 2

A 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...

c# javascript asp.net-mvc

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.

Jeroen Vannevel

nevermind, he may or may not be alive

Schrodingers' Williams

dreza

@JeroenVannevel was that real?

Jeroen Vannevel

@dreza You tell me: en.mediamass.net/people/robin-williams/deathhoax.html

Appearantly social media were going wacky

Phrancis

What is SELECT ... FROM DUAL in Oracle?

Jeroen Vannevel

@Phrancis Dummy X

DUAL table

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...

Dan Lyons

11:30 PM

yar dummy because Oracle can't omit the from clause

dreza

gutted. What a great actor

Dan Lyons

where in SQL Server you can just say SELECT 'dummy', in Oracle, you'd do SELECT 'dummy' FROM dual

Phrancis

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.?

Dan Lyons

presumably 1 is the value, and ID_100 is the column name

bazola

@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

Jeroen Vannevel

11:35 PM

25

Q: What does it mean by select 1 from table?

I 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

mysql sql plsql

I assume it just returns the value 1?

nhgrif

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

Jeroen Vannevel

It seems to indicate true for a specific condition that allows you to not have to return actual data

nhgrif

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

Phrancis

I think this OP may be using it differently...? codereview.stackexchange.com/questions/27640/…

Jeroen Vannevel

dear yuck

Phrancis

11:38 PM

Though with the amount of code he has, no wonder this takes so long

nhgrif

Holy that is confusing...

Jeroen Vannevel

This is why I don't use SQL statements longer than 10 lines of code

Phrancis

Subquery much?

nhgrif

I've used very long SQL statements before... but you have to write it in a way that makes sense

Phrancis

If he's running 63 SELECT .. UNION ALL right off the bat... I would pick a CROSS JOIN over that

Maybe.

nhgrif

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.

Jeroen Vannevel

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

Phrancis

@nhgrif apparently

Actually, that^ is pretty bad... here's from SO

3

Q: Recursion In Oracle

I 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...

oracle recursion

nhgrif

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...

bazola

@nhgrif i agree! by the way, I do have 6 answers at least :)

Dan Lyons

Maybe they were written during an obfuscated code contest

syb0rg

11:58 PM

@nhgrif Definitely doesn't describe me at all....

Transcript for