Oracle Apps DBA has to often trouble shoot various issues. I am giving here Top 30 Useful oracle apps queries for DBA To find forms session in Oracle database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column […]
How to give oracle kill own session privilege to Developers
Often developers ask how we can kill our own session as they dont want to wait for the DBA to respond and kill. They want the oracle kill own session privilege. We dont have any privilege like alter system kill session which can be given to the user. We can give alter system privilege but […]
Bg, Fg, CtrlZ Unix command : Unix Background Jobs
There are several commands which allow you to manage the processes that belong to you. Off course You cannot do anything with processes belonging to other users unless you are root user. Here is the detail on Bg, Fg, CtrlZ Unix command to Manage Unix Background Jobs with Examples Some definition What is foreground process When […]
how to create table in oracle
This article talks how to create table in Oracle,primary key ,Foreign keys,create table syntax in oracle with Examples. This will be very useful for Oracle DBA’ s and Developer both.They play with it many times in the day and an good knowledge can definitely help them expedite the task.They often get confused the datatype and […]
How to change date format in oracle database
We often need to change the date format while checking. Here are some ways which you can use to change date format in Oracle database Oracle Default Date Format The default date format in oracle is controlled by the value of the NLS_DATE_FORMAT parameter. The following query can be used to find the current value […]
Coalesce Function in Oracle
Coalesce Function is a useful function in oracle and it is very useful when we want to return first non null values in the list.This SQL tutorial provides explanations, examples for Coalesce Function in Oracle and Difference between Coalesce & NVL expr1 : This is returned if it is not nullexpr2: This is returned if […]
