• Post Reply Bookmark Topic Watch Topic
  • New Topic

how to trace sql query

 
Ramakrishnan Ponmudi
Ranch Hand
Posts: 72
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i want to see, what is the exact sql query running in Database when a
prepared statement used.
 
Sri Ram
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What DB u are using?
If u are using SQL Server, U can use, Profiler. This will give u all the queries that are fired to the DB.
 
Sri Ram
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If u are using Oracle, This might be useful. Trace Data Viewer. This is a tool provided by Oracle.
 
Gravity is a harsh mistress. But this tiny ad is pretty easy to deal with:
the new thread boost feature: great for the advertiser and smooth for the coderanch user
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!