Test Your Knowledge in Unix Shell Command By JignaN.

Which Help You To Check or Gain Your Knowledge, Learn or more info receive on Unix Shell Command

Learn Unix Command Which unknown to you using Q&A.

Simultaneously, Learn and Gain Knowledge on UNIX with respect to Topics.

First time, Unix Shell Practice test created and utilized that as much you can.

Gain on how to do things in Unix based on requirement occur.

Part 1 of Test Help you to check Knowledge or receive awareness on Hidden file, searching pattern, exit status, termination, permission, Unix need compilation or not, korn shell etc.

Part 2 of Test Help you on topics like compare file, crontab, sort, silent mode, check empty file etc.

Bored with Video learning have Q&A based learning which make you more experienced and confident on you.   

Gain on how to do things or features of  Unix or Linux based on requirement occur on Unix shell script.

Many Unix Command Q &A which never used in your day to day activities which make you enrich your experience on that.

question with 10 min duration and each practice test passing score 80% w.r.t. topics of  Unix Shell Command which can use any shell.

Gain on how to do things confidently while writing Unix Shell Scripts by your own way or independently whenever any  business requirement occur. 

  Total 28 questions with duration of 30 minutes i.e. each practice test or part contain 14 question with 15 min each.

All the Best !!!

Total Score: 0

Simple BMI Calculator with Detail Report By JignaN.

Demo using Unix Shell Script or Bash



Experience Same Functionality on my blog or Simple #BMI Calculator with Detail Report for users by #JignaN.:

Weight:

Choose Height ( in | cm | ft ) : in cm ft

Height:

Simple BMI Calculator with Height Option By JignaN.

Demo using Unix Shell Script or Bash



Experience Same Functionality on my blog or Simple #BMI Calculator with Height Option made for users by #JignaN.:

Weight:

Choose Height ( in | cm | ft ) : in cm ft

Height:

Simple BMI Calculator By JignaN.

Demo using Unix Shell Script or Bash



Experience Same Functionality on my blog or Simple #BMI Calculator made for users by #JignaN.:

Weight:

Height:

 

All Converter CSV | HTML | JSON | XML etc. using Unix Shell Scripts

Skip to  #CSV, #XML, #HTML, #JSON , Transpose CSV vice versa convert in one utility using #unix #shell #script. Total 10 choice and user friendly just choose choice and give result without using any third party tool.

https://www.youtube.com/watch?v=9XbUvReSHUY

REQUEST NOW

CSV -> HTML Table

Input CSV

Output HTML

REQUEST NOW

CSV -> JSON Format

Input CSV

Output JSON

REQUEST NOW

---

CSV -> XML Format

Input CSV

Output XML

REQUEST NOW

---

Transpose CSV

Input CSV

Output Transpose

REQUEST NOW

---

JSON -> CSV

Input JSON

Output CSV

REQUEST NOW

---

JSON -> XML

Input JSON

Output XML

REQUEST NOW

How To Pass Multiple Values (IN Clause Query) in Stored Procedure of Oracle DB

 

What exactly IN Clause do in Query?

First, We create temporary table with data:

1 2 3 4 5

create table temp_tab(col1 varchar2(100)); insert into temp_tab values('3456'); insert into temp_tab values('5678'); insert into temp_tab values('1234'); select * from temp_tab where col1 IN ('3456','1234');

COL1

3456

1234

As, Observed give the value which exist in table based on value pass multiple way in Where clause.

Did you ever try same query using Stored Procedure? It will not Work as

 For Eg:

1 2 3 4 5 6 7

create or replace procedure sp_temp (p1 in varchar2) as val varchar2(10); begin  select col1 into val from temp_tab where col1 in (p1);  dbms_output.put_line(val); end;

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

exec sp_temp ('1234'); Result: 1234   But, What about multiple value pass? exec sp_temp('1234','3456'); Error:   ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'SP_TEMP'   Means:We can't pass two value as we have one parameter in sp_temp   But, What about multiple value pass in one parameter? exec sp_temp('1234,3456'); Error: ORA-01403: no data found ORA-06512   Means, There is no data exist in our table 1234,3456

How we achieve to understand passing multiple value in parameter and retrieve from table as like simple IN Clause.

Hint:

For that, require to use dynamic SQL in stored procedure

Result:

1 2 3 4 5

exec sp_temp ('1234,3456');   Statement processed. 3456 1234

Solution:

For that, require to request on below button. You will receive solution on same day with session.

REQUEST NOW