By default, line numbers are not turned on in SQL Developer. To turn them on, go to Tools ? Preferences: Click on the + next to Code Editor. Click on
The LCASE() function simply converts the value of a field to lowercase. Syntax: SELECT LCASE(column_name) FROM table_name;
Have you dropped a table by mistake and want to restore it? In some cases you can. Let’s say you’ve run this statement: DROP TABLE yourtable; Now, you want to
If you’re working with DATE fields in Oracle, and select this data, you’ll see the dates in the default output format. Depending on your location, the default date format could
TEXTSIZE can limit the amount of data returned for the following data types: varchar(max)nvarchar(max)varbinary(max)textntextimage To set the TEXTSIZE use the following command: SET TEXTSIZE (number) So, if I were to
The DATEFROMPARTS function returns a date value with the date portion set to the specified year, month and day, and the time portion set to the default. An example follows:
The following example replicates a # character five times in front of a Student Number in the Students table: SELECT [Student Name], REPLICATE(‘#’, 5) + [Student Number] AS ‘Student Number’FROM
When working with dynamic SQL queries, you will encounter situations in which you will work with temporary tables. Knowing whether a temporary table exists or not is vital and can
You can use the FOR XML PATH SQL Statement to join or concatenate multiple column values into single row. You could then use STUFF to remove the first ‘,’ (now