Query

[dodie]

---

i would not consider UtOkbOlinAO's post as a bad nor lazy.. i guess he's just looking for a simple approach in SQL's field of computing.. and since its not yet there, then maybe someone could push the idea - bring it to the public and say, "hey heroes! here's a new technique in querrying something like 'construct a query that would select all 19 colums pero dili i.explicit ug apil sa query ang column name' "....now that's computing..now that computer science!

Creating a function to exclude the column to create a dynamic query...... It's very possible. When it comes to real sql, it suppose to be complete.

[psyd_1]

Creating a function to exclude the column to create a dynamic query...... It's very possible. When it comes to real sql, it suppose to be complete.

via function, of course yes...but the point was he (TS) wanted it to be one-lined which i assumed is wala pa ta kahibaw..ang if ever somebody knows it (or might wanna contribute to the computing field solutions to scenarios like this) , then i would say its not LAZY CODE.. and it ain't BAD CODE

[simoncpu]

Hi guys,

Lets assume nga naa moy isa ka table then with 20 colums..

how do u construct a query that would select all 19 colums pero dili i.explicit ug apil sa query ang column name...

in short "select * except a column" how to do this?

Thanks guys in advance...

What you should do is to specify all the column names except the column that you don't need.

This makes your query valid even if new columns are added or if the column order is changed

[simoncpu]

i would not consider UtOkbOlinAO's post as a bad nor lazy.. i guess he's just looking for a simple approach in SQL's field of computing.. and since its not yet there, then maybe someone could push the idea - bring it to the public and say, "hey heroes! here's a new technique in querrying something like 'construct a query that would select all 19 colums pero dili i.explicit ug apil sa query ang column name' "....now that's computing..now that computer science!

No, this is not computer science. Computer science and software engineering encourages robust code and correct practices.

You can, however, write a script that generates the correct SQL for you. That's another topic though...

[psyd_1]

No, this is not computer science. Computer science and software engineering encourages robust code and correct practices.

You can, however, write a script that generates the correct SQL for you. That's another topic though...

i would still say is computer science..it still digs into the notion of "a sequence of instructions that repeats either a specified number of times or until a particular condition is met"...simply computing..

computer science also not just sits on robust code and correct practices..as on my understanding computer science also deals with new fields of computing, new methods, way of solving probs...i guess this is the thin line between software engineering and computer science itself..

so i would still say the TS's prob is still valid ( sticking to a one-liner script, not via functions )

[simoncpu]

i would still say is computer science..it still digs into the notion of "a sequence of instructions that repeats either a specified number of times or until a particular condition is met"...simply computing..

computer science also not just sits on robust code and correct practices..as on my understanding computer science also deals with new fields of computing, new methods, way of solving probs...i guess this is the thin line between software engineering and computer science itself..

so i would still say the TS's prob is still valid ( sticking to a one-liner script, not via functions )

Straw man - Wikipedia, the free encyclopedia

[aozora]

@utok, naa nani solution?

[dlanyer77]

i told you i have the solution, but my apology if you saw me too busy lately that might be the reason why you hesitate to remind me. anyway, i'll just leave a scratch paper containing a very short solution at the guard house if i am not able catch you personally. furthermore, i believe this site was block in your work place since last week i guess... hmm... so it doesn't make sense to send you pm.

have a nice coding!

[UtOkbOlinAO]

@utok, naa nani solution?

yup, naa nani solution...

------------------------------------
SELECT COLUMN_NAME
FROM USER_TAB_COLUMNS
WHERE TABLE_NAME = XTABLE
AND COLUMN_NAME <> XCOLUMN
-------------------------------------

from this QUERY makuha na ang solution ani... kamo na bahala kung unsa inyong paagi...

[dlanyer77]

inyong paagi...

hehehe! i believed you get the tricks. feel free to email me if you need some unthinkable stuff.