�ݺ�ߣshows by User: lpalanisamy

�ݺ�ߣshows by User: lpalanisamy / http://www.slideshare.net/images/logo.gif �ݺ�ߣshows by User: lpalanisamy / Mon, 03 Nov 2014 23:03:54 GMT �ݺ�ߣShare feed for �ݺ�ߣshows by User: lpalanisamy SQL for pattern matching (Oracle 12c) /slideshow/sql-for-pattern-matching-oracle-12c/41084858 sqlforpatternmatching-141103230354-conversion-gate01
Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. Beginning in Oracle Database 12c, you can use the MATCH_RECOGNIZE clause to achieve this capability in native SQL that executes efficiently. This presentation discusses how to do this.]]>
Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. Beginning in Oracle Database 12c, you can use the MATCH_RECOGNIZE clause to achieve this capability in native SQL that executes efficiently. This presentation discusses how to do this.]]> Mon, 03 Nov 2014 23:03:54 GMT /slideshow/sql-for-pattern-matching-oracle-12c/41084858 lpalanisamy@slideshare.net(lpalanisamy) SQL for pattern matching (Oracle 12c) lpalanisamy Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. Beginning in Oracle Database 12c, you can use the MATCH_RECOGNIZE clause to achieve this capability in native SQL that executes efficiently. This presentation discusses how to do this. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sqlforpatternmatching-141103230354-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds" /> Recognizing patterns in a sequence of rows has been a capability that was widely desired, but not possible with SQL until now. There were many workarounds, but these were difficult to write, hard to understand, and inefficient to execute. Beginning in Oracle Database 12c, you can use the MATCH_RECOGNIZE clause to achieve this capability in native SQL that executes efficiently. This presentation discusses how to do this.

SQL for pattern matching (Oracle 12c) from Logan Palanisamy

]]> 2315 5 https://cdn.slidesharecdn.com/ss_thumbnails/sqlforpatternmatching-141103230354-conversion-gate01-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Regular expressions in oracle /slideshow/regular-expressions-in-oracle/12854707 regularexpressionsinoracle-120508161259-phpapp02
Oracle database supports perl- and POSIX-compatible regular expressions with five elegant and powerful functions: REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_LIKE, and REGEXP_COUNT. This session will demonstrate their nuances and how to use them effectively for data cleansing, manipulation and selection, for validating things such as Social Security Numbers, credit cards, IP addresses, phone numbers, DNAs, XMLs, for extracting things such as email-ids, hostnames from URLs and strings, and for transposing delimited columns to rows. There will be a demo of a few tricky examples taken from forums.oracle.com and asktom.oracle.com. The session will end with fuzzy matching and optimization techniques, and things to watch out for. http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_regexp.htm ]]>
Oracle database supports perl- and POSIX-compatible regular expressions with five elegant and powerful functions: REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_LIKE, and REGEXP_COUNT. This session will demonstrate their nuances and how to use them effectively for data cleansing, manipulation and selection, for validating things such as Social Security Numbers, credit cards, IP addresses, phone numbers, DNAs, XMLs, for extracting things such as email-ids, hostnames from URLs and strings, and for transposing delimited columns to rows. There will be a demo of a few tricky examples taken from forums.oracle.com and asktom.oracle.com. The session will end with fuzzy matching and optimization techniques, and things to watch out for. http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_regexp.htm ]]> Tue, 08 May 2012 16:12:56 GMT /slideshow/regular-expressions-in-oracle/12854707 lpalanisamy@slideshare.net(lpalanisamy) Regular expressions in oracle lpalanisamy Oracle database supports perl- and POSIX-compatible regular expressions with five elegant and powerful functions: REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_LIKE, and REGEXP_COUNT. This session will demonstrate their nuances and how to use them effectively for data cleansing, manipulation and selection, for validating things such as Social Security Numbers, credit cards, IP addresses, phone numbers, DNAs, XMLs, for extracting things such as email-ids, hostnames from URLs and strings, and for transposing delimited columns to rows. There will be a demo of a few tricky examples taken from forums.oracle.com and asktom.oracle.com. The session will end with fuzzy matching and optimization techniques, and things to watch out for. http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_regexp.htm <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/regularexpressionsinoracle-120508161259-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> Oracle database supports perl- and POSIX-compatible regular expressions with five elegant and powerful functions: REGEXP_REPLACE, REGEXP_SUBSTR, REGEXP_INSTR, REGEXP_LIKE, and REGEXP_COUNT. This session will demonstrate their nuances and how to use them effectively for data cleansing, manipulation and selection, for validating things such as Social Security Numbers, credit cards, IP addresses, phone numbers, DNAs, XMLs, for extracting things such as email-ids, hostnames from URLs and strings, and for transposing delimited columns to rows. There will be a demo of a few tricky examples taken from forums.oracle.com and asktom.oracle.com. The session will end with fuzzy matching and optimization techniques, and things to watch out for. http://docs.oracle.com/cd/E11882_01/appdev.112/e25518/adfns_regexp.htm

