SyedMoshiurMurshed_DetailResume My Current Resume!!
Archive for the ‘Uncategorized’ Category
Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!
One interesting things find in oracle (if you are a Sql server developer) is that if I create objects name like MyTable then oracle transform it MYTABLE (upper case). If I want to maintain case then I should use “MyTable”(with double quate). Sometimes It make me confuse. Speciall when create view. Suppose I Create a [...]
When you try to implecit convert integer from a ado.net’ datarow, if database is oracle then it though Invalid casting error. You must use explicit casting with the help of Convert class( Convert.ToInt32()) to convert that.But it is interesting that if your database is SQL Server then it works fine.
Some time it is necessary to convert blob, clob text data to varchar, want to datalenght of blob/clob field. That situation DBMS_LOB packgae can be utilize. Some Example 1. SELECT DBMS_LOB.SUBSTR(CLOB_Field) AS VARCHAR_FIELD FROM AnyTable 2. SELECT DBMS_LOB.LENGTH(CLOB_Field) AS VARCHAR_LENGTH FROm AnyTable I hope It helps.
Working with BLOB type UTL_RAW package is important. ===============================================CREATE TABLE Data(Data BLOB);INSERT INTO Data VALUES (rawtohex(‘hello world’));SELECT UTL_RAW.CAST_TO_VARCHAR2(Data) FROM Data;===============================================Important DateCalculation Function CREATE OR REPLACE FUNCTION DateDiff( p_Interval IN CHAR, p_startDateIn IN TIMESTAMP, p_disconDateIn IN TIMESTAMP ) RETURN NUMBERAS v_duration INTERVAL DAY TO SECOND; v_myDay NUMBER; v_myHour NUMBER; v_myMinute NUMBER; v_mySecond NUMBER; v_totalSeconds NUMBER; v_Value [...]
Sometimes it is requied to support sqlserver & oracle databaes for application. Both database came from different vendors. when you want to compatable both database then some issue you have to solve. 1. First Issue Datatype SQL Server Oracle——————————————————————————————1. TINYINT NUMBER(3)2. SMALLINT NUMBER(6)3. INT NUMBER(10)4. BIGINT NUMBER(19)5. BIT NUMBER(1)6. VARCHAR VARCHAR27. SAMLLDATETIME/DATETIME DATE/TIMESTAMP8. TIMESTAMP TIMESTAMP9. [...]
Listview control is very nice control. But load data is little confusing.Many times I forget, how to Load data in ListView Control. I think many person fell like me.So I need to publish the usage with code sample void LoadErrors(){lvwErrors.Columns.Clear();lvwErrors.Columns.Add(“ErrorCode”);lvwErrors.Columns.Add(“ErrorSource”);lvwErrors.Columns.Add(“ErrorDescription”);lvwErrors.View = View.Details;lvwErrors.Items.Clear();List errors = ErrorManager.GetErrors();ListViewItem item= null;foreach (ErrorObject error in errors){item = new ListViewItem(error.ErrorCode.ToString());item.SubItems.Add(error.ErrorSource);item.SubItems.Add(error.ErrorDescription);lvwErrors.Items.Add(item);}}
