26.2 C
New York, US
Saturday, July 20, 2019 07:25 AM
Database

Database

Hi,

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;

 

And

 

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).

Thank you

  • 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

Hi all,

How can one install SQL Server 2008? Please tell me the step by step procedure.
 
Thanks & Regards.
  • 1875 views
  • 2 answers
  • 20 votes

Articles

Blogs

Tips