Question : As it currently stands, this question is not a good fit for our Q&A format. We expect answers […]
Category: Oracle
How do you protect against malicious PREPROCESSOR attacks in Oracle External Tables?
Question : I’m a new DBA and I recently found out about the option of External Tables in Oracle using […]
How do I get the difference in minutes from 2 timestamp columns?
Question : Can’t seem to figure this out. Just need the difference in minutes between 2 oracle timestamp columns. END_TS […]
Why my index don’t update?
Question : I have created this index ORACLE/VIDEO# create index titolo_index 2 on titolo(titolo) 3 indextype is ctxsys.context 4 ONLINE […]
Help me define the tables in this scenario
Question : We have 2 tables setup like this: WEB_GK_STATE PRG_CODE Varchar2(5) STATE Varchar2(2) WEB GK PRG_CODE Varchar2(5) TEXT Varchar2(4000) […]
Is a process created in Oracle for every SQL statement?
Question : After reading the Oracle docs, it´s still not clear for me if an Oracle process is created for […]
How to select a row based on the maximum value of a column, when ties are expected
Question : SUBSCRIBER DATE TIME VALUE aaa 23-04-2015 04:04:07 10 aab 23-04-2015 12:04:32 5 bbb 23-04-2015 01:04:05 20 bbb 23-04-2015 […]
Eclipse data source explorer not showing Inserted table records (Oracle)
Question : After I installed Oracle database 11g, I went to Eclipse Database Development Perspective and successfully created a new […]
Spliting name with delimiter
Question : Hi can you help me to split the name into firstname, middle name, lastname using a pl/sql procedure. […]
Unable to remove a user in Oracle 11g
Question : I have a streams replication related user in Oracle 11g. I see the user in dba_users table and […]