Jul 19, 2005 · I'm trying to run a SQL query but can't find any records when trying to select a certain date. Here's the sql: SELECT field 1, field2, date_and_time, FROM table1 WHERE date_and_time = …

Jul 23, 2005 · Hi all, I have a question about inserting records into sql server. I am brand new to sql server, always using oracle previously. Before today, I had always written statement such as this: …

Jul 19, 2005 · Re: How to test for a null value in a date column "e.DateFini shed = NULL" - did you try "e.DateFini shed is null" Regards, Ron DBA Infopower

Aug 31, 2018 · To demonstrate this, enter any date in the Criteria row under a date field in Query Design, and then switch to SQL View. In Query Design view, you see the date according to your …

Jun 26, 2007 · 2.CHECK THE DATATYPE OF THIS TWO FIELDS AND THEN CHECK THE DATE FORMAT FOR THESE FIELDS. 3.NOW USE THIS QUERY FOR UPDATE: UPDATE …

Mar 14, 2012 · Are you able to run the report query (using pl/sql or some other db tool) fine with the parameters you are passing?

Sep 24, 2007 · i have a doubt in pl/sql table,that is what is the difference between binary_integer and pls_integer. 1..type <typename> is table of emp.empno%type index by binary_integer,

Sep 23, 2010 · I import information from a third party and they have the ability in the description field to do carriage returns and line feeds. How can I remove the carriage returns and line feeds from the …

Mar 24, 2008 · The easiest way should be using a package that contains a TYPE of table, and use the aliases of this table as input parameter types. Check this: [code=oracle] CREATE OR REPLACE …

Sep 19, 2007 · SQL Query using user_tab_columns and user_col_comments Sep 19 '07, 07:51 AM Hi, I am using user_tab_column s and user_col_commen ts to get details about the table. Here is my …