Regular expressions in oracle from Logan Palanisamy

]]> 3674 8 https://cdn.slidesharecdn.com/ss_thumbnails/regularexpressionsinoracle-120508161259-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation Black http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Analytic & Windowing functions in oracle /slideshow/analytic-windowing-functions-in-oracle/12854568 analyticfunctionsinoracle-120508160143-phpapp02
Are you an Oracle developer or a DBA? Do you know the difference between aggregate and analytic functions? Without complex sub-queries or self-joins, do you know how to: Calculate running/cumulative totals and moving/centered averages? List products with revenues above or below their peers or product groups? Compute the ratio of one category’s sales to the total sales? Select the Top-N or Top N % of the customers/products? Classify advertisers into quartiles/n-tiles based on the revenue potential? Compare period-over-period (year-over-year, month-over-month) growth and rank advancement? Convert rows into columns (pivot), columns into rows (unpivot) or aggregate strings? Perform what-if analysis and hypothetical ranking? Analytic functions are more performant because tables need to be scanned only once. They make you more productive because there is no need to write procedural code. No wonder Tom Kyte, a well-respected Oracle guru, says analytic functions are the best thing to happen after the sliced bread. In the first half, I will cover the basics of the various analytic functions: Ranking: RANK, DENSE_RANK, ROW_NUMBER, NTILE, CUME_DIST, PERCENTILE_RANK Windowing: SUM, AVG, MAX, MIN, FIRST_VALUE, LAST_VALUE Reporting: RATIO_TO_REPORT Others: FIRST/LAST, LEAD/LAG, hypothetical ranking, In the second half, I will show how powerful these functions are with a few examples. If there is time, I will cover enhanced aggregation (ROLLUP, CUBE, GROUPING SET extensions to GROUP BY clause) This class would be useful for both developers and DBAs alike, especially for those working in Analytic, Business Intelligence, and Datawarehouse environments. Are you already an expert in analytic functions? Then come and help me refine the content. For more info, read http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/analysis.htm http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/aggreg.htm rollup, cross-tabulation across different dimensions using ROLLUP, CUBE and GROUPING SETS extension to GROUP BY clause , most active time-periods (i.e. days when the most number of tickets are open in BZ, hours with the most take-off and landings, months with the highest sales, 5-minute periods with the maximum number of calls made, etc) data densification? their rank last year, this year, rank growth, running/cumulative total (Year-To-Date/Month-To-Date summation), moving averages, Year-Over-Year comparison, sales projection, average/min/max time between one sale and the next sale, products with above and below average sales. overall average, sum, departmental average, sum, ranking, job wise ranking in one SQL. ]]>
Are you an Oracle developer or a DBA? Do you know the difference between aggregate and analytic functions? Without complex sub-queries or self-joins, do you know how to: Calculate running/cumulative totals and moving/centered averages? List products with revenues above or below their peers or product groups? Compute the ratio of one category’s sales to the total sales? Select the Top-N or Top N % of the customers/products? Classify advertisers into quartiles/n-tiles based on the revenue potential? Compare period-over-period (year-over-year, month-over-month) growth and rank advancement? Convert rows into columns (pivot), columns into rows (unpivot) or aggregate strings? Perform what-if analysis and hypothetical ranking? Analytic functions are more performant because tables need to be scanned only once. They make you more productive because there is no need to write procedural code. No wonder Tom Kyte, a well-respected Oracle guru, says analytic functions are the best thing to happen after the sliced bread. In the first half, I will cover the basics of the various analytic functions: Ranking: RANK, DENSE_RANK, ROW_NUMBER, NTILE, CUME_DIST, PERCENTILE_RANK Windowing: SUM, AVG, MAX, MIN, FIRST_VALUE, LAST_VALUE Reporting: RATIO_TO_REPORT Others: FIRST/LAST, LEAD/LAG, hypothetical ranking, In the second half, I will show how powerful these functions are with a few examples. If there is time, I will cover enhanced aggregation (ROLLUP, CUBE, GROUPING SET extensions to GROUP BY clause) This class would be useful for both developers and DBAs alike, especially for those working in Analytic, Business Intelligence, and Datawarehouse environments. Are you already an expert in analytic functions? Then come and help me refine the content. For more info, read http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/analysis.htm http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/aggreg.htm rollup, cross-tabulation across different dimensions using ROLLUP, CUBE and GROUPING SETS extension to GROUP BY clause , most active time-periods (i.e. days when the most number of tickets are open in BZ, hours with the most take-off and landings, months with the highest sales, 5-minute periods with the maximum number of calls made, etc) data densification? their rank last year, this year, rank growth, running/cumulative total (Year-To-Date/Month-To-Date summation), moving averages, Year-Over-Year comparison, sales projection, average/min/max time between one sale and the next sale, products with above and below average sales. overall average, sum, departmental average, sum, ranking, job wise ranking in one SQL. ]]> Tue, 08 May 2012 16:01:41 GMT /slideshow/analytic-windowing-functions-in-oracle/12854568 lpalanisamy@slideshare.net(lpalanisamy) Analytic & Windowing functions in oracle lpalanisamy Are you an Oracle developer or a DBA? Do you know the difference between aggregate and analytic functions? Without complex sub-queries or self-joins, do you know how to: Calculate running/cumulative totals and moving/centered averages? List products with revenues above or below their peers or product groups? Compute the ratio of one category’s sales to the total sales? Select the Top-N or Top N % of the customers/products? Classify advertisers into quartiles/n-tiles based on the revenue potential? Compare period-over-period (year-over-year, month-over-month) growth and rank advancement? Convert rows into columns (pivot), columns into rows (unpivot) or aggregate strings? Perform what-if analysis and hypothetical ranking? Analytic functions are more performant because tables need to be scanned only once. They make you more productive because there is no need to write procedural code. No wonder Tom Kyte, a well-respected Oracle guru, says analytic functions are the best thing to happen after the sliced bread. In the first half, I will cover the basics of the various analytic functions: Ranking: RANK, DENSE_RANK, ROW_NUMBER, NTILE, CUME_DIST, PERCENTILE_RANK Windowing: SUM, AVG, MAX, MIN, FIRST_VALUE, LAST_VALUE Reporting: RATIO_TO_REPORT Others: FIRST/LAST, LEAD/LAG, hypothetical ranking, In the second half, I will show how powerful these functions are with a few examples. If there is time, I will cover enhanced aggregation (ROLLUP, CUBE, GROUPING SET extensions to GROUP BY clause) This class would be useful for both developers and DBAs alike, especially for those working in Analytic, Business Intelligence, and Datawarehouse environments. Are you already an expert in analytic functions? Then come and help me refine the content. For more info, read http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/analysis.htm http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/aggreg.htm rollup, cross-tabulation across different dimensions using ROLLUP, CUBE and GROUPING SETS extension to GROUP BY clause , most active time-periods (i.e. days when the most number of tickets are open in BZ, hours with the most take-off and landings, months with the highest sales, 5-minute periods with the maximum number of calls made, etc) data densification? their rank last year, this year, rank growth, running/cumulative total (Year-To-Date/Month-To-Date summation), moving averages, Year-Over-Year comparison, sales projection, average/min/max time between one sale and the next sale, products with above and below average sales. overall average, sum, departmental average, sum, ranking, job wise ranking in one SQL. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/analyticfunctionsinoracle-120508160143-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> Are you an Oracle developer or a DBA? Do you know the difference between aggregate and analytic functions? Without complex sub-queries or self-joins, do you know how to: Calculate running/cumulative totals and moving/centered averages? List products with revenues above or below their peers or product groups? Compute the ratio of one category’s sales to the total sales? Select the Top-N or Top N % of the customers/products? Classify advertisers into quartiles/n-tiles based on the revenue potential? Compare period-over-period (year-over-year, month-over-month) growth and rank advancement? Convert rows into columns (pivot), columns into rows (unpivot) or aggregate strings? Perform what-if analysis and hypothetical ranking? Analytic functions are more performant because tables need to be scanned only once. They make you more productive because there is no need to write procedural code. No wonder Tom Kyte, a well-respected Oracle guru, says analytic functions are the best thing to happen after the sliced bread. In the first half, I will cover the basics of the various analytic functions: Ranking: RANK, DENSE_RANK, ROW_NUMBER, NTILE, CUME_DIST, PERCENTILE_RANK Windowing: SUM, AVG, MAX, MIN, FIRST_VALUE, LAST_VALUE Reporting: RATIO_TO_REPORT Others: FIRST/LAST, LEAD/LAG, hypothetical ranking, In the second half, I will show how powerful these functions are with a few examples. If there is time, I will cover enhanced aggregation (ROLLUP, CUBE, GROUPING SET extensions to GROUP BY clause) This class would be useful for both developers and DBAs alike, especially for those working in Analytic, Business Intelligence, and Datawarehouse environments. Are you already an expert in analytic functions? Then come and help me refine the content. For more info, read http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/analysis.htm http://download.oracle.com/docs/cd/E11882_01/server.112/e16579/aggreg.htm rollup, cross-tabulation across different dimensions using ROLLUP, CUBE and GROUPING SETS extension to GROUP BY clause , most active time-periods (i.e. days when the most number of tickets are open in BZ, hours with the most take-off and landings, months with the highest sales, 5-minute periods with the maximum number of calls made, etc) data densification? their rank last year, this year, rank growth, running/cumulative total (Year-To-Date/Month-To-Date summation), moving averages, Year-Over-Year comparison, sales projection, average/min/max time between one sale and the next sale, products with above and below average sales. overall average, sum, departmental average, sum, ranking, job wise ranking in one SQL.

