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.
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
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.
Friday, October 21, 2011
Thursday, October 20, 2011
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 Output and Execution
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