16. Display the order number, order line number and the
shipping date. If the shipping date is null, display the
string <not shipped yet>.
Answer / chanti
select order,orderline,decode(shipped date,null,'not
shipped',shipped date) from <TN>
Is This Answer Correct ? | 1 Yes | 1 No |
Can the query output be sorted by multiple columns in oracle?
how will I find the first 5 highest salaried employees in each dept in oracle.
Why we use bulk collect in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)
What is data file?
i have a table and it has constraints and i want to get "ALTER TABLE table_name ADD CONSTRAINT constraint_name constraint type" this code must be in string type please help me if you want, i can give more explainings
Calculate difference between 2 date / times in oracle sql?
From the database level, how can you tell under which time zone a database is operating?
Does a Before form trigger fire when the parameter form is suppressed ?
How to define a record variable to store a table row?
What is SQL Tuning Advisor in Oracle?