Who is arup nanda

For web page which are no longer available, try to retrieve content from the of the Internet Archive if available. Privacy notice: By enabling the option above, your browser will contact the API of web. So please proceed with care and consider checking the Internet Archive privacy policy. Add a list of references from , , and to record detail pages. Privacy notice: By enabling the option above, your browser will contact the APIs of crossref. So please proceed with care and consider checking the Crossref privacy policy and the OpenCitations privacy policy , as well as the AI2 Privacy Policy covering Semantic Scholar.

Add a list of citing articles from and to record detail pages. Privacy notice: By enabling the option above, your browser will contact the API of opencitations. Show tweets from on the dblp homepage. Privacy notice: By enabling the option above, your browser will contact twitter. At the same time, Twitter will persistently store several cookies with your web browser. While we did signal Twitter to not track our users by setting the "dnt" flag , we do not have any control over how Twitter uses your data.

So please proceed with care and consider checking the Twitter privacy policy. We are hiring! We are looking for three additional members to join the dblp team.

Authors: no matches. Don't Like? Now that you see how some people may confuse as a comment and make mistakes, you may not like to have this special property assigned to. You can easily change it. You will get an error. It's probably better than an assumption of character as a comment.

Takeaways The character is not a comment in SQL scripts. You entered a command and urgh, there was a typo. And it puts the last SQL you entered in a file, oddly named, afiedt. You don't like it and you want a name easier to type.

Is it possible? Of course. History of Afiedt. Buf First a little bit of background information on the odd name. When the editor wanted to bring up a file for editing, the file had to be given a name unique enough so as not to conflict with anything else. Therefore the file was named ufiedt. However an operating system that Oracle supported couldn't handle a 7 character file name before the period before suffix.

Therefore the name was shortened to afiedt. As the advancements in technology came, Oracle didn't bother to change it and the name stuck. Long live afiedt. Why Change It? If ain't broken, don't fix it. Shouldn't that be the case? The name doesn't break anything; so why change it? There are three reasons to at least consider. The name may difficult to type. The file is created in the present directory. Suppose you are in a directory you don't have permission on, e.

You will get this error: SP Cannot create save file "afiedt. So, while you mean no disrespect to Oracle's legacy, you would want to relegate afiedt. If you haven't, you are missing out on a very important piece of instruemntation code built right into the Oracle database session management. This allows you to assign a completely arbitary name, as you would see will properly describe for your application.

Even though the userid is the same for all these sessions; the module column will help you identify the session. Let's see how it works by a little example. Here is how you check the module information. If you want to enable tracing, check the sessions stats, debug what's going on, etc. The principles of least privileges says that we don't want to grant more privileges than absolutely necessary. While no one will argue against this being convenient, it will probably be hard to justify as "absolutely" necessary.

So, what could you do to identify the session via the module? The generic module name "sqlplus. There is a much simpler solution. By default the setting is off. And you could do that without calling the package. What are the practical implications?

The best usecase, I think is using this in the automatic login scripts such as glogin. Put the following line in gloin. However you can also create local files called login. For instance, suppose you have three major directories where you generally run the SQL scripts from. Create login. You will be able to know what directory the user has been in calling the scripts. A caveat on the above, though. In Oracle It is silently ignored. To make sure the local login. Here is the presentation deck for your reference.

You can download the session and scripts used for the demo here. I hope you found them useful. As always, I love to hear your feedback. You can add a comment here, email me at arup proligence. Here is an example of a string called Joe Pizza. Now let's see what happens if we put another pair of single quotes. To be syntactically correct, we will need to escape the single quote with another single quote.

Well, the Assert package stripped off all extraneous single quotes and replaced them with just one pair of single quotes. But what happens when we need to put a single single quote as a legitimate character, e. Joe's Pizza? This is where the escape sequence in SQL comes in. Wait a minute. It's not Joe's Pizza; it's Joe''s Pizza.

There are two single quotes; not one. That's not what we intended, did we? So it's wrong, right? No; it's perfectly fine. You see, when you pass "Joe's Pizza" inside single quotes, you must escape the single apostrophe inside.

The escape character is the single quote. Since the Assert package puts single quotes around the string, the single quote inside the string must be escaped to be syntactically correct. So, it makes sense to have two single quotes; not just one.

Joe's Pizza--if there is something in real world in that name--should probably pay me for the publicity. I am truly honored by your presence, and especially for the questions.

You can download the presentation here And the scripts I used for the demos here. As always, I will appreciate your feedback either via comments here, or on social media or emails. Twitter ArupNanda Facebook. How hard it is to learn a new language? It depends on the learner, of course; but everyone will agree that it is easier to get your feet wet if you learn the corresponding structures of a language you are already proficient in. I learned most of the languages that way, and this is an experiment to do the same here as well.

Designed as a five part series, it starts off with the basics such as variables and assignments. Finally, it explains how to use publicly available packages for data manipulation, including the ones to connect to the Oracle database. The idea is to have you up and running in Python by committing about an hour every day for a week.