How to copy the data from one table to another table in oracle
[
]
Choose your rating:
Post Ans. View More Ans.
Describe TO_DATE function
[
]
The TO_DATE function returns a timestamp from a character string
that has been interpreted using a character template.
TO_DATE is a synonym for TIMESTAMP_FORMAT.
Choose your rating:
Post Ans. View More Ans.
In what sequence SQL statement are processed?
[
]
The clauses of the subselect are processed in the following sequence (DB2):
1. FROM clause
2. WHERE clause
3. GROUP BY clause
4. HAVING clause
5. SELECT clause
6. ORDER BY clause
7. FETCH FIRST clause
Choose your rating:
Post Ans. View More Ans.
Describe SQL comments.
[
]
SQL comments are introduced by two consecutive hyphens
(--) and ended by the end of the line.
Choose your rating:
Post Ans. View More Ans.
. What does DCL stand for?
[
]
DCL is Data Control Language statements. (COMMIT)
Choose your rating:
Post Ans. View More Ans.
What does DDL stand for?
[
]
DDL is Data Definition Language statements. (CREATE)
Choose your rating:
Post Ans. View More Ans.
What does DML stand for?
[
]
DML is Data Manipulation Language statements. (SELECT)
Choose your rating:
Post Ans. View More Ans.
Describe some Group Functions that you know
[
]
A. 1) The COUNT function tells you how many rows were in the result set.
SELECT COUNT(*) FROM TESTING.QA
2) The AVG function tells you the average value of a numeric column.
SELECT MAX(SALARY) FROM TESTING.QA
3) The MAX and MIN functions tell you the maximum and minimum value of a numeric column.
SELECT MIN(SALARY) FROM TESTING.QA
4) The SUM function tells you the sum value of a numeric column.
SELECT SUM(SALARY) FROM TESTING.QA
Choose your rating:
Post Ans. View More Ans.
Describe some Conversion Functions that you know
[
]
TO_CHAR converts a number / date to a string.
TO_DATE converts a string (representing a date) to a date.
TO_NUMBER converts a character string containing digits to a numeric data type, it accepts one parameter which is a column value or a string literal
Choose your rating:
Post Ans. View More Ans.
Explain SQL SELECT example:
[
]
select j.FILE_NUM
from DB_name.job j, DB_name.address a
where j.JOB_TYPE ='C'
AND j.COMPANY_NAME = 'TEST6'
AND j.OFFICE_ID = '101'
AND j.ACTIVE_IND = 'Y'
AND a.ADDRESS_STATUS_ID = 'H'
AND a.OFFICE_ID = '101'
AND a.FILE_NUM = j.FILE_NUM order by j.FILE_NUM;
Answer: j and a aliases for table names. this is outer joint select statament from two tables.
Choose your rating:
Post Ans. View More Ans.
