Displaying table data through plsql procedure -


i trying display table info through plsql code when executes procedure show procedure successful. not output.please help.

create or replace procedure carinfo  v_serial                car.serial%type; v_cid                   car.cid%type; v_make                  car.make%type ; v_model                 car.model%type; v_cyear                 car.cyear%type; v_color                 car.color%type; v_trim                  car.trim%type; v_enginetype            car.enginetype%type; v_purchinv              car.purchinv%type; v_purchdate             car.purchdate%type; v_purchfrom             car.purchfrom%type; v_purchcost             car.purchcost%type; v_freightcost           car.freightcost%type; v_totalcost             car.totalcost%type; v_listprice             car.listprice%type;  begin  select  serial, cid, make, model, cyear, color, trim, enginetype, purchinv, purchdate, purchfrom , purchcost, freightcost,          totalcost, listprice      v_serial, v_cid, v_make, v_model, v_cyear, v_color, v_trim, v_enginetype, v_purchinv, v_purchdate, v_purchfrom , v_purchcost, v_freightcost,          v_totalcost, v_listprice      car     cid null;  exception  when no_data_found     dbms_output.put_line('no data found')  ;  dbms_output.put_line(v_serial||' ' || v_cid||' ' ||v_make||' ' ||v_model||' ' ||v_cyear||' ' ||v_color||' ' ||v_trim||' ' ||v_enginetype||' ' ||v_purchinv||' ' ||v_purchdate||' ' ||v_purchfrom ||' ' ||v_purchcost||' ' ||v_freightcost||' ' ||         v_totalcost||' ' ||v_listprice); end;

in brief, write procedure following way:

create or replace procedure carinfo l_result_clob clob;  begin    select serial   ||' ' || cid      ||' ' ||make      ||' ' ||model      ||' ' ||cyear||' ' ||          color    ||' ' ||trim      ||' ' ||enginetype||' ' ||purchinv   ||' ' ||          purchdate||' ' ||purchfrom ||' ' ||purchcost ||' ' ||freightcost||' ' ||totalcost||' ' ||listprice     l_result_clob      car    cid null;    dbms_output.put_line(l_result_clob);  exception  when no_data_found     dbms_output.put_line('no data found')  ;  when others     dbms_output.put_line('sqlcode: ' || sqlcode)  ;  end carinfo;

that of course, if columns in select statement convertible character/clob, oracle implicitly convert them, in order concatenation happen.

cheers


Comments

Post a Comment

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

python Tkinter Capturing keyboard events save as one single string -

is possible store keyboard events 1 string? code below stores 1 char , prints it. card reader or bar code reader, contains collection of character/ string not 1 character @ time. goal save char pressed text variable. from tkinter import * root = tk() def key(event): text= event.char text+= event.char print ("pressed", text) def callback(event): frame.focus_set() print ("clicked at", event.x, event.y) frame = frame(root, width=100, height=100) frame.bind("<key>", key) frame.bind("<button-1>", callback) frame.pack() root.mainloop() currently, creating text variable , everytime key() function gets called, , text stores last character typed. you can define text module level variable , , use module level text inside key function - text = '' def key(event): global text text+= event.char print("pressed", text)
Read more

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -

here tables: create table customer ( cid int primary key, name varchar(32) ) create table ord ( oid int primary key, cid int foreign key references customer, address varchar(20) ) here's linq-to-sql statement: var aaa = c in db.customer select new { c, o = c.ord.tolist() }; and here's inexplicable query generated linq-to-sql: select [t0].[cid] [cid], [t0].[name] [name], [t1].[oid] [oid], [t1].[cid] [cid2], [t1].[address] [address], (select count(*) [dbo].[ord] [t2] [t2].[cid] = [t0].[cid]) [value] [dbo].[customer] [t0] left outer join [dbo].[ord] [t1] on [t1].[cid] = [t0].[cid] order [t0].[cid], [t1].[oid] i want understand how rid of count(*) part. it's entirely uncalled for! linq needs count(*) in order determine number of entries returned o = c.ord.tolist() .
Read more