How to Recompile Invalid Schema Objects
When we are doing the operations like upgrades, patches, and DDL changes the associated schema objects will get invalid. So it is difficult to recompile all the user objects one…
Read MoreOracle Analytical Functions
The easiest way to understand analytic functions is to start by looking at aggregate functions. An aggregate function aggregates data from several rows into a single result row. The aggregate…
Read MoreExporting User Objects Using SQL developer
There will be scenarios like the developer wants to export the DDL/Data of user objects like Table, View, Packages, Functions, Procedures, Trigger, etc. Using SQL developer you can export all…
Read MoreInstalling Oracle 18c XE on Windows
This blog talks about How to Install Oracle Database 18c XE on Windows OS and Connect the database using SQL Plus and SQL Developer. It will help the developer to…
Read MoreConverting rows to columns using Oracle Pivot clause
The Oracle introduced the PIVOT clause from oracle 11g. This makes converting rows to column easy. The value in the new columns must be the result of an aggregate function…
Read MoreApex Login Using Facebook (Social Sign In)
Assume that there is a requirement to set up a public login to an apex application using Facebook and Google. Using the Social Sign-In feature user can log in to…
Read MoreShow/Hide Password Using JS
Assume that there is a requirement for a login page, the password you want to make hide and show when the user clicks a button or icon. You can achieve…
Read MoreApex Login using Google – Social Sign In
The Apex is now allowing the user to login with a Google account. This Social Sign-In feature is introduced in Apex 18.1 version. Using the social Sign-In feature user can…
Read MoreMinimum length check for a field using JS
Assume that there is a requirement to set a minimum length for a field and we need to convey the error to the user by changing the border color. It…
Read MorePipelined Function for String to table-2
When we are working with the ‘Multi Select’ field , we will face difficulty to process each separated values. Here you can split a colon-separated string into rows using an…
Read More