Need Help In Stored Procedure..

[sitaraZahir]

sorry my bad.....no idea about what you are talking about

athanu stored proc gurinchi adigadu kada.....and he wants to do the count and store it in another table

 

 

konchem elaborate about the concept you just mentioned pls

 

http://technet.microsoft.com/en-us/library/bb964713(v=sql.100).aspx

[spidereddy]

If its oracle use SQL%rowcount

 

 

dude...if you there...need some more info..

[spidereddy]

sorry my bad.....no idea about what you are talking about

athanu stored proc gurinchi adigadu kada.....and he wants to do the count and store it in another table

 

 

konchem elaborate about the concept you just mentioned pls

lyt tsco bhayya..:)

[Vinuu]

ltt

[Vinuu]

ltt

[siritptpras]

Ltt

[ravula]

LTT

[CheGuevara]

For execution time ... Declare 3 variables like vexec, vstart and vend, then before the main sp execution get the system time using vstart=dbms_utility.get_time;
Then after the main procedure is done, before exiting get the system time into vend variable
Calculate the exec time vexec=vend-vstart)
Then print it using dbms_output.put_line(vexec)

[ravula]

For execution time ... Declare 3 variables like vexec, vstart and vend, then before the main sp execution get the system time using vstart=dbms_utility.get_time;
Then after the main procedure is done, before exiting get the system time into vend variable
Calculate the exec time vexec=vend-vstart)
Then print it using dbms_output.put_line(vexec)

 

TS adigina first question?

how to save the values into a table?

btw i am not into oracle....only ltt'ing for him

[CheGuevara]

TS adigina first question?
how to save the values into a table?
btw i am not into oracle....only ltt'ing for him

Emundi aa vexec variable value ni insert statement tho table lo pettadame

[spidereddy]

Cheguevera...thanks bhayya..

[AakPakKarivePak]

HELP

[spidereddy]

I took pls_interger as datatype...
Got result as some 5000..adhi seconds oh milli seconds oh ardam aithale..

[spidereddy]

For the guys who want to find the solution...

It gave me hsecs...hundredth of secs..so i divided by 100 and inserted into another table..
As suggested by cheguevera..i took 3 vars..thanks again..
Also i declared 3 variables for getting record count..1 for each update and 1 for getting total count of records updated and inserted that value to another table..

[idiBeZaWaDa]

just beat ra spidy..