Tag Archives: select

LIMIT and TOP in select query

In this post we will learn the usage of LIMIT and TOP in select query. In order to limit the records from the select query each database provides different syntax. For example : MySQL has LIMIT – which will be used to limit the records from the select query. In the same way SQL Server provides… Read More »

Find database names in Oracle

Below select queries help us to find database names in Oracle, and also we can find the  SID, service name and server host. Oracle query command to  find the database name is: select * from global_name; select ora_database_name from dual; Oracle query command to check the SID (or instance name): select sys_context(‘userenv’,’instance_name’) from dual; Oracle query… Read More »