ora-00942

相关标签：javascript jquery android 多少钱 iPhone

Accessing another user's table within an Oracle Stored Procedure

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:[详细]

2023-01-29 11:45 分类：问答
Oracle errors handling

I have such code: DECLARE e_not_exist EXCEPTION; PRAGMA EXCEPTION_INIT(e_not_exist, -942); car_name VARCHAR2(20);[详细]

2023-01-25 09:02 分类：问答
Oracle Create View issue

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.[详细]

2023-01-22 23:45 分类：问答
JDBC connect string and Oracle synonyms

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[详细]

2023-01-19 11:13 分类：问答
Is there a rational reason that Oracle's error feedback is lousy for this example? [closed]

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[详细]

2023-01-19 01:04 分类：问答
Suppress ORA-00942 errors in ddl create scripts

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[详细]

2023-01-19 01:03 分类：问答
Can't drop table that was just created

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:[详细]

2023-01-10 06:30 分类：问答
Can I create Foreign Keys across Databases?

We have 2 databases - DB1 & DB2. Can I create a table in DB1 that has a relation with one of the tables in DB2?[详细]

2023-01-02 01:01 分类：问答
Cannot drop Oracle queue table with DBMS_AQADM.DROP_QUEUE_TABLE

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[详细]

2022-12-29 21:35 分类：问答
Git rebase branch with all parent branches (or dependent sub-branches)

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[详细]

2022-12-28 17:20 分类：问答