From the course: Oracle Database 19c: Basic SQL
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Alternative quoting
- [Instructor] When SQL statements are short, they're easy to manipulate. But if they're longer and they have a single quote marks surrounding string constants, they can be harder to manage whether you're typing a single Select statement, or trying to assign these strings in a PL SQL program for example. In this video, I'm going to show you a way to make string handling easier when it has embedded quote marks. Has this ever happened to you? I want to see, what the higher salaries are after a proposed 5% pay hike. So I'll run a select statement with the proposed changes. I highlight the select statement I'll put the cursor on the select statement and press run statement. There are the results. That doesn't look too bad. But let's say I wanted to remove employee King and anyone who's hired date is year 2008 or later. I'll run the same Select statement again. But I'll add the where clause, with those two conditions. There they are right there. I'll select it. Run it, much better. Now…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.