SQL that Compare Two Tables
Compare Two Tables' Column Names Whenever you concern the differences between two tables' definition, you can use queries to compare the columns of two tables.… Read More »SQL that Compare Two Tables
Query
How to Resolve ORA-00913: too many values
ORA-00913 When SELECT Let's see a SQL statement containing a subquery that can reproduce ORA-00913 for an example. SQL> select * from employees where department_id… Read More »How to Resolve ORA-00913: too many values
Oracle Limit Rows Returned
Oracle Limit Query Returned In MySQL, we use SQL LIMIT clause to limit number of rows returned in SELECT SQL statements. But in Oracle, we… Read More »Oracle Limit Rows Returned
How to Resolve ORA-01427: single-row subquery returns more than one row
ORA-01427 There're two error patterns related to ORA-01427 described in this post: SELECT with Equal Operator Job Failed by Trigger. I will talk about them… Read More »How to Resolve ORA-01427: single-row subquery returns more than one row
How to Limit Number of Rows Returned in a Query
You can order a specific column in a query by adding ORDER BY clause, but the result always returns and lists all the rows that… Read More »How to Limit Number of Rows Returned in a Query