Analytic & Windowing functions in oracle from Logan Palanisamy

]]> 4516 10 https://cdn.slidesharecdn.com/ss_thumbnails/analyticfunctionsinoracle-120508160143-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 vim - Tips and_tricks /slideshow/vim-tips-andtricks/12854378 vimtipsandtricks-120508154926-phpapp01
vim is the "improved" version of the popular "vi" editor in UNIX/Linux environments. With this powerful editor, do you know how to: delete lines between two different search strings, repetitively? replace multiple spaces with a single space OR trim all the leading or trailing spaces? convert to upper/lower case, title/sentence case, to toggle case? edit many files with multiple windows or tabs, and execute the same command on all at the same time? delete blank lines or replace multiple blanks lines with one line? search and replace with back referencing, and regular expressions? identify palindromes, repeating words? format lines (center-, left-, right-align) like you do in MS Word, but only lines that meet certain conditions? go back to previous version as of N versions/seconds/minutes/hours ago even after saving with :w? In this three-hour class, you will learn how to use vim effectively with shortcuts, markers, regular expressions, substitutions, grouping and back referencing, mapping, non-volatile buffers, recalling the nth delete, recording and replaying with macros, batching, and customizations. Concepts will be explained with demos. You will come away knowing how to simplify mundane editing tasks and become more productive. ]]>
vim is the "improved" version of the popular "vi" editor in UNIX/Linux environments. With this powerful editor, do you know how to: delete lines between two different search strings, repetitively? replace multiple spaces with a single space OR trim all the leading or trailing spaces? convert to upper/lower case, title/sentence case, to toggle case? edit many files with multiple windows or tabs, and execute the same command on all at the same time? delete blank lines or replace multiple blanks lines with one line? search and replace with back referencing, and regular expressions? identify palindromes, repeating words? format lines (center-, left-, right-align) like you do in MS Word, but only lines that meet certain conditions? go back to previous version as of N versions/seconds/minutes/hours ago even after saving with :w? In this three-hour class, you will learn how to use vim effectively with shortcuts, markers, regular expressions, substitutions, grouping and back referencing, mapping, non-volatile buffers, recalling the nth delete, recording and replaying with macros, batching, and customizations. Concepts will be explained with demos. You will come away knowing how to simplify mundane editing tasks and become more productive. ]]> Tue, 08 May 2012 15:49:25 GMT /slideshow/vim-tips-andtricks/12854378 lpalanisamy@slideshare.net(lpalanisamy) vim - Tips and_tricks lpalanisamy vim is the "improved" version of the popular "vi" editor in UNIX/Linux environments. With this powerful editor, do you know how to: delete lines between two different search strings, repetitively? replace multiple spaces with a single space OR trim all the leading or trailing spaces? convert to upper/lower case, title/sentence case, to toggle case? edit many files with multiple windows or tabs, and execute the same command on all at the same time? delete blank lines or replace multiple blanks lines with one line? search and replace with back referencing, and regular expressions? identify palindromes, repeating words? format lines (center-, left-, right-align) like you do in MS Word, but only lines that meet certain conditions? go back to previous version as of N versions/seconds/minutes/hours ago even after saving with :w? In this three-hour class, you will learn how to use vim effectively with shortcuts, markers, regular expressions, substitutions, grouping and back referencing, mapping, non-volatile buffers, recalling the nth delete, recording and replaying with macros, batching, and customizations. Concepts will be explained with demos. You will come away knowing how to simplify mundane editing tasks and become more productive. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/vimtipsandtricks-120508154926-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds" /> vim is the "improved" version of the popular "vi" editor in UNIX/Linux environments. With this powerful editor, do you know how to: delete lines between two different search strings, repetitively? replace multiple spaces with a single space OR trim all the leading or trailing spaces? convert to upper/lower case, title/sentence case, to toggle case? edit many files with multiple windows or tabs, and execute the same command on all at the same time? delete blank lines or replace multiple blanks lines with one line? search and replace with back referencing, and regular expressions? identify palindromes, repeating words? format lines (center-, left-, right-align) like you do in MS Word, but only lines that meet certain conditions? go back to previous version as of N versions/seconds/minutes/hours ago even after saving with :w? In this three-hour class, you will learn how to use vim effectively with shortcuts, markers, regular expressions, substitutions, grouping and back referencing, mapping, non-volatile buffers, recalling the nth delete, recording and replaying with macros, batching, and customizations. Concepts will be explained with demos. You will come away knowing how to simplify mundane editing tasks and become more productive.

