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

Complete IT Professional - Mon, 2017-02-06 05:00
Oracle has several character data types that are commonly used and can also be confusing if you don’t know the differences between them. Learn what they are and the differences between them in this article. The Oracle character data types that are used most often are CHAR and VARCHAR2. There is also a VARCHAR data […]
Categories: Development

Weekly Link Roundup – Feb 3, 2017

Complete IT Professional - Fri, 2017-02-03 13:31
Here’s a collection of articles I’ve read over the last week that I found interesting. A shorter list than usual, but still some quality articles! Articles I’ve Read Oracle’s Cloud Licensing Change : Be Warned! Tim Hall from Oracle-Base shared with the community that Oracle’s cloud licensing costs have doubled due to the way […]
Categories: Development

ORA-01722 invalid number Solution

Complete IT Professional - Fri, 2017-02-03 05:00
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. ORA-01722 Cause So, you’ve run an SQL query (which can be SELECT, INSERT, UPDATE, for example), and you’ve gotten this error: ORA-01722: invalid number The reason for this error is that Oracle […]
Categories: Development

Managing Oracle Database Code with SQL Developer, Git, and Developer Cloud Service

Shay Shmeltzer - Thu, 2017-02-02 17:55

Are you coding SQL and PL/SQL code? Need to manage versions & branches? Want to track your to-do tasks? Need to conduct code reviews and peer programming? 

Developer Cloud Service can help you!

And now it comes free with your Oracle Database Cloud Service trial or license - check your service dashboard to see if you got one.  Note that even if your database is not in the cloud, but rather on-premises, you can use the same process shown in the video below.

In the demo you'll learn how to:

  • Provision a new cloud project for your team
  • Check SQL scripts into the Git Repository in DevCS
  • Track tasks and to-do items
  • Branch your SQL script code
  • Conduct code review with members of your team
  • Merge branches of code

Check it out:

I blogged about this topic in the past using JDeveloper, but figured out that most of the Oracle database developers actually use SQL Developer - so I thought it would be good to give them a quick 10 minute demo of what they can do by combining the power of SQL Developer and Developer Cloud Service. (The video can also be useful to just get a basic understanding of how SQLDeveloper works with any Git repo).  

More about Developer Cloud Service here.

Stay tune for more blog entries on features for Database developers in Oracle Developer Cloud Service - coming soon!

Categories: Development

ORA-01017 invalid username/password; logon denied Solution

Complete IT Professional - Wed, 2017-02-01 05:00
Have you gotten an ORA-01017 error in your Oracle database? Learn what caused it and how you can resolve it in this article. ORA-01017 Cause So you’re trying to connect to a database, or run a query across a database link, and you get this message: ORA-01017: invalid username/password; logon denied There are a few […]
Categories: Development

Oracle SQL List Tables in Database or Schema

