Hi
I need to join tables to get employee data records.
document.xml
is
------------------------------------------
<document name="company">
<table name="A">
<r>
<ssn>1000</ssn>
<name>Peter</name>
<age>45</age>
</r>
<r>
...
buzzw
Last Activity: Oct 27 '08, 04:26 AM
Joined: Jun 30 '07
Location:
-
fetching more than once in a loop
I am trying to find top n salaries from given table . My code returns top n salaries but if there are same value of salaries for more than 1 emp than program just picks one of them, I want to list all of them who has max salaries
How can I fetch twice inside a loop with the same cursor .
I am trying to fetch a cursor who finds max sal emp names , then I need to fetch it again to find all other emps who has same max sal .
thanks... -
top N without order by
Hi
How can I find top 3 earners from a table without using order by query with a cursor .
thanks -
writing text on new lines
Hi
I have a wraptext procedure which accepts input text and fits it within given output length .
Following is my test script
Accept line Prompt 'enter text : '
Accept len prompt 'enter length of output text '
/
DECLARE
loc_text VARCHAR2 (2000) := &line ;
text_out varchar2(1000);
loc_line_length INTEGER := &len;
loc_lines INTEGER;...
No activity results to display