I\'m writing a stored procedure to copy data from one user\'s table to another schema. Basically, it is a series of INSERT .. SELECT statements such as this:
I have such code: DECLARE e_not_exist EXCEPTION; PRAGMA EXCEPTION_INIT(e_not_exist, -942); car_name VARCHAR2(20);
I am logged in as the dba account and I want to create a view in User1\'s schema, but selecting data from User2\'s.
we have a Java program connecting via JDBC thin client to an Oracle 10g database. Everything was working fine, but now the DBA wants us to connect with a different username/password, which is suppose
As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references,or expertise, but this question will likely solicit debate, a
Say you gener开发者_运维知识库ate ddl to create all your db tables etc via Hibernate SchemaExport etc.What you get is a script which starts with drop statements at the beginning.Not a problem, as I wa
I created a table named dual2. I\'ve a rows there, and can select from it. When attempting to drop it, it produces this error:
We have 2 databases - DB1 & DB2. Can I create a table in DB1 that has a relation with one of the tables in DB2?
I\'m trying to clean up an accidental installation of LOG4PLSQL into the wrong (i.e., SYS) schema. There is a queue table called QTAB_LOG that needs to go away. I have successfully stopped and dropped
Is it possible to rebase a branch with all its parent branches with Git? (I think "p开发者_C百科arent branches" is the correct form to use here. Depending on your viewpoint, you might also c
加载中,请稍侯......