Interested to Buy Any Domain ? << Click Here >> for more details...
16. Display the order number, order line number and the
shipping date. If the shipping date is null, display the
string <not shipped yet>.
- 1 Answers
- 4122 Views
- Wipro, I also Faced
- E-Mail Answers
Answer / chanti
select order,orderline,decode(shipped date,null,'not
shipped',shipped date) from <TN>
| Is This Answer Correct ? | 1 Yes | 1 No |
How a database is related to tablespaces?
Which Oracle App Is Most Popular One ?
What is sharded cluster?
What is a user account in oracle?
How to calculate date and time differences in oracle?
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
How to write text literals in oracle?
Can a Tablespace hold objects from different Schemes ?
How to connect to the server with user account: sys?
What is the difference between normal and corelated subqueries?
how do u setup a replication site?
material view and view disadvantages?
Oracle General 
