Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Learn Oracle: Datatypes for SQL and PL/SQL, Boolean and Large Objects (LOB)
- Use the article index for more articles on this subject.BOOLEANABOOLEAN datatype is a native PL/SQL type that lets you signify a TRUEor FALSE condition. A BOOLEAN is NULL until explicitly assigned avalue. A BOOLEAN is assigned like other variables:DECLARE v_bool BOOLEAN; v_bool2 BOOLEAN := TRUE; ...
- Tags: subject.BOOLEANA BOOLEAN, Oracle Corp., PL/SQL, SQL
- Blog posts 2006-08-29
- Using a PL/SQL Table in SQL
- A friend of mine called a fewdays ago with a question. He wanted to populate a PL/SQL table and useit to compare to some other data via a NOT IN subquery. He was having aproblem getting the data into the nested table and wasn't sure how toaccess it from SQL...
- Tags: PL/SQL, PL/SQL Table, SQL
- Blog posts 2006-08-10
- Learn Oracle: Datatypes for SQL and PL/SQL, Dates
- Use the article index for more articles on this subject.Oracle10g provides three types of date related datatypes: date, timestampsand intervals. Today I will be talking about all three of these.DATETheDATE datatype is a datetime datatype. It stores a date and a time. Thedate portion is based on the number of...
- Tags: Oracle Corp., PL/SQL, SQL, these.DATEThe DATE
- Blog posts 2006-08-07
- Looking for a co-worker.
- I won't normally use this blogas a job board but I need some help and I would like to make sure I getsomeone good. And if you read this blog, you must be good! ;-)Are you a hard-core PL/SQL developer? Are you great with complex SQL? Do you...
- Tags: Bradenton, developer, PL/SQL, SQL, XML
- Blog posts 2006-08-04
- Learn Oracle: SQL and PL/SQL Datatypes, Strings
- There are several types of character data types for your use in SQL and PL/SQL. Unlike the NUMBER data type, there are some differences between SQL and PL/SQL character types.Iwon't cover LOB Large Objects in this article. It could be arguedthat a CLOB is nothing but a large string,...
- Tags: CLOB, Oracle Corp., PL/SQL, SQL
- Blog posts 2006-07-30
- Learn Oracle: Datatypes for SQL and PL/SQL, Numbers
- Datatypes are a subject thatconfuses many people. There are many types and many sub-types. A typeis a basic datatype like NUMBER. A sub-type is derived from a type. AnINTEGER is a sub-type of NUMBER. A sub-type usually add a constraint toa type and that creates the new sub-type; for INTEGER,...
- Tags: sub-type, Oracle Corp., PL/SQL, SQL
- Blog posts 2006-07-30
- Oracle SQL Developer: New Article on OTN
- I have a new article on OTN. Making the Most of SQL Developer Reports.The article walks through creating both very simple and somewhat complex reports. It also covers adding bind variables, customizing the bind dialog and creating drill down reports. SQL Developer has a lot of report...
- Tags: SQL, Oracle Corp.
- Blog posts 2006-07-12
- SQL Question: When the Pivot data contains a Key Column (and character data at that!)
- I recently wrote about pivoting (or is it unpivoting?) some data. A new wrinkle has been added.Let's say that the data now looks like this:INSERT INTO X ( FIELD1 ) VALUES ( 'row1,1,2'); INSERT INTO X ( FIELD1 ) VALUES ( 'row2,2,3'); INSERT INTO X ( FIELD1 ) VALUES...
- Tags: Field1, INSERT, SQL, VALUES
- Blog posts 2006-07-06
- SQL Question: Pivots, Analytics and the judicious use of Row_Number()
- A few days ago I answered a question from brat about converting 1 field into multiple rows. We solved that question but now we want to handle multiple rows in our source table.Just a note of warning. This article will really make a lot more sense if you...
- Tags: SQL
- Blog posts 2006-06-26
- Interesting SQL Question, Pivot 1 column into multiple rows
- This effort is an example of how I decompose a problem and some fun SQL tricks. Not tricks, I guess but maybe a creative use of SQL.A couple of days ago, a question was posted on one of the itToolbox.com email groups:From: BratSubject: [oracle-sql-l] COnverting one field into...
- Tags: multiple row, SQL
- Blog posts 2006-06-23
- Introduction to Basic SQL, Part 3 - Complex Joins and Sub-queries
- In my previous article, I covered SQL Joins with two tables. Today, I will cover joining tables with three or more tables and using sub-queries to join. I'll also throw in some details about the UNION clause and show other places a sub-query might be used.This post originally appeared on...
- Tags: SQL
- Blog posts 2006-06-08
- Introduction to Basic SQL, Part 2 - Joins
- In my last article, I introduced you to some basic SQL commands and some new concepts, mainly the data dictionary. Today we will get a little further into basic SQL by joining two tables in a single select statement. In the last article, I glossed over the difference between a...
- Tags: Programming languages, Databases, SQL
- Blog posts 2006-06-06
- Presenting XML and SQL Analytics
- The Suncoast Oracle User Group SOUG First Annual Tech Day is over. I had presentations on XML in Oracle and SQL Analytics in 10g. It was a great day and I think most people felt it was a truly worthwhile day. Attendance was good at about...
- Tags: IT WAS, SQL, SQL Analytics, XML
- Blog posts 2006-06-02
- What is the difference between Oracle, SQL and PL/SQL?
- Recently, Sudhat read my Introductionto Basic SQL and had this to say:The article is very interesting. Too Good!And also please describe what is the difference between SQL and Oracle and PL/SQL.Sudhat, thanks for the comments. Ilove to hear feedback.And your question is a common one so Ithought I would...
- Tags: Oracle Corp., PL/SQL, SQL
- Blog posts 2006-05-30
- New Version of Oracle SQL Developer (Raptor) Available
- Oracle SQL Developer, i.e. Raptor, Early Adopter Release 4.1 was posted on Feb 17. SQL Developer is the new Oracle SQL and PL/SQL GUI....This post originally appeared on an external website
- Tags: Oracle Corp., Oracle SQL, Raptor, SQL
- Blog posts 2006-02-18
- Introduction to Basic SQL, Part 1
- Discussion about basic SQL commands.This post originally appeared on an external website
- Tags: SQL
- Blog posts 2005-08-24
Additional Resources
- John Lewis Partnership Enhances Its 'Employer of Distinction' Reputation With HR and Payroll Solutions
- One of the U.K.'s top ten retail businesses with 27 John Lewis department stores and 174 Waitrose supermarkets, John Lewis Partnership offers unparalleled service and quality products to its customers. The company wanted to standardize, integrate, and centralize HR and payroll functions group-wide to align people management with business objectives...
- Tags: Human Resources, Payroll, John Lewis Partnership, Operational Accounting, Finance
- Case studies
- UK's Largest Retailer, John Lewis Partnership, Depends on MessageOne's AlertFind for Crisis Communication
- John Lewis is one of the UK's largest retail businesses with a network of shops stretching from Aberdeen in the North East of Scotland, to Bristol in the South West of England. With the adoption of its core Business Continuity Management BCM solution solidly in place, the John Lewis team...
- Tags: U.K., Business Continuity, MessageOne, Crisis Communication, John Lewis, Corporate Communications, Marketing
- Case studies
- Case Study: Improve Network Security, Cut Carbon Emissions
- The John Lewis Partnership was founded in London 143 years ago. The company, which operates John Lewis department stores and Waitrose supermarkets, had consolidated its diverse IT infrastructure over several years, which included installing Windows ServerŪ 2003. It wanted to take the next step to improve its network operations. In...
- Tags: Network, Microsoft Windows Server, Network Security, Remote Site, Microsoft Windows, Microsoft Windows Server 2008, Microsoft Windows Server 2003, Servers, Security, Networking, Operating Systems, Software, Hardware
- White papers 2008-06-04
- Retailer Expects to Improve Network Security and Cut Both Costs and Carbon Emissions
- The John Lewis Partnership was founded in London 143 years ago. The company, which operates John Lewis department stores and Waitrose supermarkets, had consolidated its diverse IT infrastructure over several years, which included installing Windows Server 2003. It wanted to take the next step to improve its network operations. In...
- Tags: Network, Microsoft Windows Server, Network Security, Microsoft Windows, Microsoft Windows Server 2008, Microsoft Windows Server 2003, Servers, Security, Networking, Operating Systems, Software, Hardware
- Case studies 2008-02-01
- << Previous
- page 1 of 1
- Next >>
