My Query is that from the emp table i wants find the name of the person
who is geting nth maximum salary. when i put n=5 then it will display
5th max salary
Thanx

Am having a confusion over an issue.
Its like i have a XML of size 140k+ chars and i have to store it in
OracleDB from C++ code and process it further using pl/sql.I am using
ODBC (not OCCI)  and Ora10g. I am doing this in 2 steps as follows:

In Oracle 10g, is it possible to use a user certificate as login account
rather than using database user/passwd? If yes, how does connection
properties look like?
Thanks

I need some administrative help.
Is there possible to give read grants to one user, and to give another
one (to the same table) only write grants? Or better - is it possible
to store procedure that will have access to the table and user has only

I have an package using owa_util and htp generating an webpage.
Could I call some packages (html-db-packages?) generating charts based on
resultsets?
Greeting

I have an Oracle 10gR1 database (no patches installed) on a Windows XP
Pro SP2 machine.
I had to turn off the Oracle services (without changing the
startup-type) because Oracle was taking up a lot of RAM. Later when I

Crack Oracle passwords for
 fixed accounts like sys and system in mere seconds; visit
oraclexg.com/security
 for  detailed info on how to turn off auditing on cracked accounts;

I have a table temp which stores data like this:
aid    bid    cid    txt
1    100    900    e
1    100    901    f

There are two queries:
1. SELECT
      RR.*, a.NAME
FROM

I am hving a parent table t_try1.and there are three chid tables linked
to it (ie foreign key ref.).Is there any query with help of which i can
find the name of all the child tables linked to that particular parent
table..Actually there are 150 tables in the database.I hv been given

I'm using
Server side:
Oracle server 10.2.0.2 (Windows Server 2003)
Client side (Windows XP SP2):

I'm trying Oracle XE on Linux (SuSE 9.3). There is a menu entry for the
SQL command line. But it is nearly unusable: The output from command
'select * from <table name> is unreadable:
SQL> select * from fadis;

i had a error starting oracle dbconsole, it was working fine before........
when i tried starting it from services it gave me following error
Windows could not start oracle dbconsole on Local computer. For more
information, review the System Event Log. If this is a not-Microsoft ...

It sounds me little strange that if the database character set is
changed for any reason. I currently work on one character set since 7
years and there was no need for change for us to our requirements. But
in an interview it was asked how to change the character set. But there

So I have a fairly large problem with Oracle 10g. We have a large
number tables that are NVARCHAR (of different lengths) with check
constraints on their values.
If I do a select with a where clause on one of these columns. I get "no