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 ... -
I get this error “ ORA-12528: TNS:listener: all appropriate instances are blocking new connections ” while testing the rman backup. Ro... -
netca (Network Configuration Assistant) is Oracle command line for configure the Oracle listener. Enterprise Manager has dependence on the ... -
V$SQL All sql in the shared pool, does not include “group by “ , only has first 1000 char V$SQLTEX... -
Just like most of the Windows software, SQL Server is operating under thread model. This means the SQL Server process would spawn child thre... -
After clone the VM within Virtual box, I receive the error message “ Device eth0 does not seem to be present, delaying initialization .” w... -
I want to write the query to display the index within the database and its creation date. Here is the query: SELECT object_name... -
Download link for Windows Server 2008 R2 VHD http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=16572 Extra the VH... -
Recently, I have the need to import the WIM image file to VMWare. Here are the steps how I achieve this. Convert WIM to VHD This c... -
Password file is only used to authenticate for SYSDBA,SYSOPER and SYSASM. Not for the normal user. password file location: $ORACLE_HOME/db...
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