Now, Oracle is one of the most sophisticated database management systems.
Up to now, learning tens of tools and hundreds of functions required a lot of time. You can get familiar with all the unique options it offers in 2 hours or learn one of the database programming techniques you need in just a few minutes.
For Example: The price of a product changes constantly.
It is important to maintain the history of the prices of the products.
Hi Tom, How can I know what a given user is executing if his status is ACTIVE ?
How can I know which PL/SQL blocks or SQL statements are being run by him ? It shows everyone logged in and if they are active, what they are doing and how long they've been doing it.
The set of rows the cursor holds is called the set.
There are two types of cursors in PL/SQL: These are created by default when DML statements like, INSERT, UPDATE, and DELETE statements are executed.program username, to_char(LOGON_TIME,' Day HH24: MI') logon_time, to_char(sysdate,' Day HH24: MI') current_time, sql_address, LAST_CALL_ET from v$session where status = 'ACTIVE' and rawtohex(sql_address) '00' and username is not null order by last_call_et ) loop for y in ( select max(decode(piece,0,sql_text,null))