FUNCTIONS – INTRODUCTION Look at this following sequels select Upper. This is a test from Dual has converted the string to an all uppercase string. Select Sqrt 36 from Dual has given us the square root of 36, which is six. So what is this upper and square root? These are functions provided by Oracle. Functions are nothing but programs supplied by Oracle that does a certain operation on the input and gives an output. Now, do I need to know the programming code behind upper R square root not…

BASICS OF A JOIN – CARTESIAN PRODUCT OR CROSS JOIN We have been reading data from one table. However, often a database developer would be required to fetch data from multiple tables. To do that, those tables need to be joined in the sequel. Let us look at the basics of a join. Here we have two tables called tab one and tab two. Tab one has has two columns, call one and call two. Tab two has two columns, call three and call four. And the data is like…

NULL – DEFAULT Create table cons one call, one number. Let me query it. As expected, it doesn’t have any rows. Now, let me insert a null value. I can do it by just specifying two single quotes. Query it. We see the null value here. What this means is, while creating a table, if we just specify the column name and its data type, by default it accepts null values. Now, let me insert a number. I know it is a numerical column. Verify it. We see the null…

CONDITIONAL FUNCTIONS – NVL, NVL2 and NULLIF Circle provides functions which act only if certain conditions are met. Let us take a look at this SQL. This is a simple sequel. We see some null values in the state province column. Instead of displaying as null, I can display it as another string using NVL function NVL state province not applicable. Replaces null values with not applicable string. That’s the condition. If there are null values, then display them as not applicable. Otherwise display the original non null value. What…

INEQUALITY OPERATORS – GREATER THAN & LESS THAN We saw equality operations done by the equals to sign. Now let us explore Inequality Operators, which actually gets us results based on a range of matching values. This is less than sign and this brings rows that are lesser than the condition select First Name Last Name Salary Commission Percentage from employees where commission percentage is less than 00:25. This is greater than symbol. We can use this to get rows that are greater than the condition. The same query with…

BOOLEAN or LOGICAL OPERATORS – CONCEPTS Up to this point we saw single column conditions. Let us learn some theory before proceeding any further. Let us assume that we have a fiction table called sample underscore Tbl with these data here. If I do select star from sample underscore table where call one equals to b, then we will get these rows that are highlighted in pink in the result. Because these rows match the condition call one equals to B, you see the values be here and so these…

Demo: GlideSystem Hello and welcome back. In this video, we’ll actually jump into service now and start writing some code that leverages the Glidesystem API. We’ll start by quickly going over the GS print method. Again, we should be familiar with this method. It takes a string and simply prints it to the screen. It’s very similar to a console log you would see in the browser. So for this, we’ll actually create a variable hello text and assign it a string value of Hello World where we will then…

GlideSystem Introduction Hello, and welcome to section Five, where we’ll be covering the Glidesystem API. We’ll start this section with an introduction to Glidesystem, followed by the Show me the code slide. Then we’ll go over the Glidesystem API diagram. Next, we’ll cover a list of common Glidesystem methods, followed by dissecting some of the most important methods out. Then we’ll cover the concept of events in ServiceNow and do an event demo as well. Then we’ll jump into ServiceNow, where we’ll actually write some code using the Glidesystem API….

GlideRecord – Demo 2 Hello and welcome back. In this video, we’ll be continuing our demo. So let’s start with the order by method. The order by method accepts one argument, which is the field that we would like to order the list by. So we’ll go ahead and create a new glide record object and we’ll order by the short description. And on line three, we’ll go ahead and add the query method. And then we’ll simply print the number of the incident, followed by the incident’s short description….

GlideUser Introduction Hello and welcome back. In this video, we’ll take a look at the Glide user API. So the ServiceNow docs state the Glide User API provides access to information about the current user and current user roles. Using the Glide user API avoids the need to use the slower Glide record queries to get user information. So as the developer, we’d use the Glide user API on the client side to retrieve user information. We can reference Glide user by g underscore user. And it’s a relatively small…