1. install react-bootstrap-icons dependency
npm i react-bootstrap-icons

2. Navigate to the website : https://icons.getbootstrap.com/#usage

to see all the icons that we can use

3. Let say we wants to use the icon called as trash

so lets see how we can use this in our component

  • here we have imported the icon that we need like “trash”
  • and then we added it as a componentt
  • we can give any color , size and we can send it as a prop in the component.
import React from ‘react’import { Trash } from ‘react-bootstrap-icons’import { PencilSquare } from ‘react-bootstrap-icons’function milestone() {return (<div><PencilSquare size={35} /><Trash size={35} /></div>)}export default milestone

--

--

Query all the records from the table substitute_details

select * from SUBSTITUTE_DETAIL where user_id=’userid’;
  • Query records from the substitute_details table where user_id =123 and application key is default means multiple conditions in where clause

select * from SUBSTITUTE_DETAIL where user_id=’123’ and application_key=’default’ ;

  • Query to update the date using SQL in Oracle database
update TABLE_NAME
SET START_DATE=TO_DATE(‘06/07/2021’, ‘DD/MM/YYYY’), END_DATE=TO_DATE(‘07/07/2021’, ‘DD/MM/YYYY’)
WHERE USER_ID=’userID’ AND APPLICATION_KEY=’default’;
  • Get all the columns from the table Substitute_Details with the type of each column .
select * from ALL_TAB_COLUMNS 
where
table_name=’SUBSTITUTE_DETAIL’;
UPDATE PASOFDATE SET ASOFDATE = TO_DATE('11/21/2012', 'MM/DD/YYYY');

--

--

Use the below-mentioned settings when you are using some local proxy like cntlm or any other in windows.

In VS Code open File->Preferences->User Settings

Copy HTTP configuration from default settings to settings.json

Change the HTTP configuration as follows:

{
...
"http.proxy": "http://127.0.0.1:3128",
...
}

The file is located in C:\Users\<your_username>\AppData\Roaming\Code\User\settings.json

--

--

  • Approach 1 : Recursion, this one is comparatively easy
public static  int  printFibonacciNthRecursion(int n) {


if(n==1)
return 0;
if(n==2)
return 1;
return printFibonacciNthRecursion(n-1)+printFibonacciNthRecursion(n-2); }
  • Approach 2: Iteration: here we have used two variables first and second after each iteration , first will store value of second and second will store result value.
public static int printNthFibonacci(int n) {        if(n==1) 
return 0;
if(n==2)
return 1;
int first=0;
int second =1;
int result=0;
for(int i=3;i<=n;i++) {
result=first+second;
first=second;
second=result;
}
return result;
}

--

--