Interested to Buy Any Domain ? << Click Here >> for more details...
i have a table with the columns below as
Emp_ID Address_ID Address_Line City Country
-------- --------- ----------- ------ ---------
Q: Display the Emp_ID's those having more than one
Address_ID
- 7 Answers
- 8541 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / abc
select emp_id from table_name a where a.rowid < (select MAX
(rowid) from test b where b.address_id=a.address_id)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is tns service name?
How do I manually create a database in oracle?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is a nested table?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
How to write text literals in oracle?
Explain the function of optimizer in oracle?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
Can we store pictures in the database and if so, how it can be done?
How to call a stored function in oracle?
What is the usage of merge statement?
How to define an external table with a text file?
What are the ways tablespaces can be managed and how do they differ?
What is analyze command used for?
