I am new to Oracle. I have a doubt regarding two basic queries I see everyday at work. Say, I have a table employee with 1000 records. When I fire:
Select count(*) from employee;
Select count(1) from employee;
They both give me the same result – 1000.
Is there any difference between count(*) and count(1)?
- 1563 views
- 5 answers
- 10 votes
I have an issue when creating a huge table space. Reports this error:
SQL1139N The total size of the table space is too big Explanation: The size of the current table space is too big.
The size of a REGULAR table space is limited to 0xFFFFFF (16777215) pages while the size of a TEMPORARY/LONG table space is limited to 2 tera bytes (2 TB).
- 1012 views
- 3 answers
- 31 votes
Please help me,
I cant open SQLYOG. I'm clueless as to how can I open this DBMS software.
(Separate multiple databases with a semicolon ';'. Leaving Database(s) blank will display all databases)
- 2236 views
- 6 answers
- 11 votes
- 1875 views
- 2 answers
- 20 votes