I tried the below sql query INSERT INTO test.ACT_QUERY values(2139,2,\'SELECT \'\'D\'\',ORDER_ID from dual\');
Oracle Newbie Here:开发者_StackOverflow社区 I just started out creating my first Oracle database table.
I\'m making a web app that needs to load and save UTF-8 (Korean, specifically) characters from a DB.I\'ve been given an account on the Oracle 10g server, but it saves VARCHAR2 type columns as ASCII7,
I\'m trying to write a program with C and ESQL. One of the things I want to do is delete old row from one of my table (by comparing with SYSDATE) each time the program is run.
I have a materialized view that looks somewhat like the following and I\'m wondering if there is anyway to have this materialized view \'fast\' refreshable?Basically, I\'m asking the following:
I think I have a complex requirement. It\'s a combinatorial permutation using Oracle 10.2, I\'was able to solve it using cartesian joins, but I think that it need some improvements to made it simples
I am trying to update a tab开发者_如何学Pythonle by joining the values with another table. Here\'s my query so far.
I have a column \'name\' in Database which has values as \'john,smith\'. I\'m passing a string variable \'name_respository\' to a stored procedure which has values as \'test,test1,john,test2\' or \'te
I am trying to import a .dmp file using impdp command. Whenever I try that I get following error logs:
How could I have a trigger that updates a certain field when the system reaches a certain date ? i.e.
加载中,请稍侯......