Author Archives: Hiren Kubavat

About Hiren Kubavat

PHP Developer

What is ETL in Sql ?

What is ETL: ETL stands for Extract, Transform, Load. Extract means to read data from source, Transform means to apply business logic on data & in last load means to add or load data on other server. ETL (Extract, Transform … Continue reading

Posted in oracle, sql | Leave a comment

How do I find duplicate values in a table in Oracle?

To find duplicate value we need the sql group by & having clause as below. SELECT V.FIELD_NAME1, COUNT(*) FROM TABLE_NAME V GROUP BY V.FIELD_NAME1 HAVING COUNT(*)>1 How query works? First it will group the same value by non-clustered index i.e. virtual … Continue reading

Posted in oracle, sql | Tagged | Leave a comment

What is clustered & non-clustered index in oracle?

Clustered index & Non-clustered index A clustered index the table records are physically stored on the basic of that index, A table can have only one clustered index because of physically stored to the table. A Non-clustered index that is … Continue reading

Posted in oracle, sql | Tagged , | Leave a comment

What is Agile methodology? Examples, when to use it, advantages and disadvantages

Agile software development methodology is an process for developing software (like other software development methodologies – Waterfall model, V-Model, Iterative model etc.) However, Agile methodology differs significantly from other methodologies. In English, Agile means ‘ability to move quickly and easily’ and responding swiftly to change – this is … Continue reading

Posted in PHP | Tagged , | Leave a comment

How to get table size in MB oracle ?

select segment_name,segment_type,bytes/1024/1024 MB from dba_segments where segment_type=’TABLE’ and lower(segment_name)=’your_table_name’;

Posted in oracle, sql | Tagged | Leave a comment

SQL Optimization Techniques

Optimize access structures: Database design and normalization. Tables: heap or index-organized tables, and table or indexed clusters. Indexes. Constraints. Materialized views. Partitioning schemes. Statistics, including a comprehensive refresh strategy. Rewrite SQL statements: Exclude projections that are not required. Minimize the … Continue reading

Posted in MysQl | Tagged , , , | Leave a comment

How to identify user idle state by minutes using javascript / JQuery?

Descrption: i used with 20 minute of interval if user is in idle state from last 20 minute then it will call the timerIncrement() and then will check for 20 minutes if yes or not. Why i need this? i … Continue reading

Posted in angular-4, Javascript, jQuery | Tagged , , , , | Leave a comment