mir77

HI, You can find your tables last/or first row by creating a query of in line view as: [code=sql]select b.emp_id,b.last_name,b.first_name from (select rownum,emp_id,last_name,first_name from employee order by emp_id desc) b where rownum=1;[/code] OR if you wanna to select the last row of a table by inserting time then write as …

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

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???.

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?

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

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

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

[code=sql]select count(deptno), dname from dept group by dname having count(deptno)>1[/code]