Aashish Chaursiya

What to do if ora 00922 missing or invalid option?

If ora 00922 missing or invalid option- Remove the semicolon at the end of the execute immediate DDL string. Oracle SQL doesn't have statement terminators - semicolons are only used by client tools and the PL/SQL language, and your DDL string is not PL/SQL.This fails due to the unrecognised semicolon character: begin…

SQL Server

Answered Mar 15, 2023 · 6.3K Views Read answer →

What is the sql server materialized view?

For that kind of need, I like to build a SSIS package that will copy the content of the SQL server materialized view to a different SQL DB (on a different instance if I want to make sure their reporting won't hurt the prod DB). You can then schedule the data refresh when you want and you can also create indexes that…

SQL Server

Answered Mar 15, 2023 · 708 Views Read answer →

What should I do if before insert or upsert list must not have two identically equal elements?

before insert or upsert list must not have two identically equal elements- This line of your code: Inventory__c i = new Inventory__c();creates a block of memory that is big enough to hold all the fields of the inventory object and your variable i holds a reference to that memory (its address). As the loop runs, the…

Salesforce

Answered Mar 3, 2023 · 3.5K Views Read answer →

How to get help with Salesforce IF formula?

I think that part of your confusion lies in what a Salesforce IF formula field is. A formula field is something that is computed every time it is accessed from a persisted SObject (i.e. when you query this field via SOQL, or view the field on a Visualforce page, the field value is re-computed). There's nothing that…

Salesforce

Answered Feb 27, 2023 · 1.0K Views Read answer →

How to write a regular expression for Salesforce that will identify regex braces and the text between them

Since backslashes are the escape character in Apex string literals, if you want a literal backlash, you need to escape it with a backslash. So the right regex braces to use would be \{.*\}

Salesforce

Answered Feb 24, 2023 · 725 Views Read answer →

How to work with httpresponse apex?

So, the httpresponse apex you are receiving is a JSON string. You can parse it like this: String json = response.getBody(); Map responseMap = (Map) JSON.deserializeUntyped(json); Then, you can access it like this: Map dataMap = (Map)responseMap.get('data'); String accountNumber = (String)dataMap.get('account_number');

Salesforce

Answered Feb 23, 2023 · 5.2K Views Read answer →

Why is the salesforce gmail extension not working?

This salesforce gmail extension will only work if you're using g suite from memory. Please check chrome extension Overview, which clearly states that this extension works only for corporate Gmail.

Salesforce

Answered Feb 10, 2023 · 887 Views Read answer →

Git Reset To Remote: Reset Local Repository Branch To Be Just Like Remote Repository HEAD

For git reset branch to remote - First, use git reset to reset to the previously fetched HEAD of the corresponding upstream branch: git reset --hard @{u} The advantage of specifying @{u} or its verbose form @{upstream} is that the name of the remote repo and branch don't have to be explicitly specified. On Windows or…

Devops

Answered Nov 23, 2022 · 1.2K Views Read answer →

Which Of The Following Characteristics Is Not True Of Big Data?

The answer to your question - which of the following characteristics about big data is not true? is - The correct answer is option D (can be analysed with traditional spreadsheets). Big data cannot be analysed with traditional spreadsheets or database systems like RDBMS because of the huge volume of data and a variety…

SQL Server

Answered Nov 18, 2022 · 660 Views Read answer →

How can I perform the browser security check?

The EFF Panopticlick online browser uniqueness tester provides lots of details and should work for all types of browser. You can use it for your browser security check. No need to add a plugin to your browser and you should be able to cross reference the version and plugin details for your needs.

Java

Answered Oct 13, 2022 · 702 Views Read answer →

What is a Java hangman game?

Nice code overall, doesn't feel like a beginner. A few points: case for single argument in your normalizeArgs switch can be covered by default branch I don't like your main game loop conditions. Basically the first half compares the number of remaining tries, that effectively means asking if the Java hangman game is…

Java

Answered Oct 12, 2022 · 899 Views Read answer →

Is it safe to use the java out parameter?

First of all, out and ref have nothing to do with each other. An java out parameter in C# is just the only way the language has of returning multiple values from a function, short of creating a new type to use as the return value. Just because it's in the parameter list is only a syntax thing. There's no equivalent in…

Java

Answered Oct 11, 2022 · 2.2K Views Read answer →