Seems there are lots of ways of doing this, but this worked for me (on an Oracle DB). It returns the size of the database table in megabytes:
select bytes/1024/1024 from user_segments where segment_name='<table_name>'