Select * from v$version
It is equivalent of select @@version in Sybase and SQL server.
Monday, October 22, 2012
Subscribe to:
Post Comments (Atom)
Translate
Search this blog
About me
Labels
ADDM
(2)
ADR
(1)
adrci
(1)
ASH
(1)
ASM
(8)
AWR
(4)
AWS
(4)
Azure
(8)
BACKUP_RESTORE
(6)
BOOK
(2)
Certification
(2)
Cloud
(7)
ColumnStore
(1)
constraint
(1)
Contained Database
(1)
CTE
(1)
Cursor
(1)
Data Buffer Cache
(1)
Data Model
(1)
Data Recovery Advisor
(1)
Database Link
(3)
Database Replay
(1)
DATABASE_ALERT
(1)
DatabaseMail
(3)
DataStudio
(2)
DB2
(27)
DB2 10.5
(4)
DBCC
(6)
DBcompare
(1)
DMV
(5)
DQS
(1)
DSDE
(3)
ERwin
(1)
Event
(3)
Greenplum
(1)
GRID
(6)
HADR
(7)
Hardware
(4)
HIgh Availability
(2)
Hyper-V
(7)
index
(2)
InMemoryOLTP
(7)
Installation
(1)
ISOLATION
(1)
kerberos
(2)
Learning Resource
(1)
Linux
(29)
Listener
(2)
Log
(6)
MDS
(1)
MDW
(1)
Memory Management
(27)
MongoDB
(2)
MSSQL
(115)
MSSQL 2008
(51)
MSSQL 2012
(14)
MSSQL 2014
(27)
Networking
(3)
NoSQL
(2)
NUMA
(3)
OEM
(8)
Oracle
(135)
Oracle File
(17)
Oracle Resource Manager
(3)
Oracle Stream
(2)
Oracle12c
(1)
partition
(2)
Performance Tuning
(28)
php
(1)
PL/SQL
(3)
PostgreSQL
(4)
PowerShell
(7)
RAC
(5)
Resource
(3)
Resource_Governor
(1)
SAMPLE DB
(1)
Security
(21)
SGA
(10)
SHARED_POOL
(5)
SQL
(11)
SQL*Plus
(2)
SQLagent
(1)
sqlite
(1)
SSDT
(1)
SSMS
(3)
Starbucks
(1)
Storage
(19)
Storage Engine
(4)
Sybase
(2)
T-SQL
(19)
TableSpace
(11)
TDE
(1)
tempdb
(13)
Teradata
(1)
Tool Box
(33)
trace
(2)
TroubleShooting
(48)
UserAdmin
(8)
Vargant
(1)
Virtual Box
(9)
Virtualization
(11)
VMWare
(9)
vNext
(1)
windbg
(4)
Windows Server 2012
(1)
Windows8
(1)
WinServer 2012
(1)
WinServer2008
(23)
Popular posts
-
Export DB2 export utility can export the table data to 4 different file format: DEL : delimited ASCII format WSF: work sheet format ... -
V$SQL All sql in the shared pool, does not include “group by “ , only has first 1000 char V$SQLTEX... -
we can use srvctl to manage, maintain and check the RAC related services, such as Instance, Database, Listener and ASM . crsctl is the... -
When I try to connect to my Oracle RAC test environment via SCAN name with SQL Developer, I got the error “ORA-12505, TNS:listener does not ... -
There are few ways to check db2 edition and installed features. DB2licm db2licm is the db2 license manager program db2level d... -
When drop the database link, I get the error “ ORA-02082: a loopback database link must have a connection qualifier ”. This is becaus... -
While Install the Oracle Grid infrastructure, I got CRS 4124 error as below: CRS-4124: Oracle High Availability Services startup faile... -
I get this error “ ORA-12528: TNS:listener: all appropriate instances are blocking new connections ” while testing the rman backup. Ro... -
SQL Server 2012 64-bit use AWE API for LPIM. Even AWE is no longer needed on the 64-bit because the VAS on the 64-bit is significant larger ... -
I want to grant the user ability to select from v$session. so I issue the GRANT SELECT ON v$session TO rcs1; However, I got the ORA-02030: c...
My Starbucks CityMug
Total Views ( Last 30 Days)
Follow by Email
SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates
0 comments:
Post a Comment