Java application is passing date and time to Oracle SPR as a string parameter that contains fractional seconds points (milliseconds). According to Oracle documentation, FF format mask is supposed to work with fractional seconds, and specifically FF3 should work for parsing those milliseconds. However I am getting the following Oracle error ORA-01821: date format not recognized : -- this code does not work - it throws the following ORACLE error

Need an Oracle script to quickly compare two tables and identify columns that are different i.e. columns that are present in one table and missing in the other table, thanks!

What is the view name in Oracle that lists all columns in all tables available to the current user?

Can I write IF ... THEN ... GOTO statements in one single line of code in Oracle PL/SQL?

How to parse Full Name separated by comma into First Name and Last Name in Oracle SQL? For example, the following string 'Smith, James' should be split into 2 strings 'Smith' and 'James'

I have a dump of Users data from Active Directory into Oracle table and need to create a view to analyze Active Directory data using SQL. One of the columns in that view needs to be a flag that would contain 'Y' if this user account is disabled in Active Directory, and 'N' if user account is active and user can log in. I have a numeric column called user_account_control that basically contains a value from UserAccountControl AD attribute. I kno

How to include a DATE constant / expression / literal in my PL/SQL script so the script would successfully run in different database environments with potentially different default date format settings? I am referring here to NLS settings, specifically NLS_DATE_FORMAT

What is the equivalent to Oracle PL/SQL TRANSLATE function in Microsoft SQL Server T-SQL? TRANSLATE returns string with all occurrences of each character in from_string replaced by its corresponding character in to_string, both of these strings are being passed as parameters to TRANSLATE. For example, TRANSLATE('big brown cow', 'abc', 'xyz') /* this would return 'yig yrown zow' */ This function is useful in many situations, for example,