dynamik wrote: »
Probably due to a lack of activity. I can't remember the last time I even saw an Oracle post. It doesn't make a lot of sense to create a dedicated forum for a topic that will only have a few posts per year. If it ever picks up, I'm sure the powers that be will create a forum for it, just like everything else.
UnixGuy wrote: »
I think if there's an Oracle forum, new people will sign up and start participating.
RobertKaucher wrote: »
But maybe it might be better to have a general SQL forum ...
RobertKaucher wrote: »
I would certainly be willing to participate. But maybe it might be better to have a general SQL forum in the same way there is no VMWare forum and no Hyper-V forum? I don't know...
phoeneous wrote: »
stephens316 wrote: »
I would like to start studying SQL I have no idea about would like to know where to start.
SELECT cases.case_number, cases.style, sum(acct_transaction.amount) as Amount
FROM acct_banktran INNER JOIN
acct_bank ON acct_banktran.bankaccount_sk = acct_bank.BankAccount_sk RIGHT OUTER JOIN
acct_transaction ON acct_banktran.banktran_sk = acct_transaction.banktran_sk RIGHT OUTER JOIN
cases ON acct_transaction.case_sk = cases.case_sk
WHERE (acct_transaction.trans_type = 't') AND (acct_bank.Description LIKE 'AZ%') AND (acct_transaction.eff_date > '2009-06-15')
AND (acct_bank.Description = 'WFB Trust 2009' OR acct_bank.Description = 'WFB Trust 2008')
GROUP BY cases.case_number, cases.style, acct_transaction.trans_type, cases.case_sk
ORDER BY cases.style, cases.case_number
A lot of OCA/SCSAs might pick up in the coming months (when the ORACLE-SUN deal goes through).
I like that idea. MySQL is becoming a bigger and bigger part of my job.
Agreed. It would be cool to have a sql area.
Current Studying : GPEN |GCNF|CISSP??
Current Reading : CISSP| CounterHack|Gray Hat Hacking
Completed 2019 : GCIH
Free Reading : History Books
I pretty much taught myself t-sql in about a week. If you have a vm, throw sql express on there and start learning. Once you understand basic syntax and commands, its pretty intuitive from there.
Here is an example of a basic query:
I did this years ago. Try looking here:
W3Schools Online Web Tutorials
Go look under the SQL tutorials and go from there. Pick up a a "...in 24 hours book".
Also grab a copy of oracle/sqlexpress/mysql and start going.
SQL Server 2000 and 2005 exams - TechExams.net IT Certification Forums
SQL Database Exams - Oracle (9i, 10g, 11g) MS SQL Server (2000, 2005, 2008.) MySQL