Here is a sample sub-query. Here you will read records from two tables. Also explained how the query works.
Author: Srini
Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.
Here are steps of how to create a procedure in SQL developer and how to call it.
Here are 13 essential python interview questions useful to crack your interview.
Sample Python script to calculate the sum of the GP series. Knowing the skills applied to write this script useful for interviews.
Here’s a python program that reverses the name you enter and prints it in reverse order. This is useful for interviews.
Here is a shell script to calculate the sum of input file records. And to replace a string with a new one using sed utility.
JSON files are popular in message interchange. Here is sample python logic on how to write JSON data to a file using the dump function
Here are the best examples of how to use sed utility to search and replace. These examples explain how to replace a string with your choice.
Here’s a sample Explain plan query to find statistics of the execution plan. Useful for SQL and Data warehousing developers.
In Bash shell (or any other) you can include a script in another script. Here is best example of how you can do it. Also, I have explained the reasons of why you need it.
Check and Default constraints are both not the same. They create during create Table. Differences between these you can understand with these examples.
Loops and iterators are two unique concepts. But the outcome is the same. Here are details explained with simple examples.
Srinimf 
You must be logged in to post a comment.