I am getting error as attached, while trying to connect to my database oracle 22.214.171.124 using ER Studio. How ever I can connect using SQL Developer and sql prompt ( I mean tnsnames.ora settings are correct).
Could you let me know how to resolve it?
Note: 1. Other guys are able to connect (using Windows XP).
2. Please find the error details in attached docs. Login-Issue.docx
Truncate is a DDL Command where as Delete is a DML Command.
Both will delete data from table, but what is the difference between these below statements
truncate table <table_name> ??
delete from <table_name> ??
The first command cannot be …
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…