Bahamas - An immense beauty and Beautiful place to Live

The word Bahamas is of Spanish decent and means 'Shallow Water'. The Bahamas which is officially named The Commonwealth of The Bahamas, is an archipelago consisting of about 1200 islands including the cays.

When Christopher Columbus first arrived in the West Indies in 1492, he landed on a Bahamian island which he named San Salvador. The island now presently known as San Salvador (formerly called Watling Island) has long been thought to be the island where Columbus landed. But in truth, historians do not agree on the exact site of the landing. The possibility narrows between two islands: San Salvador itself and Samana Cay, about 80 miles southeast.

The main islands of Bahamas are:

1) New Providence (Nassau, Paradise Island)
Dominated by the capital Nassau, and paired with smaller Paradise Island, home to the gigantic Atlantis casino resort.

2) Grand Bahama
An ecological playground featuring an underwater limestone cave system. The centre of eco-tourism, offering nature tours, national parks and botanical gardens.

3) Bimini

4) Abacos

5) Eleuthera

6) Andros

7) Exuma

8) Long Island

9) Cat Island

10) Berry Islands

11) San Salvador Island: May have been the first landfall of Columbus.

12) Acklins Island / Crooked Island

13) Inagua

14) Mayaguana

Here goes the complete map of total Bahamas Island.

Here I want to post some of the beautiful Bahamas Homes, Condos, Resorts of Bahamas Real Estate. Also I want to post some photos of Bahamian lifestyle, Food, Dining etc. Thanks to http://bahamasbahamasbahamas.com/ and http://resortbahamas.com/ for providing me the photos of the Bahamas.

How to create a trigger which will fire on DROP or TRUNCATE table

This article will show you step by step procedure about how to create a trigger that fires before a DROP or TRUNCATE statement, but not for a whole schema, only for a particular table in a schema. So, you can use this trigger to track individual table under a schema.

Trigger Codes:

conn arju/a

create or replace trigger no_drop_arjut
 before drop or truncate 
 on schema 
 WHEN (ora_dict_obj_name = 'ARJUT' AND ora_dict_obj_type = 'TABLE') 
 begin 
 RAISE_APPLICATION_ERROR(-20001,'Sorry Cannot Drop or Truncate Table ARJUT'); 
 end; 
 / 

Trigger Output and Execution

C:\Documents and Settings\User>sqlplus arju/a

SQL*Plus: Release 10.2.0.3.0 - Production on Thu Oct 20 15:29:45 2011

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> create table arjut(a number);

Table created.

SQL> create or replace trigger no_drop_arjut
  2   before drop or truncate
  3   on schema
  4   WHEN (ora_dict_obj_name = 'ARJUT' AND ora_dict_obj_type = 'TABLE')
  5   begin
  6   RAISE_APPLICATION_ERROR(-20001,'Sorry Cannot Drop or Truncate Table ARJUT');
  7   end;
  8   /

Trigger created.

SQL> drop table arjut;
drop table arjut
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-20001: Sorry Cannot Drop or Truncate Table ARJUT
ORA-06512: at line 2