Complete IT Professional - Mon, 2017-01-30 05:00
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. Oracle SQL List Tables If you’ve forgotten the name of a specific table, or forgotten how to spell a table (was it plural or singular? One word […]
Categories: Development

ORA-00942 table or view does not exist Solution

Complete IT Professional - Fri, 2017-01-27 05:00
Have you gotten an ORA-00942 error? I’ll explain the cause and the solution of the error in this article. ORA-00942 Cause The error message appears when you try to run an SQL statement: ORA-00942: table or view does not exist This happens for one of many reasons: The statement references a table or view that […]
Categories: Development

Weekly Link Roundup – Jan 27, 2017

Complete IT Professional - Thu, 2017-01-26 17:57
This week I’ve read a few interesting articles on Oracle and I thought I’d share them here. RI (Referential Integrity) Constraints: 3 Reasons to Include Them in Your Data Warehouse Kent Graziano from The Data Warrior (and Snowflake) wrote an interesting article on using referential integrity constraints inside a data warehouse. I haven’t really considered […]
Categories: Development

ORA-00904 invalid identifier Solution

Complete IT Professional - Wed, 2017-01-25 05:00
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. ORA-00904 Cause So, you ran an SQL statement and you got this error: ORA-00904: invalid identifier What causes this error? It’s caused by referring to a column that does not exist, or […]
Categories: Development

Version Control for PL/SQL

Gerger Consulting - Tue, 2017-01-24 12:14
Let's get this straight:

  • It is possible to put PL/SQL in proper version control. 
  • It is possible to have developers work on the same logical code unit (package, procedure, function etc...) at the same time without co-ordinating first. 
  • It is possible to merge these changes at a later time automatically. 
  • It is possible to eliminate all the errors resulting from manual preparation of deployment scripts. 
  • It is possible to build an automated continuous delivery pipeline for PL/SQL.

If you'd like to know how, attend our free webinar. Register at this link.

Categories: Development

ZDLRA Database Patch Rollback fails with : Re-link fails on target "ioracle"

Arun Bavera - Mon, 2017-01-23 09:19
I was helping my colleague to apply DB patch for ZDLRA metadata repository

It required some conflicting duplicate patch to be rolled back but the roll back failed in between during make operation.
RollbackSession rolling back interim patch '20788771' from OH '/u01/app/oracle/product/'
 Patching component oracle.rdbms.deconfig,
 Patching component oracle.ldap.rsf,
 Patching component oracle.rdbms.rsf,
 Patching component oracle.rdbms,
 Patching component oracle.rdbms.dbscripts,…

RollbackSession removing interim patch '20788771' from inventory
Make failed to invoke "/usr/bin/make -f ioracle ORACLE_HOME=/u01/app/oracle/product/"....'/u01/app/oracle/product/ In function `krsp_avm_shutdown':
krsp.c:(.text+0x8aca): undefined reference to `krr_find_log_end1'
/u01/app/oracle/product/ undefined reference to `krrUt1'
/u01/app/oracle/product/ In function `kbrssvReadFChunk':
kbrssv.c:(.text+0x1b812): undefined reference to `kbrs_resilver'
collect2: ld returned 1 exit status
make: *** [/u01/app/oracle/product/] Error 1

The following make actions have failed :
 Re-link fails on target "ioracle".
We were able to find these missing object libraries in $ORACLE_HOME/.patch_storage using the find and nm commands:

Cd $ORACLE_HOME/.patch_storage
find . -name "*.o" -exec nm {} \; | grep krrUt1
Used the "ar"  command to updated the library /u01/app/oracle/product/  with the missing library object files and then ran the make command manually to overcome this problem..

ar r /u01/app/oracle/product/  krsp.o  ksdxt.o  kbrssv.o
$ cd $ORACLE_HOME/rdbms/lib
$ make -f ioracle

Also, we had to follow the solution in Note: 2131772.1for making ora.gipcd to up and running

In case if you are using opatch to rollback patch in GRID Home you may have to unlock CRS home for applying patch, follow the note:2136437.1
1. Shutdown cleanly if the clusterware is running in the failed node:
# crsctl stop crs -f
If the above fails because of partially run postpatch and not able to bring down ohasd:
# crsctl disable crs
Ensure all clusterware related process are down and nothing is running from the crs home:
# kill -9
Enable clusterware again:
# crsctl enable crs
2. Unlock the CRS home
# -unlock
3. Issue -patch to instantiate and lock the home

# -patch
Categories: Development

Oracle Triggers – The Complete Guide

Complete IT Professional - Mon, 2017-01-23 05:00
Oracle triggers are a handy but often misused function of the Oracle database. Learn all about them in this article. Table of Contents This is a long article, so here’s a table of contents you can use to navigate around the page: What are Oracle Triggers? Types of Triggers in Oracle Reasons to Use Oracle […]
Categories: Development

Oracle VAR_POP Function with Examples

Complete IT Professional - Fri, 2017-01-20 05:00
This article will explain the Oracle VAR_POP function and show you some examples. Purpose of the Oracle VAR_POP Function The VAR_POP function finds the population variance of a set of numbers, excluding NULLs. What does this mean? The population variance is a calculation that determines the difference or variation in a complete set of numbers. […]
Categories: Development

Weekly Link Roundup – Jan 20, 2017

Complete IT Professional - Thu, 2017-01-19 18:02
Here’s my weekly link roundup for Jan 20, 2017. What Is This Link Roundup? A “link roundup” is a type of post on a website where the author collates a list of articles they have read recently, and adds them all into a single post. The aim is to make the readers of the site […]
Categories: Development

Oracle VAR_SAMP Function with Examples

Complete IT Professional - Thu, 2017-01-19 05:00
In this article, I’ll explain the Oracle VAR_SAMP function and show you some examples. Purpose of the Oracle VAR_SAMP Function The VAR_POP function will return the sample variance of a set of numbers, after excluding NULLs. What does this mean? The sample variation calculates the variation of a sample of numbers from the overall set. […]
Categories: Development

Extending Oracle HCM with Oracle Application Builder Cloud Service - It's Simple

Shay Shmeltzer - Wed, 2017-01-18 13:37

I blogged before showing how easy it is to extend Oracle Sales Cloud using Oracle Application Builder Cloud Service.

We do get a lot of customers of Oracle HCM that approach us asking if they can use the same tools to extend Oracle HCM apps. While Oracle Application Builder Cloud Service (ABCS) has the list of Oracle Sales Cloud services pre-populated in the service catalog , you can pretty easily connect ABCS to Oracle HCM services too and get data and build an application around this data.

In the video demo below I'm building an application that records the details of the cars employees are allowed to bring onto campus. I leverage a REST service exposed by Oracle HCM to get the list of employees. ABCS also automates querying using the same service so you can search for a specific employee.

ABCS lets me create an app with the same look and feel as Oracle SaaS displaying the specific fields that interest me in the specific layout I want. Further more I can add custom data object that tracks the details of the cars and associate it with the HCM data.


Note that in the security section I'm using basic security with a fixed user for the sake of simplicity in the demo. Note however that in the selection list I can also use the currently logged in Oracle Cloud user - to synch the user of my ABCS and their HCM authorization.

HCM Security Setting

Check it out:

Want to try it on your own - get a trial account of Oracle Application Builder Cloud Service here

Categories: Development

Demo: Version Control for PL/SQL in 30 Minutes

Gerger Consulting - Mon, 2017-01-16 12:38
Hi Everyone! We prepared a 30 minute demo video to show you how Gitora can help you manage your PL/SQL code base. Check it out below:

Categories: Development

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

Complete IT Professional - Mon, 2017-01-16 05:00
Have you seen ROWNUM and ROW_NUMBER in Oracle and wondered what the difference is? Learn what they are and the differences between Oracle ROWNUM vs Oracle ROW_NUMBER in this article. What Is Oracle ROWNUM? You might think that ROWNUM is a function in Oracle. However, it’s not a function. It’s a “pseudocolumn”. It acts like […]
Categories: Development

APEX 5.1 New Features

Denes Kubicek - Mon, 2017-01-16 01:57
APEX 5.1 ist endlich da. Oracle Application Express wird mit jedem Release besser und zieht immer mehr Entwickler weltweit in seinen Bann. Es ist einfach, einfache wie auch komplexe Applikationen auf Basis des Oracle Stacks zu entwickeln. Es macht sogar richtig Spaß !

Mit APEX 5.1 sind als wichtiges neues Feature die Interactive Grids mit dazu gekommen. Wir haben sehr lange auf eine moderne Möglichkeit gewartet, Excel - ähnliche Funktionen auf einer Webseite mit APEX zu implementieren. Jetzt ist es endlich soweit :) . Sogar Master-Detail-Detail-Detail-... Beziehungen sind umsetzbar, unsere Anwender werden sich freuen.

