4. Using a set operator, display the creditor number of all
creditors who have ever been paid.
Answers were Sorted based on User's Feedback
Answer / srinivas
select credit_number from table where paid <> 1
[NOTE: Here we can use boolean value to paid field, if paid is success 1 inserted and if not paid then insert 0].
From above query , there is displays credit numbers with never paid.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / anil
select * from TN where bal is not null;
intersect
select * from TN where bal is null;
Is This Answer Correct ? | 2 Yes | 6 No |
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
How to pass parameters to procedures?
26. Display the earliest shipping date in the format: DD/MON/YYYY
what is query and types of query
Give syntax for SQL and ORACLE joins.
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
How would you go about verifying the network name that the local_listener is currently using?
Which database is better for os platform dependency?
What are the benefits of ordbms?
How to convert raw data type into text in oracle? Explain
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?