Edit D:\app\Administrator\product\11.2.0\dbhome_1\sqldeveloper\sqldeveloper\extensions\oracle\dbtools\migration\workbench\plugin\Sybase12CaptureObjectsOnlineCapturer.class
?? 1 Q 6 7 8 9 : ; < = > ? @ A B C D E F G H I J K <init> Q(Loracle/dbtools/migration/workbench/core/MigrationStorer;Ljava/sql/Connection;)V Code LineNumberTable LocalVariableTable this PLoracle/dbtools/migration/workbench/plugin/Sybase12CaptureObjectsOnlineCapturer; storer 9Loracle/dbtools/migration/workbench/core/MigrationStorer; sourceConnection Ljava/sql/Connection; setStorer <(Loracle/dbtools/migration/workbench/core/MigrationStorer;)V getCAPTURE_CATALOGS_QUERY ()Ljava/lang/String; getCAPTURE_SCHEMAS_QUERY getCAPTURE_TABLES_QUERY #getCAPTURE_COLUMNSDESCRIPTION_QUERY #getCAPTURE_INDEXESDESCRIPTION_QUERY &getCAPTURE_STORED_PROGRAMS_INNER_QUERY &getCAPTURE_STORED_PROGRAMS_OUTER_QUERY getCAPTURE_VIEW_OUTER_QUERY getCAPTURE_VIEW_INNER_QUERY getCAPTURE_TRIGGER_OUTER_QUERY getCAPTURE_TRIGGER_INNER_QUERY (getCAPTURE_PRIMARY_AND_FOREIGN_KEY_QUERY getCAPTURE_CONSTRAINTS_QUERY getCAPTURE_COLUMNDEFAULT_QUERY getCAPTURE_COLUMN_USER_TYPE SourceFile )Sybase12CaptureObjectsOnlineCapturer.java L M N " # O ! P select db_name() CATALOG_NAME vselect name SCHEMA_NAME from sysusers where suid>0 and uid in (select distinct uid from sysobjects) order by suid desc mselect a.name TABLE_NAME from sysobjects a, sysusers b where type='U' and a.uid=b.uid and b.name='${schema}'tselect syscolumns.name , systypes.name ,syscolumns.length,syscolumns.prec ,syscolumns.scale,syscolumns.status,syscolumns.cdefault,syscolumns.usertype,syscolumns.type from syscolumns,systypes where syscolumns.id=(select id from sysobjects a, sysusers b where a.name ='${table}' and a.uid=b.uid and b.name='${schema}')and syscolumns.usertype=systypes.usertype order by colid sp_helpindex ${table} dSELECT a.name, c.text FROM sysobjects a, syscomments c WHERE a.id = ? and a.id=c.id order by colid ?ELECT a.name, a.type,a.id FROM sysusers b, sysobjects a WHERE ( a.type = 'P' OR a.type = 'FN' OR a.type = 'TF' OR a.type = 'IF') and a.uid=b.uid AND b.name = '${schema}' hselect a.name,a.id from sysobjects a, sysusers b where a.type='V' and a.uid=b.uid and b.name='${schema}' Xselect c.text from sysobjects a, syscomments c where a.id=c.id and a.id=? order by colid ?ELECT a.name, a.id FROM sysobjects a, sysusers c WHERE a.type = 'TR' AND a.uid = c.uid AND c.name = ? and a.deltrig = (select id from sysobjects where name = ? ) 8 select text from syscomments where id =? order by colid sp_helpkey '${table}' sp_helpconstraint '${table}' 8select text from syscomments where id = ? order by colid | select name from systypes where usertype < 100 and type = ? and name not in ('longsysname', 'sysname', 'nchar', 'nvarchar') Noracle/dbtools/migration/workbench/plugin/Sybase12CaptureObjectsOnlineCapturer Boracle/dbtools/migration/workbench/plugin/Sybase12AbstractCapturer ()V m_online Z m_sourceConnection m_storer ! b *? *? *+? *,? ? ! ! " # > *+? ? & ' $ % - ? - & % - ? 4 ' % - ? ; ( % - ? D ) % - ? N * % - ? W + % - ? [ , % - ? b - % - ? h . % - ? n / % - ? v 0 % - ? z 1 % - ? ? 2 % - ? ? 3 % - ? ? 4 5
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de