IT career advice
228 views | +0 today
Follow
 
Rescooped by Complete IT Pro from Technology in Business Today
onto IT career advice
Scoop.it!

How Mobility is Transforming Cities into Smart Cities Worldwide

How Mobility is Transforming Cities into Smart Cities Worldwide | IT career advice | Scoop.it
Transforming Cities into Smart Cities Worldwide
How Cities around the World are taking advantage of Mobility
In the Internet of Everything (IoE), to change the way they interact with their inhabitan

Via TechinBiz
more...
No comment yet.
Your new post is loading...
Your new post is loading...
Scooped by Complete IT Pro
Scoop.it!

What Is a Self Join?

What Is a Self Join? | IT career advice | Scoop.it
A self join is a common solution to a specific table design in databases. Learn what a self join is and how to write queries against it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

The Complete Guide to Oracle Synonyms

The Complete Guide to Oracle Synonyms | IT career advice | Scoop.it
Want to know what an Oracle synonym is, how to create a synonym, how to find them, and more? Learn all about Oracle synonyms in this guide.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Oracle Timezone Functions Guide, FAQ, and Examples

Oracle Timezone Functions Guide, FAQ, and Examples | IT career advice | Scoop.it
There are a few timezone functions in Oracle SQL. Learn what they are, what they are used for, and see some examples in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

The Complete Guide to Oracle REGEXP Functions

The Complete Guide to Oracle REGEXP Functions | IT career advice | Scoop.it
Are you confused by Oracle regular expressions? Do you need to write regular expressions in SQL? Learn all about them in this comprehensive guide.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Ultimate List of 32 Oracle SQL IDEs Compared

Ultimate List of 32 Oracle SQL IDEs Compared | IT career advice | Scoop.it
Are you looking for the best Oracle SQL IDE? Wondering how the SQL editors compare? Read this guide on the 32 different Oracle SQL IDEs to find out.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-00936: missing expression Solution

ORA-00936: missing expression Solution | IT career advice | Scoop.it
Did you get an ORA-00936: missing expression error? Learn what the ORA-00936 error means and how to resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-00911 invalid character Solution

ORA-00911 invalid character Solution | IT career advice | Scoop.it
Are you getting an "ORA-00911 invalid character" error when running an SQL statement? Find out what causes it and how to resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Difference Between CHAR, VARCHAR, and VARCHAR2 Data Types in Oracle

Difference Between CHAR, VARCHAR, and VARCHAR2 Data Types in Oracle | IT career advice | Scoop.it
Oracle has the VARCHAR2, VARCHAR, and CHAR data types. I explain what they are and the differences between them in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-01017 invalid username/password; logon denied Solution

ORA-01017 invalid username/password; logon denied Solution | IT career advice | Scoop.it
Have you gotten an ORA-01017 error in your Oracle database? Learn what caused it and how you can resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-00942 table or view does not exist Solution

ORA-00942 table or view does not exist Solution | IT career advice | Scoop.it
Have you gotten an ORA-00942 error? I'll explain the possible causes and the solution of the ORA-00942 error in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

What’s The Difference Between Oracle ROWNUM vs Oracle ROW_NUMBER?

What’s The Difference Between Oracle ROWNUM vs Oracle ROW_NUMBER? | IT career advice | Scoop.it
Have you seen ROWNUM and ROW_NUMBER in Oracle? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Singular vs Plural and Other Database Table Naming Conventions

Singular vs Plural and Other Database Table Naming Conventions | IT career advice | Scoop.it
Should you name Oracle database tables in singular or plural form? Find out what the preferred convention is and other database table naming conventions.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

A Guide to the Oracle UPDATE Statement

A Guide to the Oracle UPDATE Statement | IT career advice | Scoop.it
Have you ever needed to update data that was already in a table in Oracle? Learn how to do this with the Oracle UPDATE Statement.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Oracle LOB Functions FAQ, Guide, and Examples

Oracle LOB Functions FAQ, Guide, and Examples | IT career advice | Scoop.it
In this article, we’ll look at the different Oracle LOB functions available, learn what each of them do, and see some SQL examples.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Oracle TRIM, LTRIM & RTRIM Function Guide, FAQ & Examples

Oracle TRIM, LTRIM & RTRIM Function Guide, FAQ & Examples | IT career advice | Scoop.it
The Oracle TRIM, LTRIM, and RTRIM functions are used to remove characters from the left or right of a string. Learn how to use them in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Oracle Date Functions: The Complete Guide

Oracle Date Functions: The Complete Guide | IT career advice | Scoop.it
There are many Oracle date functions and they all behave differently. Learn all about the date functions in Oracle SQL and see examples in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

A Step-By-Step Guide to Normalization in DBMS With Examples

A Step-By-Step Guide to Normalization in DBMS With Examples | IT career advice | Scoop.it
Normalization in DBMS can be a hard topic to understand. See step-by-step instructions about database normalization and an example in this article
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-00933 SQL command not properly ended Solution

ORA-00933 SQL command not properly ended Solution | IT career advice | Scoop.it
Are you getting the ORA-00933: SQL command not properly ended error? Learn what causes it and how to resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

UNION vs UNION ALL: What’s The Difference?

UNION vs UNION ALL: What’s The Difference? | IT career advice | Scoop.it
Are you unsure about the difference between UNION and UNION ALL? Learn what UNION and UNION all are and see their differences in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-06512 At Line Solution

Did you get an ORA-06512 error when running an SQL query? Learn what the ORA-06512 at line error is and how to resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-01722 invalid number Solution

ORA-01722 invalid number Solution | IT career advice | Scoop.it
Have you gotten an "ORA-01722 invalid number" error? I'll explain what this error is and how you can resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

Oracle SQL List Tables in Database or Schema - Database Star

Oracle SQL List Tables in Database or Schema - Database Star | IT career advice | Scoop.it
Do you need to list all tables in Oracle? There isn't an SQL list tables command, but you can learn how to do show all tables in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

ORA-00904 invalid identifier Solution

ORA-00904 invalid identifier Solution | IT career advice | Scoop.it
Did you get an "ORA-00904: invalid identifier" error? Find out what caused the ORA-00904 error and how to resolve it in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

What are the Differences Between a Primary Key vs Foreign Key?

What are the Differences Between a Primary Key vs Foreign Key? | IT career advice | Scoop.it
I explain what a primary key and foreign key is, as well as the differences between primary key vs foreign key in this article.
more...
No comment yet.
Scooped by Complete IT Pro
Scoop.it!

A Guide to the Oracle TRUNCATE TABLE Statement

A Guide to the Oracle TRUNCATE TABLE Statement | IT career advice | Scoop.it
The Oracle TRUNCATE TABLE statement is a useful statement for removing data in Oracle SQL. I'll explain what it does in this article.
more...
No comment yet.