So recently I had to connect to a database via sqlplus where I did not have tnsnames.ora and password has a special character. Without tnsnames.ora your cli looks like Sqlplus emre/p@ssword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=myoracle.host)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myoraservicename)))Sqlplus emre/p@ssword@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP) (HOST=myoracle.host)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=myoraservicename))) Do you notice @ in my password that causes the issue on our case here. This will give you ERROR:ORA-01017: invalid […]

Read More

We have some queries on our web application that required us to write sql statements which includes IN clause for thousands of items. We hit Oracle limit for 1000 items on those IN clauses. We resolved this by separating them with OR based on queries. Recently I learned that, Any in statement like X IN  […]

Read More