In Oracle forms, you would have seen a multi-record block with a checkbox. When you click, Select all – when the master checkbox is checked… Read More »How to Select Multiple Records in Oracle Apps Forms ( Multi-Select Check Box Tutorial)
Oracle DBAs and Developers .. ever wondered the meaning of i, g and c in Oracle Database Releases version starting from 8 onwards? No.. right. Let… Read More »What is meaning of i, g and c in Oracle Database Version
Pre-Built Developer VMs (for Oracle VM VirtualBox) helps you to import pre-built and ready to use development virtual machines directly to Virtualbox. No need to… Read More »Pre-Built Developer VMs (for Oracle VM VirtualBox) – learn Oracle Database, Linux, SOA, APEX
Oracle Listagg function helps to concatenate multiple rows into a single string. This article explains this in details. Once a developer asked, “How to combine… Read More »Combine multiple rows into a single string in Oracle
PL/SQL is procedural language extension for SQL. It has it’s own commands, datatype, operator, etc. You can use SQL statements within PL/SQL code. Here, PL/SQL… Read More »How efficient is PL/SQL Bulk Processing? Does it really help…….
Generating Excel output from PL/SQL is a common requirement. But, there is no built-in function/API in Oracle Database which you can use to generate it.… Read More »3 Ways to generate Excel output using Oracle PL SQL
SQL Developer is a tool by Oracle to develop and manage Oracle Database. You can also connect to SQL Server, DB2, MySQL, Sybase, or any… Read More »How to Install SQL Developer on Windows 10
DBMS_UTILITY.GET_TIME is a function available in Oracle Database to get time in millisecond. You need to divide it by 100 to get time in seconds.… Read More »DBMS_UTILITY.GET_TIME in Oracle Database