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 [cci]school[/cci] table in database. Use this simple sql statement, the table will be dropped. [sourcecode lang=”sql”] DROP TABLE school; [/sourcecode] Dropping multiple tables Read more…
String concatenation is joining one or more string to build a new string. Oracle use [cci]||[/cci] to join two string. [sourcecode lang=”sql”] SELECT ‘semur’ || ‘jengkol’ FROM dual [/sourcecode] Above statement will result string [cci]semurjengkol[/cci]. Note, you must use single quote [cci]'[/cci] to represent a string in oracle or error Read more…
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: [sourcecode lang=”plain”] CREATE TABLE test( id INT primary key auto_increment, name varchar(20) ); [/sourcecode] To insert a row into [cci]test[/cci] table, simply leave Read more…