I am having some issues on the last couple of steps for bans. Bans1 works bans two does not and I have bans 3 and 4 to try.
The problem is it takes two hours to go through boards,members,topics,posts before it gets there.
For testing how do I skip everything to get to the ban steps?
You can edit the .sql file and take out the steps you don't want
I was hoping for a flag not delete the lines.
Oh well.
Thanks
Comments Within SQL Statements (https://docs.oracle.com/cd/B13789_01/server.101/b10759/sql_elements006.htm)
QuoteBegin the comment with a slash and an asterisk (/*). Proceed with the text of the comment. This text can span multiple lines. End the comment with an asterisk and a slash (*/). The opening and terminating characters need not be separated from the text by a space or a line break.
SELECT last_name, salary + NVL(commission_pct, 0),
job_id, e.department_id
/* Select all employees whose compensation is
greater than that of Pataballa.*/
FROM employees e, departments d
/*The DEPARTMENTS table is used to get the department name.*/
WHERE e.department_id = d.department_id
AND salary + NVL(commission_pct,0) > /* Subquery: */
(SELECT salary + NVL(commission_pct,0)
/* total compensation is salar + commission_pct */
FROM employees
WHERE last_name = 'Pataballa');
SELECT last_name, -- select the name
salary + NVL(commission_pct, 0),-- total compensation
job_id, -- job
e.department_id -- and department
FROM employees e, -- of all employees
departments d
WHERE e.department_id = d.department_id
AND salary + NVL(commission_pct, 0) > -- whose compensation
-- is greater than
(SELECT salary + NVL(commission_pct,0) -- the compensation
FROM employees
WHERE last_name = 'Pataballa') -- of Pataballa.
;
I know what comments are.
So I don't need to do anything with convert.php?
Just the sql file of the converter?
correct just the sql file
Thank You.