Great set of pointers - thanks for the write-up, Helen! I especially like your SELECT TOP 0 table creation trick. Is any of this specific to certain SQL dialects?
I work as a staff software engineer at a med tec company. We are mainly programming in C++ but my background is also a functional one (Haskell, OCaml).
In the past I did research in program analysis.
I am using oracle. Can use select * from table where 1<>1 to create a empty table of this format? Or any other specific query available to select no records like TOP in Microsoft SQL?
For further actions, you may consider blocking this person and/or reporting abuse
We're a place where coders share, stay up-to-date and grow their careers.
Great set of pointers - thanks for the write-up, Helen! I especially like your
SELECT TOP 0
table creation trick. Is any of this specific to certain SQL dialects?Especially SELECT TOP 0 is Microsoft SQL server specific. The other commands looked like they are ANSI SQL.
Ok,
TOP
was what I was wondering about - thanks!I am using oracle. Can use select * from table where 1<>1 to create a empty table of this format? Or any other specific query available to select no records like TOP in Microsoft SQL?