Darüber hinaus gibt es auch in vielen anderen Bereichen wichtige Neuerungen, die uns das Leben erleichtern. Gleichzeitig sind aber auch einige wichtige Dinge zu beachten, damit wir ein reibungsloses Upgrade durchführen können.

In diesem Kurs lernen Sie die neuen Funktionalitäten von Oracle Application Express 5.1 kennen, insbesondere wie Sie diese erfolgreich in der Praxis einsetzen.

Lernen Sie von und diskutieren Sie mit den weltweit bekannten Oracle APEX Experten:

Denes Kubicek, langjährige Projekterfahrung in den Bereichen Oracle und APEX mit multisite Applikationen, Preisträger des "Oracle APEX Developer of the Year 2008" Awards des Oracle Magazines, ein Oracle ACE Director und sehr bekannt im Oracle APEX OTN Forum für seine Beispielapplikation und

Dietmar Aust, erfahrener Oracle Consultant mit Spezialisierung auf Oracle APEX, Oracle ACE und aktiv in den OTN Foren zu APEX und Oracle XE, mit regelmäßigen Präsentationen auf den einschlägigen Oracle Konferenzen (DOAG, ODTUG, Oracle Open World).

Categories: Development

Announcing “Database Star Academy”

Complete IT Professional - Fri, 2017-01-13 20:03
All of the online courses I have created used to be on a separate site of mine called Software Developer Academy. These have now all been moved to a new section under my main site, called Database Star Academy. Read on to find out more. What Is Database Star Academy? It’s the name of a membership section on […]
Categories: Development


Subscribe to Oracle FAQ aggregator - Development