Sql

Search

open cursors in oracle

select b.sid, a.username, b.value Cursores_Abiertos
      from v$session a,
           v$sesstat b,
           v$statname c
      where c.name in ('opened cursors current')
      and   b.statistic# = c.statistic#
      and   a.sid = b.sid 
      and   a.username is not null
      and   b.value >0
      order by 3

Comment

PREVIOUS	NEXT

Code Example
Sql :: long string type sql
Sql :: show broken table mysql
Sql :: select top values sql
Sql :: sql select statements
Sql :: mysql allow connection from any host
Sql :: insert data to postgresql from excel
Sql :: Ms Sql set us timezone
Sql :: find duplicates in column sql
Sql :: sql cross apply vs join
Sql :: initcap in mysql
Sql :: how to create local postgres database
Sql :: alter rename command in mysql
Sql :: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , , = or when the subquery is used as an expression.
Sql :: mysql delete if not in another table
Sql :: sql ssrs
Sql :: character count sql
Sql :: create a table
Sql :: query on date sqlite flutter
Sql :: SQL MIN() Function
Sql :: year format in date mysql
Sql :: sqlite csv
Sql :: select limit ms sql
Sql :: sql query to linq converter online
Sql :: set identity_insert off
Sql :: swiftui onappear only once
Sql :: mysql coonect sample code
Sql :: psql fetch all rows with null
Sql :: ring SQLite sqlite_open
Sql :: sql server udf performance
Sql :: shows all databases created by user in ms sql

Search

SQL

open cursors in oracle

ADD CONTENT