Tutorials by Alva
A collection of 28 FAQs on Oracle SQL language basics. Clear answers are provided with tutorial exercises on data types, data literals, date and time values, data and time intervals, converting to dates and times, NULL values, pattern matches.
November 5,
2007
Today Views:
1 Total Views:
234
A result set object is a logical representation of data rows returned by odbc_exec() function on SELECT statements.
October 30,
2007
Today Views:
1 Total Views:
232
If you insert multiple rows with a single INSERT statement, you can use the odbc_num_rows() function to find out how many rows were inserted.
October 26,
2007
Today Views:
2 Total Views:
206
If want to insert rows into a table based on data rows from other tables, you can use a subquery inside the INSERT statement...
October 22,
2007
Today Views:
1 Total Views:
213
The best way to query tables and loop through returning rows is to run a SELECT statement with the odbc_exec() function, catch the returning object as a result set, and loop...
October 17,
2007
Today Views:
2 Total Views:
191
Updating existing rows in a table requires to run the UPDATE statement with a WHERE clause to identify the row.
October 10,
2007
Today Views:
1 Total Views:
235
If you want to remove a row from a table, you can use the DELETE statement with a WHERE clause to identify the row.
October 9,
2007
Today Views:
1 Total Views:
219
Text values in SQL statements should be quoted with single quotes ('). If the text value contains a single quote ('), it should be protected by replacing it with two single quotes ('').
October 8,
2007
Today Views:
2 Total Views:
208
If you want to provide date and time values in a SQL statement, you should write them in the format of "yyyy-mm-dd hh:mm:ss", and quoted with single quotes (').
October 4,
2007
Today Views:
1 Total Views:
204
You have seen a lots of Websites are displaying past times in days, hours and minutes. If you want to do this yourself, you can use the DATEDIFF() SQL function.
October 2,
2007
Today Views:
2 Total Views:
183
