|
Solution Search:
The other day I was going through some tutorials about using the CASE expressions used in the ORDER BY clause of a SELECT statement. Can you
please explain it through some easy examples for a better understanding?
Using a CASE expression in the ORDER BY... More... Jul 16, 2008
database designers, with due regard for functional dependencies—even though they might not know what "functional dependencies" are, they still manage to do it correctly.
Most SQL tutorials and references suggest that you should strive to attain third normal form. Here's a quick rundown on the first three normal forms: First normal form (1NF) has two requirements: that there be a primary key, and... More... Jul 3, 2008
the database to connect, thus my dilemma. Could you please give me your advice on how I should go about connecting this database? Thank you for your time. My advice is brief and simple: read some tutorials on primary
and foreign keys. If you pop that phrase into your
favorite internet search engine, you will get many excellent results.
If your question didn't sound so terribly much like a homework assignment, I... More... Jun 19, 2008
are really stretching the bounds of credibility
in your closing paragraph. The answers to those questions are in your material, assuming that your material is even the most basic of SQL tutorials, and not a fennel soup recipe.
For the first question, consider the following query: select char(34,72,101,108,108,111 ,32,87,111,105,108,100,34) as messageIs this a column? In the strictest sense, yes. But notice that... More... Apr 26, 2007
data structures,
which are not susceptible to insert, update, and delete anomalies (for a good
explanation of these, see the Wikipedia Database normalization article).
One of the best tutorials on the Web for data modelling (of which normalization is a most important part) is: Introduction to Data Modeling by the Information Technology Services department at The University of Texas.As far as... More... Mar 22, 2007
Below you'll find our most popular Oracle tutorials and other content of the year -- these are the pages that drew the most readers to SearchOracle.com in 2006. Check out, again or for the first time, the best of '06: our top five learning guides, tips, original news...
More...
Dec 12, 2006
If you're looking for Oracle tutorials, look no further. One of the best resources we offer here at SearchOracle.com is our collection of learning guides -- original, in-depth tutorials on everything Oracle. These educational tools are great for...
More...
Nov 29, 2006
style sheets. There is a whole range of XML standards, APIs,
tools, editors and utilities. However, their coverage is beyond the scope of
this book. There are tons of online resources, tutorials and FAQs about
XML, such as the following: http://www.w3.org/XML/Schema
http://www.w3.org/TR/xmlschema-0
http://www.w3schools.com/xml/default.asp
WSDL The Web Services Description Language (WSDL) is an XML language... More... Aug 9, 2006
93; commitment to the .NET community," said Willie Hardie, Oracle's vice president of database product marketing.
Hardie said that along with the downloads, Oracle is offering free related tutorials for existing customers and newcomers interested in using .NET in conjunction with Database 10g. The new releases can be downloaded from the Oracle Technology Network site, he said. The latest version of... More... Aug 1, 2006
a self-dubbed Oracle newbie? Are you in the early stages of your Oracle research? Seeking some quick answers to your tough questions? Here's a list of beginning Oracle resources, including tutorials, expert technical advice and FAQs. Introducing Oracle
Learning Oracle basics
A short Oracle tutorial for beginners
Resources for Oracle newbie
Getting started with Oracle
PL/SQL: What, when, and where...
More...
May 23, 2006
This code provides an efficient and compact solution for"numeric money conversion intto words. The script generates a database function, so it could be called from any program running on an Oracle database like any regular database function. It has been tested on Oracle 8, 8i and 9i. It is designed for Euros, sterling Irish pounds and dollars but it could be extended to cover other world... More... Sep 14, 2005
from a browser, it will be http://<your apps server_name>:<port#>. This should take you to the install portal screen. Click on "Apps Login Links" and then OAM. There are loads of white papers and tutorials on the Oracle Web site. We are currently using E-Business Suite 11.5.7 on a single-node installation, with db
and apps on the same node. When we detect a high CPU usage with a glance,
it's difficult to find out what is...
More...
Aug 25, 2005
12 new 10g features in a nutshell: Want a review of the new features that came with Oracle 10g? Read these excerpts from "Oracle Database 10g new features." You'll find feedback, sample code and tutorials for each Oracle 10g tool. Transfer data from Oracle 9i to Oracle 10g: Expert Maria Anderson shows the easiest method of transferring data to Oracle 10g from Oracle 9i. 10g is Oracle's grid computing product...
More...
Aug 23, 2004
only the most recent article in each category is selected.
For More Information Dozens more answers to tough SQL questions from Rudy Limeback. The Best SQL Web Links: tips, tutorials, scripts, and more. Have an SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today! Ask your technical SQL questions -- or help out your peers by... More... Mar 12, 2004
a self-dubbed Oracle newbie? Are you in the early stages of your Oracle research? Seeking some quick answers to your tough questions? Here's a list of beginning Oracle resources, including tutorials, expert technical advice and FAQs...
More...
Feb 19, 2004
Here you'll find downloads, sample code, tutorials, discussion forums, news and more about working with XML on Oracle...
More...
Feb 12, 2004
those archived redo logs if you want.
For More Information Dozens more answers to tough Oracle questions from Brian Peasland are available. The Best Oracle Web Links: tips, tutorials, scripts, and more. Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today! Ask your technical Oracle and SQL questions -- or... More... Aug 18, 2003
01/network.920/a96580/mts.htm#453787
For More Information Dozens more answers to tough Oracle questions from Brian Peasland are available. The Best Oracle Web Links: tips, tutorials, scripts, and more. Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today! Ask your technical Oracle and SQL questions -- or... More... Aug 12, 2003
products on Linux. They also announced the Oracle Open Source Development Center. The center will be part of the Oracle Technology Network and will feature sample Linux code, tutorials and technologies...
More...
Aug 7, 2003
figures by 12 for one year's worth of
data.
For More Information Dozens more answers to tough Oracle questions from Brian Peasland are available. The Best Oracle Web Links: tips, tutorials, scripts, and more. Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today! Ask your technical Oracle and SQL questions -- or... More... Jul 28, 2003
of TSPITR in recent Oracle releases.
For More Information Dozens more answers to tough Oracle questions from Brian Peasland are available. The Best Oracle Web Links: tips, tutorials, scripts, and more. Have an Oracle or SQL tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today! Ask your technical Oracle and SQL questions -- or... More... Jul 21, 2003
waiting to answer your toughest questions.
Forums: Ask your technical Oracle questions--or help out your peers by answering them--in our active forums.
Best Web Links: Oracle tips, tutorials, and scripts from around the Web. This tip includes various scripts to perform hot backups of an Oracle database under the Unix environment...
More...
Jun 25, 2003
Search or browse the Oracle Collaboration Suite master index. This site also includes links to tutorials, user guides and a glossary to help you get your collaboration system up and running...
More...
Jun 23, 2003
waiting to answer your toughest questions.
Forums: Ask your technical Oracle questions--or help out your peers by answering them--in our active forums.
Best Web Links: Oracle tips, tutorials, and scripts from around the Web. These are definitive cold backup and recovery scripts for Oracle running under Sun Solaris, HP-UX and AIX...
More...
Jun 19, 2003
Tutorials, tips, webcasts, documentation and much more, straight from the source...
More...
Jun 18, 2003
|
Oracle Content
Oracle Solutions
|