Table or view to determine

2011-02-16  来源:本站原创  分类:Database  人气:42 

System tables

SELECT OBJECT_NAME, T. * FROM ALL_OBJECTS T WHERE T. OBJECT_NAME = 'TMP' object_type = 'TABLE';

Used to determine orlace from behind with a table or view. .

相关文章
  • Table or view to determine 2011-02-16

    System tables SELECT OBJECT_NAME, T. * FROM ALL_OBJECTS T WHERE T. OBJECT_NAME = 'TMP' object_type = 'TABLE'; Used to determine orlace from behind with a table or view. .

  • drop table report ora-00942 table or view does not exist / / SQL_TRACE basic usage 2010-07-09

    Oracle Case for diagnosis using Sql_trace Description of the problem: Very often, when we carry out database operations, such as drop user, drop table, etc., often encounter this error ORA-00604: error occurred at recursive SQL level 1. This prompted

  • ORA-00942 table or view does not exist to solve the problem 2010-02-06

    Problem behavior: ORACLE database, the sometimes like to engage in performance monitoring of their job, inevitably to the use of stored procedures dynamic view of some, but will report the following error: Compilation errors for PROCEDURE SCOTT.P_SES

  • java.sql.SQLException: ORA-00942: table or view does not exist 2010-04-16

    Database, even when such a list, check through java program is not, suggesting java.sql.SQLException: ORA-00942: Table or view does not exist Connect through sqlplus, only administrators can view this table the total, so it should be permission issue

  • Transfer: Based on remote database table, materialized view creation of local databases 2010-05-03

    Based on remote database tables, creation of local databases materialized views December 28, 2008 Sunday 12:40 to connect the remote server is a reference to the following snippet: create database link linkfwq connect to fzept identified by neu using

  • Oracle error when you delete a table: table or view does not exist 2011-02-15

    Indicates that there is, but delete Shique error: table or view does not exist. One possible reason is the table name contains lowercase, you can use double quotes around table names by drop command to delete, As follows: drop table "tmp_ST"

  • oracle procedure table or view does not exist problem 2011-03-06

    Today in writing a procedure, let the tables every day to the growth of space, timing function of the oracle's job to complete. In code, write such a statement select sum(bytes) from dba_data_files where tablespace_name='USRES' Compile always prompt

  • Cross-users to create view ORA-00942: table or view does not exist error 2011-04-01

    Today in my ORACLE 9.2.0.1 / WINXP platform to create cross-VIEW users found a strange problem. I run a grant dba to userc, then run create or replace view userc.view 2 As 3 select a.pkg_id, a.scheme_id, c.item_code, c.adjustrate_id, 4 to_char (c.val

  • ORACLE plsql table structure view 2011-04-14

    ORACLE plsql table structure view 1 new command window, note the command window, not in the SQL window! ! ! 2. SQL> DESC HISBASE.TBL_TDRUGCODE; Note: The table space table. ------------- Work record when Yin

  • ORA-00942: table or view does not exist 2011-10-26

    SQL> conn hr / *** SQL> select username, sid, serial #, module, action from v $ session; select username, sid, serial #, module, action from v $ session ORA-00942: table or view does not exist Address: sqlplus "sys / *** as sysdba" SQL>

  • MySQL table structure view 2010-04-10

    MySQL table structure above view by: 1. Desc table_name; - describe table_name 2. Show columns from table_name; 3. Show create table table_name; 4. use information_schema; select * from columns where table_name = 'table_name'; - Ha ha. . . A lot of i

  • Oracle table to view each of the number of rows 2011-05-13

    Can query user_tabless, which has a num_rows column SQL statement is: select table_name, num_rows from user_tables However reminded, num_rows column is not updated in real time, to more accurate results is best to check before ANALYZE under the new a

  • View and determine suse redhat linux version 2011-04-11

    View version way about in three ways: [[email protected] ~]# cat /proc/version Linux version 2.6.9-22.ELsmp ([email protected]) (gcc version 3.4.4 20050721 (Red Hat 3.4.4-2)) #1 SMP Mon Sep 19 18:00:54 EDT 2005 uname -a Linux q1test01 2.6.

  • "Table or view does not exist" to run the stored procedure to resolve this error reported 2011-06-02

    Today, writing stored procedures, the report or view does not exist, the table is checked under there, but not change under the user's table space. Solution: change login account B, and then execute grant select on table to A;

  • From the point of view to determine the probability of critical points 2010-04-30

    We will encounter in daily life in many "critical point" of the problem. What is the critical point? For example, when the phone bill less than 10 yuan, the move will send a reminder text message to inform "Your balance has been limited, pl

  • cpu. memory. Linux systems view and determine the average load, etc. 2010-05-05

    1, for cpu occupancy [Root @ localhost utx86] # top-n 1 | grep Cpu Cpu (s): 1.9% us, 1.3% sy, 0.0% ni, 95.9% id, 0.6% wa, 0.1% hi, 0.2% si, 0.0% st Explained: 1.9% us is the user take up cpu case 1.3% sy, is the system is using cpu case 2, access the

  • SQL to determine the database table stored procedure view. The existence of a function 2010-09-06

    - To determine whether there is a database if exists (select * from master .. sysdatabases where name = N 'library name') print 'exists' else print 'not exists' --------------- - Table to be created to determine whether there were if exists (select *

  • View the table definition, table, field, sql server 2010-03-10

    SELECT DISTINCT sysobjects.name, syscolumns.colid, syscolumns.name, systypes.name, syscolumns.prec, syscolumns.scale FROM syscolumns, sysobjects, systypes WHERE sysobjects.id = syscolumns.id AND systypes.type = syscolumns.type AND ((sysobjects.type =

  • Oracle Database 10g SQL Developer's Guide Chapter 10 to create the table. Sequence. Indexes and view excerpts 2010-07-08

    Chapter 10 Create a table. Sequence . Indexes and views Alter table You can also enable or disable constraints . Alter table You can modify the column, the type of condition is the length of the column can be modified , For example, CHAR, or VARCHAR2

  • MySql view the database and table creation statements 2010-07-27

    Bowen reference: http://zhuixue.javaeye.com/blog/375572 Very often, we would like to see the structure of the database table, of course, if we have the tools at hand, then, is easy, but in the absence of readily available tools, we should how to do i