Experience in ORACLE development

ORACLE Date _:Submitdate=datetime.parse (submitdate). ToString ("D-m month-yyyy"); Current time: Sysdate ()To_date (' 2002-01-02 ', ' yyyy-m-dd ') select COUNT (1) from l_perm where CANCEL <> ' Y ' and (sysdate-perm_date) >3

Debugging and experimenting in pl/sql develop, I write to an SQL statement that was previously in SQL Server:

INSERT into ... (............)     VALUES (..., ' 2004-7-20 11:25:36 ', ...) --This statement applies to SQL Server

Made a mistake. I also thought that Oracle's date type separator was like Access is # and I tried again:

INSERT into ... (............)    VALUES (..., #2004-7-20 11:25:36#, ...) --This statement applies to Ms Access

To look up articles on the Internet, many places are written in this way:

INSERT into ... (............) VALUES (..., to_date (' 2004-7-20 11:25:36 ', ' yyyy-mm-dd hh24:mi:ss '), ...)

To_date, To_char,.

Find an example of how to input and output date type data. See the TIMESTAMP keyword, the above SQL statement can be written as:

INSERT into ... (............)   VALUES (..., TIMESTAMP ' 2004-7-20 11:25:36 ', ...) Select the first n records: You can use ROWNUM<10, the first 10 data, format
SELECT * FROM t where rownum<10
between the two
SELECT * FROM (select RowNum r,a.* from tablename a where rownum <=) where R >= 60; Get sequence: select C_order. Nextval as ID from DUAL