2. How to Execute Query in Database with UiPath | Execute Non Query | Run Command | Run Query UiPath

[@tushar8004]

Thank you for this Video, I need to know how can we connect Oracle SQL Developer database in Uipath

[@MukeshKala]

The steps would be similar , only the provider details would change … you can directly create the connections string and pass it to connect activity as shown in first video

[@tushar8004]

@@MukeshKala Thank you its working

[@lalithharpa]

thank u

[@MukeshKala]

🙏🙏🙏

[@saikumar2990]

In interviews what are challenges faced in projects how to explain rpa uipath interviews please upload one video

[@MukeshKala]

Noted

[@BestChapter]

Hi Mukesh, what if I want to get the updated table printed and tell me the number of records affected also printed?

[@MukeshKala]

You can again re Query the DB with select query and get all the records.

[@vinnu3970]

Hi Mukesh, How can we move data from queue to the data base can u please me with this Thanks in advance....!

[@MukeshKala]

2 Ways to Do it : In Dispatcher : Before you add data to queue , add that data to DataTable and then pass DT to DB. In Perfomer : Read the Data from Queue, add that data to DT and then pass DT to DB.

[@muktharvalli741]

Hi mukesh... I m struggling with batch script... Can you do one video on that

[@MukeshKala]

Sorry Bro , Not an Expert in Batch Script

[@dattakumar6275]

U can get them in Automate with Rakesh channel

[@dattaveeravalli2446]

Hi Mukesh, what is the difference between INSERT And BULK INSERT in database package..... Thanks in Advance

[@MukeshKala]

With Insert Query we get Privileges' to write our own set of query , The Data we intended to insert should not be necessarily same as the table structure . You can specify Joins among table while inserting put condition etc ... Bulk insert is straight Inserting the datatable to the SQL INSERT : kzbin.info/www/bejne/lX6Xfn16pt-SmJY BULK INSERT : kzbin.info/www/bejne/eYGTdX16YrGpZ5I

[@dattaveeravalli2446]

But I will try bulk insert activity in UiPath to insert the data table into the database, but it can't then I will try insert activity.... it works I don't know why, maybe the Joins concept?

[@MukeshKala]

Yes , the schema and the join concert might cause issue

[@oliviergarcin8624]

Hi Mukesh, the syntax @ParameterName doesn't work with a PostgreSQL datatable in an Execute Command or Execute Query activity, could you help us about that ? I found something like : "PREPARE my_query (text, text) AS UPDATE myTable SET Country=$1 WHERE FirstName=$2; EXECUTE my_query('"+strVar1+"','"+strVar2+"');" But still need to use variable and not parameters, so I don't know if this is secured

[@MukeshKala]

Can you try something like below , I haven't tried wth postgres so not very sure UPDATE myTable SET Country = @CountryParam WHERE FirstName = @FirstNameParam;

[@oliviergarcin8624]

@@MukeshKala Hi, it does't work, the postgresql doesn't understand the @

[@iamazeemhayder]

Hello sir, aik bot banana ha sql connect kar k fir query dekar execute karne k bad wo data export karna ha aur fir jo file export ha usko email karna ha...

[@iamazeemhayder]

Par ye na roz karna ha daily file save ho fir send ho email

[@MukeshKala]

Yes , Ye RPA ka use case hai , Roz chalane k liye Bot ko schedule karna padega ... SQL Connect or Query Execution k videos already uplaoded hai ... Email k liye bas hume - Send Mail Message activity use karni hai and we are Done

[@iamazeemhayder]

Aur execute k bad file download kar k email.karne.ha ?

[@iamazeemhayder]

Ok sir mai try karta hon.then apko inform karta hon thx

[@iamazeemhayder]

Thx Sir mane bana liya....