No Picture

Blobbing Data With PHP and MySQL

June 8, 2010 mohancheema 0


Blobbing Data With PHP and MySQL

Databases can be used for storing large amounts of binary data, known as BLOB’s. These BLOB’s can store just about any type of data imaginable, including MS Word documents, GIF/JPEG images, PDF files, MP3’s, etc. In this article we will see how to create a binary file repository using PHP and MySQL that can store and retrieve several different file types.

No Picture

How to Show the Schema in Oracle

May 6, 2010 mohancheema 0

I continuously forget the syntax for this (doesn’t help that it’s different in every database engine):

select table_name from user_tables;

Shows all user tables. You can also do:

select owner,table_name from all_tables;

which shows all tables.

To see what a particular table looks like, you can do: