The Art of Changing | Confessions of a Pragmatic Intellectual's Mind on The Constant in Life, Change!
Impedance Mismatch problem: O/R issuesSQL: does not work well with large clustersGoogle: BigtableAmazon: Dynamo=> NoSQLOrigin: a Twitter hashtag to advertise a single meeting #nosql non-relational open-source cluster-friendly schema-less when you are getting a price from a row, you are utilizing schema, but when you don’t have schema there is no guarantee data is there 21st…
Have you ever wondered which one to choose if you want constraint(s) to be forced on data? You can achieve your goal by using Triggers or Constraints (or even both). But the questions is which one to choose, and which one is better to use? Shall one go with Constraint all the time or pick…
If you are trying to compare two strings in a stored procedure or trigger or … you need to note that you have to specify the length of the strings before comparison, if you don’t do that, you won’t get the expected result out of your query. Also remember, it is one equal sign not…
You can use any of these commands: SQL> Select name from v$database; SQL> select instance_name from v$instance; SQL> select * from global_name; SQL> SELECT VALUE FROM V$PARAMETER WHERE NAME=’db_name’; SQL> select to_number(translate(substr(version,1,9),’1.$’,’1′)) from v$instance; SQL> select s.machine from v$session s where s.audsid userenv(‘sessionid’); SQL> select global_name from global_name;