oracle10g - Oracle query that returns columns of a certain type -


is possible write oracle query returns columns of type 'timestamp'?

something -

select table_name, column_name dba_tab_columns table_name 'est_%'  , column_type = 'timestamp'; //here select columns of type 'timestamp'

i looking wrong table - dba_ind_columns instead of dba_tab_columns.

the query pretty straightforward -

select table_name, column_name dba_tab_columns table_name 'est\_%' escape '\' , data_type = 'timestamp(6)';

Comments

Post a Comment

Popular posts from this blog

php - Extract Text from HTTP referer -

i using following code show referer link page on website. how can modify code shows part of link. i.e if website url www.example.com/?s=printing want extract printing. , should happen if format www.example.com/?s=aaa , not if format else www.example.com/printing. code: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; echo $_session["origurl"] ?> i figured out , following code works: <?php session_start(); if ( !isset( $_session["origurl"] ) ) $_session["origurl"] = $_server["http_referer"]; $mysearchterm = $_server["http_referer"]; $whatiwant = substr($mysearchterm, strpos($mysearchterm, "=") +1); echo $whatiwant; ?>
Read more

Receive udp packets in android gstreamer -

i using eclipse juno in windows 7. doing programming on android 4.2 platform. want receive udp packets in gstreamer application. giving uri udp://127.0.0.1:1234 , sending file vlc player same computer. emulator giving message could not get/set setting from/on resource while in case of rtp, giving message no uri implementer found rtp ideas how receive streaming media in android?
Read more

ios - How to Rectify the Relationship Fault in CoreData While parsing RESTKIT? -

i want store ey_connectionusage entity value ey_connection entity cell.i have added 2 entities attributes , created relationship name usagedata .but shows error "<'usagedata' relationship fault>".this method wrote map restkit value coredata. dataaccesshandler.m +(void)createconnectionmappingwithstore:(rkmanagedobjectstore *)managedobjectstore saveindelegate:(appdelegate *)appdelegate{ nslog(@"appdele==>>%@",appdelegate); rkentitymapping *connectionmapping = [rkentitymapping mappingforentityforname:@"ey_connections" inmanagedobjectstore:managedobjectstore]; connectionmapping.identificationattributes = @[@"connectionnumber"]; [connectionmapping addattributemappingsfromdictionary:@{ @"serviceno" : @"connectionservicenumber", @"name" : @"connectionname", @"region" : @"connectionregion", @"phase" : @"connectionphase", @"circle" ...
Read more