See also: https://serverfault.com/questions/63216/ora-12705-cannot-access-nls-data-files-or-invalid-environment-specified/64536 For me the best response was by FoxyBOA to invoke java app with: -Duser.country=en -Duser.language=en
There are two ways to set this up. If you have an SID, use this (older) format: jdbc:oracle:thin:@[HOST][:PORT]:SID If you have an Oracle service name, use this (newer) format: jdbc:oracle:thin:@//[HOST][:PORT]/SERVICE Source: this OraFAQ page The call to getConnection() is correct. Also, as duffymo said, make sure the actual driver code is present by including ojdbc6.jar … Read more
Oracle does not support table alias with the as. For example: SQL> select 1 2 from dual as a; from dual as a * ERROR at line 2: ORA-00933: SQL command not properly ended SQL> select 1 2 from dual a; 1 ———- 1 The same way: SQL> select * 2 from ( 3 select … Read more
Unfortunately SQL Developer doesn’t fully honour the set echo off command that would (appear to) solve this in SQL*Plus. The only workaround I’ve found for this is to save what you’re doing as a script, e.g. test.sql with: set echo off spool c:\test.csv select /*csv*/ username, user_id, created from all_users; spool off; And then from … Read more
I’m really late to this party but here’s how I did it: SELECT SCN_TO_TIMESTAMP(MAX(ora_rowscn)) from myTable; It’s close enough for my purposes.
99.9% of the time the error ORA-65096: invalid common user or role name means you are logged into the CDB when you should be logged into a PDB. For example, if you used the default 19c installation settings, you should login to ORCLPDB (the PDB) instead of ORCL (the CDB). DANGER – If you insist … Read more
If GetQuestions is a function returning a refcursor, which seems to be what you have in the SQL Server version, then rather you may be able to do something like this: select * from table(MyPackage.GetQuestions(‘OMG Ponies’)); Or if you need it in a PL/SQL block then you can use the same select in a cursor. … Read more
This can be done dynamically the following way. First, here is the static version of the query so you can see the final sql: select c_id, p_id, max(case when r_key= ‘KEY1’ then r_value end) KEY1, max(case when r_key= ‘KEY2’ then r_value end) KEY2, max(case when r_key= ‘KEY3’ then r_value end) KEY3, max(case when r_key= ‘KEY4’ … Read more
SQL> select trunc(months_between(sysdate,dob)/12) year, 2 trunc(mod(months_between(sysdate,dob),12)) month, 3 trunc(sysdate-add_months(dob,trunc(months_between(sysdate,dob)/12)*12+trunc(mod(months_between(sysdate,dob),12)))) day 4 from (Select to_date(‘15122000′,’DDMMYYYY’) dob from dual); YEAR MONTH DAY ———- ———- ———- 9 5 26 SQL>
Bind variables are not allowed in DDL statements. So following statements will cause errors: Example #1: DDL statement. Will cause ORA-01027: bind variables not allowed for data definition operations EXECUTE IMMEDIATE ‘CREATE TABLE dummy_table ( dummy_column NUMBER DEFAULT :def_val )’ USING 42; Example #2: DDL statement. Will cause ORA-00904: : invalid identifier EXECUTE IMMEDIATE ‘CREATE … Read more