vim - Tips and_tricks from Logan Palanisamy

]]> 2196 3 https://cdn.slidesharecdn.com/ss_thumbnails/vimtipsandtricks-120508154926-phpapp01-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Sed tips and_tricks /slideshow/sed-tips-andtricks/12853983 sedtipsandtricks-120508151552-phpapp02
sed, known as the “streams editor”, is a powerful tool for text manipulation on UNIX systems. Unlike vim, sed can operate on files of limitless size. The session will cover some of the intermediate concepts such as grouping and back referencing, regular expressions, replacing the nth occurrence of a pattern, operation on every nth line and so on. We will spice up the session with a few “sed one-liners/idioms”]]>
sed, known as the “streams editor”, is a powerful tool for text manipulation on UNIX systems. Unlike vim, sed can operate on files of limitless size. The session will cover some of the intermediate concepts such as grouping and back referencing, regular expressions, replacing the nth occurrence of a pattern, operation on every nth line and so on. We will spice up the session with a few “sed one-liners/idioms”]]> Tue, 08 May 2012 15:15:48 GMT /slideshow/sed-tips-andtricks/12853983 lpalanisamy@slideshare.net(lpalanisamy) Sed tips and_tricks lpalanisamy sed, known as the “streams editor”, is a powerful tool for text manipulation on UNIX systems. Unlike vim, sed can operate on files of limitless size. The session will cover some of the intermediate concepts such as grouping and back referencing, regular expressions, replacing the nth occurrence of a pattern, operation on every nth line and so on. We will spice up the session with a few “sed one-liners/idioms” <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/sedtipsandtricks-120508151552-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> sed, known as the “streams editor”, is a powerful tool for text manipulation on UNIX systems. Unlike vim, sed can operate on files of limitless size. The session will cover some of the intermediate concepts such as grouping and back referencing, regular expressions, replacing the nth occurrence of a pattern, operation on every nth line and so on. We will spice up the session with a few “sed one-liners/idioms”

