Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What are the steps you take to tune(performance tuning) the code in plsql?

Answer Posted / sandeep

variable_first:=dbms_utility.get_time
variable_last:=dbms_utility.get_time;
dbms_output.put_line('elapsed time':var_first-var_last);

Is This Answer Correct ?    2 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain ttitle and btitle.

1119


Explain architecture of sql server notification services?

1060


What is primary key and foreign key?

962


How many types of sql are there?

986


Does access use sql?

1045


How do you modify a column in sql?

999


Which table is left in join?

979


What are the different schemas objects that can be created using pl/sql?

1029


Is stored procedure faster than query?

969


how do you know if your mysql server is alive? : Sql dba

1078


Can we use two order by clause in query?

967


Why do we use sql constraints?

1171


Write a sql query to get the third highest salary of an employee from employee_table?

1073


Is clustered index a primary key?

949


What are the types of index in sql?

1070