I joined Twitter after I joined Facebook. When I first joined Twitter I thought it would be a good idea to have my tweets post as a status on Facebook. That decision was quickly reversed when I began to realize I was using the two applications for two different purposes and also had two (almost) …
Facebook Twitter App Posts to Profile Without Permission Read More »
Problem:When I attempted to import an MS Excel spreadsheet into MS Project, I was able to map each sheet to fields within MS Project; however, when I hit finished, I was getting an error “Operation Failed!” without any additional information. Resolution:After a quick Google, I found out that I needed to upgrade MS Project from …
MS Project won’t import MS Excel: Operation Failed Read More »
This is a continuation of my notes as I study for the Oracle Certified Associate crediential: Data Manipulation Language (DML) 5 DML commands: SELECT, INSERT, UPDATE, DELETE, MERGE May INSERT into 1 row using VALUES; May INSERT into multiple rows using SELECT May INSERT into multiple tables at a time. As an example: INSERT ALL …
This is a continuation of my notes as I study for the Oracle Certified Associate credential: Subqueries: Overview Subqueries can be included within SELECT, FROM, WHERE, GROUP BY and HAVING clauses. The WHERE clause may only contain 255 levels of subqueries; whereas, an unlimited depth may be used within the FROM clause. Example of subquery …
This is a continuation of my notes as I study for the Oracle Certified Associate credential: Grouping Functions COUNT(*) is the same as COUNT(ALL column) Group functions ignore NULL values unless otherwise handled with NVL functions; As an example, this concept is important when using AVG() Statistical group functions include VARIANCE() and STDDEV() Group functions …
Here is a continuation of my notes as I study for the Oracle Certified Associate credential: Character Conversion Functions NVL2(value, if_not_null, if_null): Watch out that the 2nd parameter after the compared value is if_NOT_null NULLIF(if_not_equal, compare_value): IF compare_value equals if_not_equal THEN return null; ELSE return if_not_equal; COALESCE(if_not_null_1, if_not_null_2, … if_not_null_n): Like using nested NVL() statements. …
A continuation of my notes as I study for the Oracle Certified Associate credential. In this post, I’ve simply referenced available Oracle Functions and associated examples. For a more appropriate description, please view the Oracle Documentation Library. Function:ROUND(number, precision) select round(1631.7344,−3) from dual is 2000. select round(1331.7344,−3) from dual is 1000. select round(1631.7344,−4) from dual …
Back in July ’08, as I was trying to figure out how best to sync my newly purchased iPhone 3G with Gmail and MS Outlook, I scoured the Apple Discussion Forums. I constantly came across posts recommending nuevasync. After checking out nuevasync’s short and to-the-point site, I contacted TechCrunch. Nuevasync seemed to show as much …
A continuation of my notes as I study for the Oracle Certified Associate credential: Comparison Operators For character and date comparisons, each side of the comparison operator is converted into its numeric representation, and then compared. The numeric value is based on the database characterset. != and <> are equivalent inequality operators LIKE command has …
This is a continuation of my notes as I prepare for the Oracle Certified Associate credential: SQL SELECT projection – the ability to limit the columns returned within a result set selection – the ability to limit the number of rows (or tuples) returned within a result set joining – the ability to match against …