Entries tagged as Oracle
Store pictures in database
Can you store pictures in database? How? Â Yes , in long Raw datatype. Read More...
Determine the structure of the table DEPT
Give two examples of how you might determine the structure of the table DEPT. Â Use the describe command or use the dbms_metadata.get_ddl package. Read More...
Difference between a data block, an extent and a segment
Explain the difference between a data block, an extent and a segment. Â A data block is the smallest unit of logical storage for a database object. As objects grow they take chunks of additional storage that are composed of contiguous data blocks. These groupings of contiguous data blocks are called extents. All the extents Read More...
Switch from an init.ora file to a spfile
How do you switch from an init.ora file to a spfile? Â Issue the create spfile from pfile command. Read More...