Question : I am trying to insert 25 users, user1…25 into Members with the same GR_ID = 2 with command: […]
Tag: oracle
Generate sample data for an Oracle database [closed]
Question : As it currently stands, this question is not a good fit for our Q&A format. We expect answers […]
At which frequency run CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on a fulltext index?
Question : I’ve been told to run periodically CTXSYS.CTX_DDL.OPTIMIZE_INDEX(…) on some fulltext indexes, with no more information, in particular at […]
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 […]