SELECT (
SELECT COUNT(*)
FROM tab1
) AS count1,
(
SELECT COUNT(*)
FROM tab2
) AS count2
FROM dual
More Related Contents:
- How to count the number of occurrences of a character in an Oracle varchar value?
- The most efficient way to UPPER CASE two columns in a single query [closed]
- Current date in Oracle Db
- SQL QUERY COUNT THEN ADD
- I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
- Case insensitive searching in Oracle
- Get value based on max of a different column grouped by another column [duplicate]
- ORA-00918: column ambiguously defined in SELECT *
- Multiplication aggregate operator in SQL
- Pivoting rows into columns dynamically in Oracle
- MySQL equivalent of DECODE function in Oracle
- How to get Oracle create table statement in SQL*Plus
- How do I select all the columns from a table, plus additional columns like ROWNUM?
- Disable all table constraints in Oracle
- ORA – 00933 confusion with inner join and “as”
- OVER clause in Oracle
- PARTITION BY with and without KEEP in Oracle
- Comparing with date in Oracle sql
- Is it possible to query a comma separated column for a specific value?
- Different CURRENT_TIMESTAMP and SYSDATE in oracle
- SQL selecting rows by most recent date with two unique columns
- How to extract group from regular expression in Oracle?
- Using LIKE in an Oracle IN clause
- How to handle optional parameters in SQL query?
- Return number from Oracle Select statement after parsing date
- How do you interpret a query’s explain plan?
- How to call Oracle MD5 hash function?
- Oracle Convert TIMESTAMP with Timezone to DATE
- SQL Server equivalent of WM_CONCAT function [duplicate]
- Oracle: ‘= ANY()’ vs. ‘IN ()’