To extract date parts in PL/SQL you can use the TO_CHAR function. For example, you can get the month number from a date value with the following expression TO_CHAR(date_value, 'mm');. There is better approach. You can use the EXTRACT function to get the date part you need. Read the rest of this entry »
You can use the ALTER TABLE command to rename tables in Oracle Database. Read the rest of this entry »
Oracle database control administrators can create other database control administrators, configure e-mail and other notification methods, control alert thresholds for database metrics, select database policies to apply, define maintenance periods (blackouts). Read the rest of this entry »
Problem: You want to create a user that can access the Oracle Database Administrative console. For example, it might be required that the user login to the Oracle Enterprise Manage and monitor the database. Read the rest of this entry »
We can specify the font, with which the text to be displayed. Read the rest of this entry »
We can style text with CSS for a lot of time. So there is no big reason to continue to use the tag to style text. Instead of this deprecated tag we could easily use CSS. Read the rest of this entry »
Problem
To use CSS to apply styles to HTML document is a very good practice. But how to select more accurately different parts of a HTML document and how to apply different properties to HTML of the same type ?
To solve this problem to our help come the CSS selectors. Read the rest of this entry »
Problem
How to join together two strings and how to make one long string from numerous pieces?
Read the rest of this entry »
Temporary tables in Oracle database can be very useful tool. How to create temporary tables was described in another posting Using Temporary Tables in Oracle Database. Sometimes you need to remove existing temporary table. When you issue a DROP TABLE command you can get an error “ORA-14452: attempt to create, alter or drop an index on temporary table already in use”. Read the rest of this entry »
Temporary tables can be used to store intermediate results for complicated queries. This technique can result in stunning performance improvements. Here is how you can create temporary table in Oracle. Read the rest of this entry »
