FAQ : How to find Product version in SQL Server and in Oracle

SQL Server

Select @@Version
Or
SET NOCOUNT ON;
SELECT
CONVERT( varchar, SERVERPROPERTY('Edition')) AS Edition
, CONVERT( varchar, SERVERPROPERTY('ProductVersion')) AS Version
, CONVERT( varchar, SERVERPROPERTY('ProductLevel')) AS Level


Oracle

select * From V$VERSION ;
Note : V$VERSION is the catalog view which provides all the information in Oracle