Home.... | log in.... | Pub my question! | Sign-up....

Java-index >> Java Essentials >> New To Java

SQL

I have virtually no knowledge of database.I need to learn abouttorque generated SQL script and Postgre SQL.Any link will be helpful.

[153 byte] By [jaaya] at [2007-10-2 20:58:22]

«« sub: code for accessing 4 webcams from the usb ports
»» Regular Expression and XML character help

# 1

> I need to learn abouttorque generated SQL script> and Postgre SQL.> Any link will be helpful. http://www.google.com/search?q=torque+generated+SQL+script+and+Postgre+SQL

jverda at 2007-7-13 23:43:06 >

top of Java-index,Java Essentials,New To Java...

# 2

Links to learn PL/SQL and Oracle SQL:

http://safari.oreilly.com/?XmlId=0-596-00381-1

http://www.orafaq.com/faqplus.htm

http://www.ss64.com/ora/

http://www.redhat.com/docs/manuals/database/RHDB-2.1-Manual/sql/sqlreference.html

http://www.psoug.org/reference/forms.html

http://www.mckoi.com/database/SQLSyntax.html

http://www.orafaq.com/faq/

http://www.ilook.fsnet.co.uk/ora_sql/sqlmain.htm

http://www.w3schools.com/sql/

http://www.vbip.com/books/1861001789/chapter_1789_02.asp

http://www.unix.org.ua/orelly/oracle/prog2/index.htm

http://www.unix.org.ua/orelly/oracle/

http://docs.hp.com/en/36216-90216/index.html

http://dnaugler.cs.semo.edu/oracledocs/a90842/

http://sqlcourse.com/select.html

http://members.tripod.com/er4ebus/sql/ch20.htm

http://www.cs.umbc.edu/help/oracle8/server.815/a67779/function.htm#1026778

SQL Loader:

http://www.oreilly.com/catalog/orsqlloader/chapter/ch01.html#92106

harleenfloraa at 2007-7-13 23:43:06 >

# 3

Except he was asking about Postgres, not Oracle.

jverda at 2007-7-13 23:43:06 >

# 4

Thanks

jimnortela at 2007-7-13 23:43:06 >

# 5

How does one discard interactive prompting in SQL*Plus?Help - much appreciated !

jimnortela at 2007-7-13 23:43:06 >

# 6

> How does one discard interactive prompting in> SQL*Plus?> Help - much appreciated !I suspect the answer to that could best be found in SQL Plus' docs or on a SQL Plus newsgroup or forum, as opposed to on a "New To Java" forum.

jverda at 2007-7-13 23:43:06 >

# 7

you mean to write an anonymous procedure?begin; my sql statements;end;it will take everything between the begin and end as a batch.

morgalra at 2007-7-13 23:43:06 >

# 8

I guess learning sql without a database to practice it on isn't very instructive.

why don't you learn about databases first.

I suggest mysql server. But even postgresql is great.

Then get a generic sql book e.g. www.quantrimang.com/download/ebooks/(ebook%20pdf)%20Teach%20Yourself%20SQL%20in%2021%20Days.pdf

and start learning sql that works on any dbms(Database management system e.g postgresql , oracle ) before tackling the specificities of each.

feea at 2007-7-13 23:43:06 >

# 9

You can also download Oracle and install it and use it for development purposes, there is also an Oracle Lite now that you can distribute with your apps--free.

morgalra at 2007-7-13 23:43:06 >

Java programming resources: FAQs, tutorials, compiler and browser download sites, documentation, books lists, IDEs, etc.

SQL

Java Essentials New Topic

Java Essentials Hot Topic

Java Essentials

All Classified