oracle database - SQL Error: ORA-00942 table or view does not …
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 …
How do I resolve this "ORA-01109: database not open" error?
May 3, 2017 · 2 Open SQLPLUS and login with sys as sysdba. After that run alter pluggable database <<database_name>> open; This Worked for me .
How to check the maximum number of allowed connections to an …
Oct 2, 2008 · What's the best way, using SQL, to check the maximum number of connections that is allowed for an Oracle database? In the end, I would like to show the current number of …
How to enter special characters like "&" in oracle database?
Aug 29, 2016 · I want to insert special character & in my insert statement. My insert is: INSERT INTO STUDENT(name, class_id) VALUES ('Samantha', 'Java_22 & Oracle_14'); If I try to run …
How to check Oracle database for long running queries
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 …
How to find Oracle Service Name - Stack Overflow
Dec 2, 2016 · I have an Oracle database on my network which I am able to connect to with Oracle SQL Developer, using hostname, port, username, password and the SID. I need to connect …
Checking oracle sid and database name - Stack Overflow
Checking oracle sid and database name Asked 14 years, 4 months ago Modified 4 years ago Viewed 911k times
oracle database - ORA-28001: The password has expired - Stack …
I had same problem, i am trying to login database it appear a message with: "ORA-28001: The password has expired" , I have fixed the problem simple steps 1.open command prompt 2.type …
Connecting to Oracle Database through C#? - Stack Overflow
Sep 24, 2012 · I need to connect to a Oracle DB (external) through Visual Studio 2010. But I dont want to install Oracle on my machine. In my project I referenced: System.Data.OracleClient. …
Is there any boolean type in Oracle databases? - Stack Overflow
Sep 16, 2010 · Is there any Boolean type in Oracle databases, similar to the BIT datatype in Ms SQL Server?