Finding tables with BLOB field

How to find the tables from a schema which have at least one BLOB field?

Published: 03 Aug 2006

How to find the tables from a schema which have at least one BLOB field?

A simple query from DBA_TAB_COLUMNS will do the trick:

SELECT owner,table_name,column_name 
FROM dba_tab_columns WHERE data_type='BLOB';

Dig Deeper on Oracle and SQL

SearchDataManagement

Ahana brings PrestoDB SQL query engine to the cloud

Soon after announcing its seed round of funding, Ahana launched commercial support services for the open source federated SQL ...

Confluent enables infinite Kafka scalability in the cloud

Kafka gets data retention boost that can make it easier for users to store event streaming data for long periods of time, which ...

Fivetran raises $100M to advance enterprise data integration

The co-founder and CEO of Fivetran talks about what the vendor is doing to help organizations meet the challenges of enterprise ...

SearchBusinessAnalytics

Overcoming the top 3 analytics adoption challenges

Analytics is a growing part of many businesses. Experts talk about some of the most pressing challenges enterprises may face when...

More AI, ease of use will shape Sisense analytics platform

After spending three years at Alteryx most recently, Ashley Kramer is now Sisense's new chief product officer. In an interview, ...

Lack of data literacy still a problem for many organizations

Organizations' lack of confidence in their ability to understand and use data to make decisions blocks their efforts to become ...

SearchSAP

SAP Cloud Platform apps deal with pandemic problems

SAP Cloud Platform is proving to be a useful development environment for applications that address issues brought on by the ...

7 SAP S/4HANA implementation issues to address

A move to S/4HANA is critical for SAP users, but getting it right is difficult. Here's a look at seven issues to address.

SAP for Me provides 'one-stop shopping' for product data

Customers who need comprehensive information about their SAP environments can now use the new SAP for Me portal to get a complete...

SearchSQLServer

SQL Server database design best practices and tips for DBAs

Good database design is a must to meet processing needs in SQL Server systems. In a webinar, consultant Koen Verbeeck offered ...

SQL Server in Azure database choices and what they offer users

SQL Server databases can be moved to the Azure cloud in several different ways. Here's what you'll get from each of the options ...

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this book excerpt, you'll learn LEFT OUTER JOIN vs. RIGHT OUTER JOIN techniques and find various examples for creating SQL ...

TheServerSide.com

3 ways a volunteer programmer can help in a pandemic

DevOps pros can help local and state agencies battle COVID-19. Here are three ways they can volunteer their time during a ...

Oracle's release cadence opens door for Java support rivals

Oracle has opened the door for competitors to chip away at its hold on the market for providing Java support to enterprise ...

Dojo Toolkit 7 focuses on JavaScript developer productivity

Dojo Toolkit version 7 is now available. The widely used, mature JavaScript framework favored by enterprise shops gains more ...

SearchDataCenter

An introduction to DCIM software metrics and terms

Infrastructure management is no easy task. The right software can help admins track how efficient their server racks and ...

6 steps to prep your organization for ISO 9001 certification

ISO 9001 is a quality management standard. Before your team decides to become certified with an official audit, you should have ...

Honeywell touts quantum computer speed, but how fast is fast?

Honeywell has delivered what it believes is the industry's fastest quantum computer. But analysts say it will take more than ...

SearchContentManagement

Microsoft products address digital workplace security

Microsoft is enhancing products with additional features to address content security, enabling businesses to minimize risks while...

Why version control is necessary in digital asset management

Version control is essential to DAM systems, as it enables multiple iterations of documents and rich media while retaining the ...

How to use social networking CMS to create social media sites

Whether a company uses its own social CMS or a vendor's platform to create a social media site, it offers more features to users ...

SearchHRSoftware

Feds nix college degree requirement for merit-based hiring

President Trump has ordered federal agencies, which employ 2.2 million, to move to merit-based hiring by the end of the year. ...

HR software selection: How to ask the right questions

Finding the right software isn't just a one-stop shop. You'll need to ask the right questions before determining the HR software ...

Workday admits to Black diversity problem, pledges to improve

Workday makes HR tools, including diversity software, for half of the Fortune 100. But Black employees make up less than 3% of ...

Dig Deeper on Oracle and SQL

Big data buzz gets louder with Apache Hadoop and Hive

Implementing SQL Server 2008 FILESTREAM functionality

Converting Long Raw to Blob

SQL Server blob data types for accessing and storing data

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.