• 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic