2 I am using Oracle Database and i had same problem. Eventually i found ORACLE DB is converting all the metadata (table/sp/view/trigger) in upper case. And i was trying how i wrote table name …

Oct 11, 2012 · The oracle server was "patched" and one of the databases I use could not be connect via the TNSNames entry but via Basic connection. The Database was up and admin could see it was up …

Feb 12, 2013 · An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact …

Are you sure you need SQLPlus and not Oracle SQL Developer? The command-line SQLPlus is useful for some things, but most development is much easier with an IDE like Oracle SQL Developer.

Sep 7, 2024 · I'm using Oracle.ManagedDataAccess to connect to a local Oracle SQL database. With this source: OracleConnectionStringBuilder connStr = new(); //fake password and username, but I …

Jan 13, 2026 · Oracle CTE query not joining as expected (null fields when both tables joined) [closed] Enclosed is a query below that aggregates all lines from notes fields into one line, performs some …

How to list all the roles existing in Oracle database? Asked 12 years, 1 month ago Modified 7 years, 1 month ago Viewed 283k times

Mar 7, 2009 · My application, which uses an Oracle database, is going slow or appears to have stopped completely. How can find out which queries are most expensive, so I can investigate further?

Apr 16, 2024 · Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production I read about SET UNUSED, but it seems like it's the same thing? Rather, it will not physically clear the table …

Sep 4, 2008 · Oracle SID is the unique name that uniquely identifies your instance/database where as Service name is the TNS alias that you give when you remotely connect to your database and this …