New answers tagged

0

SQL*Plus supports an additional format: DEFINE StartDate = TO_DATE('2016-06-21'); DEFINE EndDate = TO_DATE('2016-06-30'); SELECT * FROM MyTable WHERE DateField BETWEEN &StartDate and &EndDate; Note the ampersands where the substitutions are to be performed within the query.


0

Add port listener 1521 in firewall: Inbound Rules and Outbound Rules. Add permissions in ORACLE_HOME in regedit: cmd → regedit → HKEY_LOCAL_MACHINE → SOFTWARE → ORACLE


0

I had to modify René Nyffenegger's answer to make it more generic and easier to see space usage for all indexes in a schema. Thought I'd share the modified code here, in case anyone else finds it useful: --========================================== -- Show space usage by all indexes in schema --========================================== -- Required to ...


0

I had to revisit this issue again yesterday and while cross-checking all settings found out some inconsistencies in the Windows's DNS settings (compared to the reference working server). For whatever reason, those settings were not identical (only the list of DNS servers was, not the additional domains). Once I adjusted them to be identical, this error ...



Top 50 recent answers are included