<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0">
  <channel>
    <title>VerySource - Oracle</title>
    <link>https://forum.verysource.com/forum-47-1.html</link>
    <description>Latest 20 threads of Oracle</description>
    <copyright>Copyright(C) VerySource</copyright>
    <generator>Discuz! Board by Comsenz Inc.</generator>
    <lastBuildDate>Tue, 29 Sep 2026 16:13:44 +0000</lastBuildDate>
    <ttl>60</ttl>
    <image>
      <url>https://forum.verysource.com/static/image/common/logo_88_31.gif</url>
      <title>VerySource</title>
      <link>https://forum.verysource.com/</link>
    </image>
    <item>
      <title>It shows that the update was successful in sqlplus, but it is not actually updated</title>
      <link>https://forum.verysource.com/thread-3368-1-1.html</link>
      <description><![CDATA[Very strange problem, I used a statement
update QBA01 set qm=\'Five Districts\',dm=\'One Team\',zm=\'Southern Trinity\' where rq&gt;=TO_DATE(\'2017-01-01\',\'yyyy-mm-dd\') and rq]]></description>
      <category>Oracle</category>
      <author>lyiner</author>
      <pubDate>Mon, 19 Oct 2020 02:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Using java to develop software, but it can\'t connect to the oracle database installed in the machine, and always throws</title>
      <link>https://forum.verysource.com/thread-3298-1-1.html</link>
      <description><![CDATA[Related code in Java:

Class.forName( \&quot;oracle.jdbc.driver.OracleDriver\&quot; );
conn = DriverManager.getConnection( \&quot;jdbcracle:thinLvQiang:1521:Oracle\&quot;,\&quot;SYSTEM\&quot;, \&quot;zrc775fp\&quot;)


The exception thrown:

java.sql.SQLException: Io exception: The Netw]]></description>
      <category>Oracle</category>
      <author>catlituo</author>
      <pubDate>Tue, 29 Sep 2020 07:30:01 +0000</pubDate>
    </item>
    <item>
      <title>Questions about random queries</title>
      <link>https://forum.verysource.com/thread-3260-1-1.html</link>
      <description><![CDATA[Such as the title: I want to randomly select a record from a table A, I used two methods, but the results obtained are completely different, please ask prawns:


method one:
select * from tableA where rownum]]></description>
      <category>Oracle</category>
      <author>w220913</author>
      <pubDate>Fri, 25 Sep 2020 07:00:01 +0000</pubDate>
    </item>
    <item>
      <title>There is a project to migrate SQL Server database to Oracle</title>
      <link>https://forum.verysource.com/thread-3259-1-1.html</link>
      <description><![CDATA[Including more than 200 tables, more than 90 stored procedures. Which master can help? I don\'t understand Oracle at all. Very anxious, thank you]]></description>
      <category>Oracle</category>
      <author>yjjun917</author>
      <pubDate>Fri, 25 Sep 2020 06:30:01 +0000</pubDate>
    </item>
    <item>
      <title>A simple question!</title>
      <link>https://forum.verysource.com/thread-3180-1-1.html</link>
      <description><![CDATA[Declare
hh dlyx.y_khda.hh% Type;
s Number: = 0;
Begin
For m In (Select * From tmhb070101 t)
Loop
Select Count (*)
Into s
From dlyx.y_khda@yjdlyx k Where
substr (k.yhh, 1, length (k.yhh) -3) = m.yhh And k.dw Like \'0303%\';
dbms_output.put_line (]]></description>
      <category>Oracle</category>
      <author>abel63</author>
      <pubDate>Tue, 24 Mar 2020 03:00:02 +0000</pubDate>
    </item>
    <item>
      <title>One of my fields in the data table was originally of type varchar2 and now I want to change it to Blob, why ca n’t I c</title>
      <link>https://forum.verysource.com/thread-3078-1-1.html</link>
      <description><![CDATA[One of my fields in the data table was originally of type varchar2 and now I want to change it to Blob, why ca n’t I change it?
How to deal with the content of a field with a length exceeding 4000? How should I read it?]]></description>
      <category>Oracle</category>
      <author>szj0571</author>
      <pubDate>Sat, 21 Mar 2020 04:30:02 +0000</pubDate>
    </item>
    <item>
      <title>How to achieve this?</title>
      <link>https://forum.verysource.com/thread-3014-1-1.html</link>
      <description><![CDATA[DECLARE
  A NUMBER (16,2);
  B NUMBER (16,2);
BEGIN
  SELECT FIELD1 INTO A, FIELD2 INTO B FROM TABLE;
END;

I find that ORACLE can only be received with one parameter. Is there a similar function?]]></description>
      <category>Oracle</category>
      <author>wang7498</author>
      <pubDate>Thu, 19 Mar 2020 06:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Find a SQL</title>
      <link>https://forum.verysource.com/thread-2996-1-1.html</link>
      <description><![CDATA[There is a table as follows
num1 num2 date
  1 2 20160329
  1 2 20160329
  1 2 20160329
  1 2 20160330
  1 2 20160401
...

Now I want to write a query to find the sum of num1 and num2 every 7 days. Please ask everyone to write a Sql and exp ...]]></description>
      <category>Oracle</category>
      <author>lianchan</author>
      <pubDate>Wed, 18 Mar 2020 12:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Database character set, how to modify from ANSI to unicode</title>
      <link>https://forum.verysource.com/thread-2899-1-1.html</link>
      <description><![CDATA[Because the word creation program (eudcedit.exe) is used for word creation, the GBK code point is not enough. I want to use unicode code point for word creation. However, some words created by unicode code point can be displayed in the database. Is a ...]]></description>
      <category>Oracle</category>
      <author>ajsdhja</author>
      <pubDate>Sun, 15 Mar 2020 15:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Query data. Use time as a filter condition. The condition is incorrect.</title>
      <link>https://forum.verysource.com/thread-2889-1-1.html</link>
      <description><![CDATA[select * from t_inout_all where
to_char (createtime, \'yyyy-mm-dd hh: mm: ss\') = \'2016-11-28 17:50:00\'


createtime is a DATE type]]></description>
      <category>Oracle</category>
      <author>aoturen</author>
      <pubDate>Sun, 15 Mar 2020 10:00:01 +0000</pubDate>
    </item>
    <item>
      <title>Newbie question: Show employee names without \'R\'. Thank you all for your help!</title>
      <link>https://forum.verysource.com/thread-2859-1-1.html</link>
      <description><![CDATA[As the title, I checked a lot of character functions such as substr but they are not flexible enough to be arbitrary string length. I hope the experts can answer, thank you!]]></description>
      <category>Oracle</category>
      <author>henailina</author>
      <pubDate>Sat, 14 Mar 2020 11:00:01 +0000</pubDate>
    </item>
    <item>
      <title>In Oracle, can I give users permission to see only the specified tables and views?</title>
      <link>https://forum.verysource.com/thread-2824-1-1.html</link>
      <description><![CDATA[RT
How to set it up?
Thank you for your excellent suggestion!]]></description>
      <category>Oracle</category>
      <author>cslys1979</author>
      <pubDate>Fri, 13 Mar 2020 10:00:01 +0000</pubDate>
    </item>
    <item>
      <title>How to escape&</title>
      <link>https://forum.verysource.com/thread-2798-1-1.html</link>
      <description><![CDATA[SELECT * FROM A where A.col1 = \'F&amp;ORG\'

Use shell to call sqlplus. The value to be checked is that col1 is \'F&amp;ORG\', but it always prompts for the variable&amp;org.]]></description>
      <category>Oracle</category>
      <author>iamloki</author>
      <pubDate>Thu, 12 Mar 2020 14:00:02 +0000</pubDate>
    </item>
    <item>
      <title>How to delete the first ten data</title>
      <link>https://forum.verysource.com/thread-2739-1-1.html</link>
      <description><![CDATA[I want to submit every 10 records deleted, is there no delete top 10 method in oracle?]]></description>
      <category>Oracle</category>
      <author>剥夺者</author>
      <pubDate>Wed, 11 Mar 2020 02:00:01 +0000</pubDate>
    </item>
    <item>
      <title>`` How to dynamically define variables in the program? \'\'</title>
      <link>https://forum.verysource.com/thread-2738-1-1.html</link>
      <description><![CDATA[In Oracle, how to dynamically define variables in the middle of a program to use when fetching data in a cursor. The number of variables to be defined and the type of the variable are unknown in advance.
But the number of variables and the type of va ...]]></description>
      <category>Oracle</category>
      <author>gangananren</author>
      <pubDate>Wed, 11 Mar 2020 01:30:01 +0000</pubDate>
    </item>
    <item>
      <title>ora-01034 ora-27101</title>
      <link>https://forum.verysource.com/thread-2706-1-1.html</link>
      <description><![CDATA[Appears when connecting to oracle database under windows
ora-01034: ORACLE not available
ora-27101: shared memory readm does not exit

error.

Check the windows service list. Both oracleSERVER and oracleSERVER1 are running.

Start-run-cmd
c:\\&gt; s]]></description>
      <category>Oracle</category>
      <author>cyanolive</author>
      <pubDate>Tue, 10 Mar 2020 01:30:02 +0000</pubDate>
    </item>
    <item>
      <title>Database character set problems</title>
      <link>https://forum.verysource.com/thread-2648-1-1.html</link>
      <description><![CDATA[Because the word creation program (eudcedit.exe) is used for word creation, the GBK code point is not enough. I want to use unicode code point for word creation. However, some words created by unicode code point can be displayed in the database. Is a ...]]></description>
      <category>Oracle</category>
      <author>ajsdhja</author>
      <pubDate>Sun, 08 Mar 2020 06:30:01 +0000</pubDate>
    </item>
    <item>
      <title>ORACLE import problems?</title>
      <link>https://forum.verysource.com/thread-2584-1-1.html</link>
      <description><![CDATA[The problem looks like this:
Originally, I exported a table from an ORACLE, and then imported it in another database, and then reported the following error, please let me know which heroes have encountered:

The error message is as follows:

Warning:]]></description>
      <category>Oracle</category>
      <author>iohexol</author>
      <pubDate>Fri, 06 Mar 2020 08:30:01 +0000</pubDate>
    </item>
    <item>
      <title>The use of oracle custom objects</title>
      <link>https://forum.verysource.com/thread-2499-1-1.html</link>
      <description><![CDATA[A type of list nsrlist is defined in oracle:
create or replace type nsrlist is varray (2000) of varchar2 (20)

The stored procedure body is as follows:
create or replace package body TESTVARRAY is
procedure testSS (nsrs out nsrlist) is
   nsrarray .]]></description>
      <category>Oracle</category>
      <author>紫云流星</author>
      <pubDate>Wed, 04 Mar 2020 00:30:01 +0000</pubDate>
    </item>
    <item>
      <title>How to record SQL statements that did not execute successfully</title>
      <link>https://forum.verysource.com/thread-2472-1-1.html</link>
      <description><![CDATA[That\'s it, I have this scenario:
There is an Oracle database. After the application runs for a period of time, which SQL statements are not successfully executed through the database, for example, the update statement sent to the database is not exec ..]]></description>
      <category>Oracle</category>
      <author>fanswar78</author>
      <pubDate>Tue, 03 Mar 2020 05:30:01 +0000</pubDate>
    </item>
  </channel>
</rss>