What will be the syntax to find current date and time in format "yyyy-mm-dd"?
- 0 Answers
- 563 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
What is difference between cartesian join and cross join?
Can you assign multiple query result rows to a variable?
What is the implicit cursor in oracle?
why dont we assign not null constraint as table level constraint.
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
write a sql query following source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want the output column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c
How to recover a dropped table in oracle?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What is the difference between a user and a schema in oracle?
What is instant client oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
What is difference between Rename and Alias?
Oracle General 
