April 2012 Blog Posts (9)

Attend COLLABORATE12 Virtually for half the price - Don't miss the action - Register NOW!

collab12logo

Only $99

Special Registration Code : COLLAB12

Registration URL:

http://events.ioug.org/e/in/eid=28

Sign Up,…

Continue

Added by Tariq Farooq on April 22, 2012 at 11:24pm — No Comments

Learn what Business Intelligence is - A new book on Oracle Business Intelligence (OBIEE)

Book Title: Implement Oracle Business Intelligence (Volume 1)

Analyze the Past – Streamline the Present – Control the Future



In today's fast paced technology-driven world, successful businesses depend heavily on driving intelligent decisions based on latest information. More informed decisions mean more revenue, less risk, decreased cost, and improved operational control.…

Continue

Added by Riaz Ahmed on April 11, 2012 at 10:09pm — No Comments

Hands-On Tutorial Book on Oracle Application Express for Novices

Book Title: Create Rapid Web Applications Using Oracle Application Express (APEX)



A practical guide for novice and intermediate users to rapidly develop professional web applications.



In this fast paced technological age, where things change rapidly, no one has the time to go through lengthy concept books just to assess what the technology has for them. As an IT professional, I too prefer concise practical…

Continue

Added by Riaz Ahmed on April 11, 2012 at 10:00pm — No Comments

SQL CHECK Constraint on CREATE TABLE

To allow naming of a CHECK constraint, and for defining a CHECK constraint on multiple columns, use the following SQL syntax:

MySQL / SQL Server / Oracle / MS Access:

CREATE TABLE Persons

(P_Id int NOT NULL,

LastName varchar(255) NOT NULL,

FirstName varchar(255),

Address varchar(255),

City varchar(255),

CONSTRAINT chk_Person CHECK (P_Id>0 AND…

Continue

Added by Caesar Oladipo Komolafe on April 9, 2012 at 10:00am — No Comments

Don't let #COLLABORATE12 slip away - Register NOW with special Virtualization SIG Registration Code: http://bit.ly/HcTGOM

Don’t let COLLABORATE12 slip away – Register NOW!…



Continue

Added by Tariq Farooq on April 3, 2012 at 5:20pm — No Comments

SQL SELECT TOP Equivalent in MySQL and Oracle

SQL SELECT TOP Equivalent in MySQL and Oracle

MySQL Syntax

SELECT column_name(s)

FROM table_name

LIMIT number

Example

SELECT *

FROM Persons

LIMIT 5

Oracle Syntax

SELECT…

Continue

Added by Caesar Oladipo Komolafe on April 3, 2012 at 3:03pm — No Comments

Combining AND & OR

Combining AND & OR

You can also combine AND and OR (use parenthesis to form complex expressions).

Now we want to select only the persons with the last name equal to "Svendson" AND the first name equal to "Tove" OR to "Ola":

We use the following SELECT statement:

SELECT * FROM Persons WHERE
LastName='Svendson'
AND (FirstName='Tove' OR FirstName='Ola')

Added by Caesar Oladipo Komolafe on April 3, 2012 at 3:00pm — No Comments

Monthly Archives

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

Oracle Community On

I'm not a fan of advertising, and so I will not be including any advertisements on OracleCommunity.net. However, managing this community does not come without cost! If you are willing to donate to help pay for the monthly community fees and domain services I accept Bitcoin and PayPal donations.

Donate Bitcoins

Badge

Loading…

Blog Posts

Do What You Do Best and Outsource the Rest

One of the most valuable assets of an organization, data lies at the heart of business. It impacts everything from customer service to email deliverability and ultimately revenue generation. If the data that you have is not accurate, it will have a direct impact on your company’s ability to meet…

Continue

Posted by Alvaro Dee on February 7, 2017 at 2:07am

Draw Actionable Insights and Make Better Decisions with Data Mining Services

Data Mining is the process of analyzing and extracting crucial information from a database and presenting the same in an appropriate way to help business cut cost and boost revenue. In simple words it is the process of drawing crucial and actionable insights, which is imperative for better decision making.

Data mining is crucial for effective management of your business. It is also used for verifying whether or not the strategies are going as planned so as to provide desired results.…

Continue

Posted by Alvaro Dee on February 1, 2017 at 4:02am

Attain Data Accuracy, Competitive Pricing, and Quick Turnaround Time by Outsourcing Data Entry Services

In order to focus on crucial business activities, organizations worldwide prefer outsourcing data entry services to reliable service providers. Though redundant but highly crucial, data entry still remains an important component of document management and requires vigorous quality checks. Outsourcing data entry tasks to experts ensures affordable and quality output while saving time and resources that can be…

Continue

Posted by Alvaro Dee on January 31, 2017 at 4:49am

Present and Exchange Documents Reliably With Portable Document Format

Are you having data in large volumes that needs to be converted from hard copy to PDF format? Can you imagine how much time it would take you to manually convert this data? Well, if you know, then what’s the point of putting in lot of efforts and time?

With the help of PDF data entry services, this task can be made a lot easier. Data entry experts can help you save time and efforts…

Continue

Posted by Alvaro Dee on January 25, 2017 at 3:38am

© 2017   Created by Steve Karam.   Powered by

Badges  |  Report an Issue  |  Terms of Service