Sed tips and_tricks from Logan Palanisamy

]]> 1108 3 https://cdn.slidesharecdn.com/ss_thumbnails/sedtipsandtricks-120508151552-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 Awk essentials /slideshow/awk-essentials-12853930/12853930 awkessentials-120508151057-phpapp02
awk is a very versatile programming language for working on text files. It is more powerful than sed but less complex than C. It is an excellent filter and report writer. In this class I will go over the elements and features of gawk, (the Free Software foundation version of awk), examples and a few one-liners.]]>
awk is a very versatile programming language for working on text files. It is more powerful than sed but less complex than C. It is an excellent filter and report writer. In this class I will go over the elements and features of gawk, (the Free Software foundation version of awk), examples and a few one-liners.]]> Tue, 08 May 2012 15:10:55 GMT /slideshow/awk-essentials-12853930/12853930 lpalanisamy@slideshare.net(lpalanisamy) Awk essentials lpalanisamy awk is a very versatile programming language for working on text files. It is more powerful than sed but less complex than C. It is an excellent filter and report writer. In this class I will go over the elements and features of gawk, (the Free Software foundation version of awk), examples and a few one-liners. <img style="border:1px solid #C3E6D8;float:right;" alt="" src="https://cdn.slidesharecdn.com/ss_thumbnails/awkessentials-120508151057-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds" /> awk is a very versatile programming language for working on text files. It is more powerful than sed but less complex than C. It is an excellent filter and report writer. In this class I will go over the elements and features of gawk, (the Free Software foundation version of awk), examples and a few one-liners.

Awk essentials from Logan Palanisamy

]]> 2960 4 https://cdn.slidesharecdn.com/ss_thumbnails/awkessentials-120508151057-phpapp02-thumbnail.jpg?width=120&height=120&fit=bounds presentation White http://activitystrea.ms/schema/1.0/post

http://activitystrea.ms/schema/1.0/posted

0 https://public.slidesharecdn.com/v2/images/profile-picture.png https://cdn.slidesharecdn.com/ss_thumbnails/sqlforpatternmatching-141103230354-conversion-gate01-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/sql-for-pattern-matching-oracle-12c/41084858 SQL for pattern matchi... https://cdn.slidesharecdn.com/ss_thumbnails/regularexpressionsinoracle-120508161259-phpapp02-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/regular-expressions-in-oracle/12854707 Regular expressions in... https://cdn.slidesharecdn.com/ss_thumbnails/analyticfunctionsinoracle-120508160143-phpapp02-thumbnail.jpg?width=320&height=320&fit=bounds slideshow/analytic-windowing-functions-in-oracle/12854568 Analytic & Windowing f...