Substitution Variables in Oracle
Happy new year to you! I am writing after a long time. Recently I changed my company and It […]
oracle
sql
oracle, sql
Joins and SubQueries – Classroom notes 5
Joins The specification of table aliases in the from clause is necessary to refer to columns that have the same […]
oracle, sql
SQL CONSTRAINTS – classroom notes – 4
Another SQL post, after a long time The definition of a table may include the specification of integrity constraints. Basically […]
mysql, sql
SQL JOINS – classroom notes -3
The most important aspect of SQL is it’s relational features,where the data available in the tables combined with the necessary […]
mysql, sql
SQL classroom exercise – 2
another basic class room exercise for sql!create table grades(id int(5),name varchar(32),maths int (3),physics int(3),literature int(3)); insert into grades values (1, […]
mysql, sql
SQL classroom exercise
Here is one table and its related q&a. will be kept for future reference, or will be useful to beginners! […]
mysql
User Variables in mysql
one more mysql post for this week! variables are mysql specific extension. They hold single values. They are case sensitive. […]
mysql
MySQL and Merge Table
Hi, this is just an information, i need to keep it over here for my future reference. How to a […]
mssql, sql
add user query in ms-sql
just for reference. to create a user in ms-sql sp_addlogin @loginame = ‘bugtracker’, @passwd = ‘bugtracker123’,@defdb = ‘bugtracker’ defdb refers […]
datasource, mysql, struts, tomcat
tomcat – struts datasource – mysql
I was configuring struts DS to connect to mysql today morning. i got failed day be4 yesterday, it ended with […]