Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
to find out the which command is executed in oracle
This is a discussion on to find out the which command is executed in oracle within the Oracle forums, part of the Databases category; hi all can anybody tell me how we can trace all the privious executed sql command which is either call by application or sqlplus command prompt?...
|
|||||||
| Oracle Oracle 9i & Oracle 10g Knowledge Base Learn and Share Oracle Technology related articles, white papers, tutorials / study materials, example codes, FAQ's, Tips and Tricks. |
 |
| LinkBack | Thread Tools | Display Modes |
11-13-2007
|
|||
|
|||
|
to find out the which command is executed in oracle
hi all
can anybody tell me how we can trace all the privious executed sql command which is either call by application or sqlplus command prompt? 
|
| Sponsored Links |
|
01-07-2008
|
|||
|
|||
|
Re: to find out the which command is executed in oracle
By using Flashback version Query option you can get back all your prevously modified data.(i,e. u have applied "update" command many times in columns u can view all the updated data)
|
|
01-07-2008
|
|||
|
|||
|
Re: to find out the which command is executed in oracle
Quote:
use sys.v_$sqlarea or sys.v_$sql
|
|
01-08-2008
|
|||
|
|||
|
Re: to find out the which command is executed in oracle
but that has limitations on how previous data you can select.
|
|
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Direct command in abinito to find record count | Geek_Guest | Data Warehousing | 0 | 04-13-2007 03:20 AM |
| Oracle Command Line question | suji | Oracle | 1 | 01-03-2007 08:22 AM |
| Want to know about this command | christia | Windows | 2 | 11-01-2006 10:09 AM |
| Can you tell the command | christia | Unix/Linux | 1 | 09-09-2006 05:00 PM |
| Can you brief about this command | RyanJames | Unix/Linux | 1 | 08-31-2006 04:29 PM |
All times are GMT -4. The time now is 02:22 PM.
