Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by cjohn
-
snapshot too old, in english
Thank-you, I read the article, but my goal is to delete a huge table so for that I create a temp, intermediate table. After that I use a cursor which read rows from the temp table and I make a delete. But the error is at the time of the creation of temp table. So if I can not use or create a...- cjohn
- Post #5
- Forum: Oracle: All versions
-
snapshot too old, in english
Hello, Will some one help me? Which of the two requests, which return the same result, is more quickly ? More generally is than the fact of making a connection between two tables is more powerful than to call upon overlapping SELECT? Request 1 CREATE TABLE MY_TEMP_TRANS NOLOGGING PARALLEL...- cjohn
- Thread
- Replies: 5
- Forum: Oracle: All versions
-
snapshot too old
Bonjour, Est-ce que quelqu'un pourra m’aider ? Laquelle des deux requêtes, qui retournent le même résultat, est plus performante ? Plus généralement est ce que le fait de faire une liaison entre deux tables est plus performant que de faire appel à des SELECT imbriqués ? Requête 1 : CREATE...- cjohn
- Thread
- Replies: 0
- Forum: Oracle: All versions
