Re: Table stats in 10.2

Cool. But this is puzzeling ...

"afiedt.buf" 2 lines, 98 characters

1* select last_start_date, next_run_date from dba_scheduler_jobs
where job_nam
e='GATHER_STATS_JOB'
SQL> /

LAST_START_DATE
---------------------------------------------------------------------------
NEXT_RUN_DATE
---------------------------------------------------------------------------
27-APR-06 10.00.02.945170 PM -05:00



SQL> select sysdate from dual;

SYSDATE
---------------
28-APR-06

Hmm. No last start date, and the next run date is in the past?

.

Relevant Pages

  • Re: Using part of a field
    ... See the article "Finding and replacing characters using wildcards" at: ... AS400 SQL may have a different way of doing ... called i.dsn, containing the followiing text: ... sort of thing in a query. ...
    (microsoft.public.word.mailmerge.fields)
  • RE: Collation settings for ASCII code page
    ... The string sort and comparison behavior for non-Unicode data ... characters you can store without using Unicode. ... There is no such thing as an "ASCII code page" in SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: sendStringParameterAsUnicode: How to insert unicode data corre
    ... We are using SAP XI and connecting it to SQL Server 2005 using JDBC. ... The destination columns are nvarchar and store unicode data correctly. ... is unable to display the characters you have. ... Configuration: MS SQL server 2005 SP2, and MS jdbc driver version: 1.1 ...
    (microsoft.public.sqlserver.jdbcdriver)
  • Re: simple (?) question about having ";" in the password
    ... whatever characters they damn well please. ... Attempting to escape SQL strings is a non-starter. ... themselves "do I need to use a prepared statement here ?". ... but it could happen) since its going to be added to the SQL string. ...
    (comp.lang.java.programmer)
  • Re: Problem with sql statement in VB
    ... Of course you could use, but you never know what are special characters, ... >I went and looked around at the various postings regarding SQL Injection ... because it could lead to SQL injection attack from ... to avoid any issues with the dates format or number ...
    (microsoft.public.vb.database.ado)