Examples for validating dates in plsql
Bulk Binds - Improve performance by reducing the overhead associated with context switches between the PL/SQL and SQL engines.Collections in Oracle PL/SQL - Use collections in PL/SQL to perform array processing.Shell Commands From PL/SQL - Use this simple method to perform shell commands from within PL/SQL.ANYDATA Type - This article presents an overview of the ANYDATA type.Export BLOB - A simple method for exporting the contents of a BLOB datatype to the filesystem.Export CLOB - A simple method for exporting the contents of a CLOB datatype to the filesystem.Introduction to PL/SQL - A brief overview of some of the important points you should consider when first trying to learn PL/SQL.
Data Encryption - DBMS_OBFUSCATION_TOOLKIT - Encrypt and decrypt data using the DBMS_OBFUSCATION_TOOLKIT package.
If you run the following you should get the same results from the first query as the second: SELECT my Date Column, to_date(my Date Column) , to_char(my Date Column,'DD-MON-YY HH. SS PM'), to_char(my Date Column,'YYYY') FROM my Table WHERE to_date(my Date Column) BETWEEN to_date('13-FEB-11', 'DD-MON-YY') AND TO_DATE('15-FEB-11', 'DD-MON-YY'); select to_char(to_date(sysdate), 'dd/mm/yyyy hh24:mi:ss') trunc, 2 to_char(sysdate, 'dd/mm/yyyy hh24:mi:ss') not_trunc 3 from dual; TRUNC NOT_TRUNC ------------------- ------------------- 23/10/2012 23/10/2012 So your two clauses are not equivalent at all.
The second one selects the whole day feb, 15th whereas the first one only selects the first second of the day.
or anything elsecan you please give an example how to i will do that.
This seems like a frequent request across all languages.