plsql - Using a cursor in a stored procedure -


i want find min, max , average each quarter using stored procedure , cursors. can't figure out going wrong.

set serveroutput on  create or replace procedure seven2     cursor c1        select           qtrcode qtr,           cast(min(salaryoffered) decimal(4,2)) min,            cast(max(salaryoffered) decimal(4,2)) max,           cast(avg(salaryoffered) decimal(4,2)) avg                 interview       group           qtrcode       order           qtrcode  begin     qtrcode in c1    loop         dbms_output.put_line(min || ' ' ||max|| ' ' ||avg);    end loop; end; /

can add padding functions above query , if how?

i have created interview table 2 columns example purpose , inserted dummy data, see changes in procedure, works fine now

sql> sql> desc interview  name                                                                     null?    type  ------------------------------------------------------------------------ -------- -------------------------------  salaryoffered                                                                     number(10,2)  qtrcode                                                                           varchar2(4)  sql>     sql> create or replace procedure seven2   2    3     cursor c1   4        select   5           qtrcode qtr,   6           cast(min(salaryoffered) decimal(10,4)) min,   7           cast(max(salaryoffered) decimal(10,4)) max,   8           cast(avg(salaryoffered) decimal(10,4)) avg   9         10           interview  11        group  12           qtrcode  13        order  14           qtrcode ;  15  16  begin  17     qtrcode in c1  18     loop  19             dbms_output.put_line('the qtr ' || qtrcode.qtr ||' min sal '|| qtrcode.min || ' max sal ' || qtrcode.max|| ' avg sal is' ||qtrcode.avg);  20     end loop;  21  end;  22  /  procedure created.    sql> exec seven2; qtr q1 min sal 137.07 max sal 964.66 avg sal 580.8748 qtr q2 min sal 127.79 max sal 938.49 avg sal 550.52 qtr q3 min sal 231.1 max sal 992.45 avg sal 672.59 qtr q4 min sal 103.19 max sal 960.13 avg sal 431.318  pl/sql procedure completed.  sql>

Comments

Post a Comment

Popular posts from this blog

shopping cart - Page redirect not working PHP -

im trying redirect user when click "empty cart". redirect working "add cart" not "empty cart". ideas great. in main .php file set current url seen $current_url = base64_encode("http://$_server[http_host]$_server[request_uri]"); then below cartaction.php file handles actions such "add cart" , "empty cart" <?php session_start(); include_once 'config.php'; //add item in shopping cart if(isset($_post["add"])) { $product_id = $_post["product_id"]; //product id $return_url = base64_decode($_post["return_url"]); //return url $qty = $_post["qty"]; $product = $mysqli->query("select product_name, unit_price, unit_quantity products product_id = '$product_id'"); $obj = $product->fetch_object(); if(!isset($_session['products'])) { $_session['products'] = array(); } if(array_key_exists($product_id...
Read more

php - How to modify a menu to show sub-menus -

i have custom php menu made person, displays categories menu. however, need display subcategories well. tried adding hierarchical parameter didn't work. hoping assistance! here code: <ul> <?php /* categories wp e-commerce products */ $wpec_product_categories = get_terms( 'wpsc_product_category', 'hide_empty=0&parent=0&exclude=298'); $myarray = array(); foreach($wpec_product_categories $wpec_categories){ $myarray[$wpec_categories->term_id]['name'] = $wpec_categories->name; $myarray[$wpec_categories->term_id]['slug'] = $wpec_categories->slug; $myarray[$wpec_categories->term_id]['term_id'] = $wpec_categories->term_id; } foreach($myarray $wpec_categories1){ $wpec_term_name = $wpec_categories1['name']; $wpec_term_slug = $wpec_categories1['slug']; $wpec_term_id = $wpec_categories1['term_id']; echo '<li> <a href="'.get_page_link(19)....
Read more

python - Installing PyDev in eclipse is failed -

unable read repository @ http://pydev.sf.net/updates/content.xml. sun.security.validator.validatorexception: pkix path building failed: sun.security.provider.certpath.suncertpathbuilderexception: unable find valid certification path requested target i installing pydev in eclipse using python, doesn't install successfully. gives above error. happened? how solve error? i had error when trying install on laptop behind corporate firewall. couldn't tell setup of firewall, not sure of root cause. i got passed error installing pydev eclipse when out behind firewall. another way got around have eclipse on non-firewalled machine, install pydev eclipse, , copy whole eclipse directory non-firewalled machine firewalled machine. there better way, , way fix properly, didn't have time work out firewall doing. this on windows 7 machine (yeah know) not work *nix versions installed through package manager yum or apt.
Read more