« delete a structure pointer, but type is changed to char* ?
How do i write a SQL statement with regular expression that cleans "-" and excess spaces from a number field ? »

How do you write a Select statement that returns all rows in a SQL statement?

December 24, 2009 - 9:51 pm

SQL Oracle

About as simple as it gets:

SELECT * FROM someTable;

Note that doing SELECT * is generally considered bad programming practice…most of the time, you really don’t need every single column of the table, so you’re just needlessly using system resources to retrieve stuff you don’t want anyway.

Posted select statement |

2 Responses to “How do you write a Select statement that returns all rows in a SQL statement?”

  1. nerdist_nerd Says:
    December 25th, 2009 at 3:14 am

    Select *

    From tablename;
    References :

  2. TheMadProfessor Says:
    December 25th, 2009 at 3:40 am

    About as simple as it gets:

    SELECT * FROM someTable;

    Note that doing SELECT * is generally considered bad programming practice…most of the time, you really don’t need every single column of the table, so you’re just needlessly using system resources to retrieve stuff you don’t want anyway.
    References :

Leave a Reply