Updating date field in oracle
For a single statement that is executing many sets of bind parameters, the user-defined function is called for each set of parameters, and call the function, i.e.
It seems to me that there has got to be a simpler way in general, while mataining the Date Time datatype...
To String("dd-MMM-yy"); sql Insert = "INSERT INTO tbl(Oracle Date) VALUES ('" c Filed "')" You want it without quotes there or you get the literal value "c Filed".....
When used in the subquery of a DML statement, you can specify this clause in a subquery in the can be a subquery, a column, a function, or a collection constructor.
The following examples use the columns contain a time component, which does not match in this case.
The way the Oracle database handles datetime values is pretty straightforward, but it seems to confuse many client-side and PL/SQL developers alike.