Try this ..
Select empno, ename, sal,
DECODE (ROWNUM,
1, ROWNUM || 'st Highest Salary',
2, ROWNUM || 'nd Highest Salary'
) remark
From...
Type: Posts; User: susarlasireesha; Keyword(s):
Try this ..
Select empno, ename, sal,
DECODE (ROWNUM,
1, ROWNUM || 'st Highest Salary',
2, ROWNUM || 'nd Highest Salary'
) remark
From...
If u Desire to blossam like a rose in the garden ,u must have to learn the art of adjusting with the thorns....
'Let's all be masters of our mouths, so that we won't be slaves of our words.'
Children are like a wet cement. Whatever falls on them makes an impression.
"happy children's day............"
"have a day of childhood memories !.."
If god answers your prayer,
he's increasing your faith.
If he delays,
he's increasing your patience.
If he doesn't answer,
he knows you can handle it....
The word L-I-S-T-E-N contains the same letters as S-I-L-E-N-T.
Listen to GOD in the silence of your heart and you will know
HIS perfect plans for you!
Learn to Say 'No' to the Good so you can Say 'Yes' to the Best
Every tomorrow has two handles. We can take hold of it by the handle of anxiety, or by the handle of faith.
Knowledge is of two kinds. We know a subject ourselves, or we know where we can find information upon it.
There are words and actions, of which words inspire and encourage, while action produces results.
I have a .sql file it contains creation scripts,procedures,packages
when ever an error occur in creation scripts /procdures/packages
i must show error message and come out of the execution of .sql...
Creation of linux user and Creation of Oracle directory
1. Connect as root user
For adding user to linux ,assigning dba group to username
2 useradd -d /home/username -m -g dba -s /bin/sh...
Flat file is data file that contain records with no structured relationships
u need to specify the path (i.e control=c:\example.ctl) or copy the file in bin
From command prompt run
sqlldr user/passwd control=example.ctl log=example.log data=example.dat
sqlldr is in bin folder in oracle 9i
sql loader is a bulk loader utility to moving data from external files to oracle database and is installed along with the oracle 9i software
follow this link
Words that enlighten are more precious than jewels
refer this link
follow this link
use this link
CBO has two available modes ALL_ROWS and FIRST_ROWS.
alter session set optimizer_goal=all_rows
The optimizer mode can be set at the system level/ session/SQL statement
alter system set...
u can find clear explanation here
A person who is worried about the outcome of his work does not see his goal; he sees only his opposition and the obstacles before him.
---- Mahatma Gandhi
To find the job is running use
SELECT r.sid, r.job, r.this_date, r.this_sec, SUBSTR(what,1,40) what
FROM dba_jobs_running r,dba_jobs j
WHERE r.job = j.job;
use below query to find the status of...