I have created a common user in Oracle and the pluggable database name is pdborcl.
I am able to login as sysdba with the common userid and password but not able to login as a normal user. Can anyone ...

For examples, lets say I need to do set operations and joins on below 3 result sets.
I don't want to write a composite query or use temporary database tables. Something which would enable faster data ...

I am mainlining a legacy system and realize that the answer to this may take a deeper explanation of the code but before I go that far I wanted to make sure the solution wasn't something more simple.
...

I am trying to run a query on a local Oracle DB and output the results to a .CSV file. The query runs in a decent amount of time (usually less than 5 minutes), but returns tens of thousands (possibly ...

This one has me stumped. We are running an Oracle 11g on Amazon EC2 and I can connect and query fine with SQL Developer but with Toad and SQL/Plus I can connect but when I try to do a simple select ...

My company is currently exploring the option of using TOAD as a means to seamlessly allow developers to check-in/check-out code in TFS. This would be seeded by our packages, stored procedures, etc. ...