Tutorials by Alva
It's about web development rather than web design. If you have followed our tutorials and got the Apache server installed and running, got the PHP engine installed and configured, you can now use this tutorial to configure the Apache server to run PHP engine as CGI to support PHP scripts.
June 7,
2011
Today Views:
1 Total Views:
288
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:
1,183
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:
1,341
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:
1 Total Views:
1,162
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:
1,303
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:
1 Total Views:
1,245
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:
964
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:
2 Total Views:
1,284
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:
1 Total Views:
1,207
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:
1,243
