Archive for the ‘Oracle’ Category

Droping a table in oracle is very simple task. With just one row of sql statement you can drop a table. For example you want to drop school table in database. Use this simple sql statement, the table will be dropped. Dropping multiple tables If you have multiple tables to drop, trivial way is adding the above row as much as total of tables. How if you have hunderds table   Read More ...

Oracle

String concatenation is joining one or more string to build a new string. Oracle use || to join two string. Above statement will result string semurjengkol. Note, you must use single quote ' to represent a string in oracle or error will be shown. Adding prefix to column result String concatenation can be used to giving a prefix (or suffix) to column result. For example you have person table contains   Read More ...

Oracle

Unlike MySQL, Oracle has not auto_increament attribute when you create a table. In MySQL, we can create table with auto increament column in simple way like this: To insert a row into test table, simply leave blank for id column, MySQL will automatically increse the value on every insert statement. Above statement will resulting: How about auto increament in Oracle. Auto increament in oracle not as simple as in MySQL.   Read More ...

Oracle