Dear friends,


Plz tell me , how can i detect the pc's ip address from oracle software dynamically?

Please write details about settings of "NLS"

Dear Programmers,

How can I dispaly and insert other language (Arabic/hindi/bangla/chinees etc) through form level field at run time window directly by keyboard???.

Use group by clause and use group_column>1 in the where condition

Mr. Safi,

This type of problem is not theoritical. It depends on user requirements. So go to your clients and get the information and try to understand their business rules. Ok?

http\\ip address of the pc:port_number(e.g, 8080)\isqlplus

select count(deptno), dname
from dept
group by dname
having count(deptno)>1

HI,
You can find your tables last/or first row by creating a query of in line view as:
select b.emp_id,b.last_name,b.first_name
from (select rownum,emp_id,last_name,first_name
from...

Morely delete command delete the data but not memory capture by row but truncate delete the rows and release the space captured by rows.

mir77