Questions tagged by "oracle"


0
 bounty
1
answers
[SOLVED] - ORA-01821 while parsing datetime string with Fractional Seconds (FF3 format mask for milliseconds) - ORA-01821: date format not recognized
9 years ago • alex@qrid
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
Tags:
0
 bounty
1
answers
Oracle SQL script to compare columns differences in two tables
9 years ago • alex@qrid
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!
Tags:
0
 bounty
1
answers
Oracle ALL_TABLE_COLUMNS view
9 years ago • alex@qrid
What is the view name in Oracle that lists all columns in all tables available to the current user?
Tags:
0
 bounty
1
answers
PL/SQL: IF ... THEN ... GOTO in one line of code
9 years ago • alex
Can I write IF ... THEN ... GOTO statements in one single line of code in Oracle PL/SQL?
Tags: ,
0
 bounty
1
answers
Oracle SQL - splitting Full Name separated by comma into First Name and Last Name
9 years ago • alex
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'
Tags: ,
0
 bounty
1
answers
Using SQL to analyze Active Directory UserAccountControl bits to determine if account is DISABLED or ENABLED
9 years ago • alex
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
0
 bounty
1
answers
Oracle DATE constant expression invariant to date format settings
9 years ago • alex@qrid
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
Tags: ,
0
 bounty
1
answers
Equivalent to Oracle TRANSLATE function in Microsoft SQL Server
10 years ago • alex
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,
1 from 8