Interested to Buy Any Domain ? << Click Here >> for more details...
How do we get current date in SQL Server 2000, Oracle, MS
Access?
- 13 Answers
- 52681 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / abhirams
slect TO-CHAR(syssdate,'dd-mm-yy h:mipm') from dual; this is
oracle query..
| Is This Answer Correct ? | 5 Yes | 8 No |
Distinguish between nested subquery and correlated subquery?
If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?
what is Archive old data?
What is instead of trigger sql server?
What is the use of toad or sqldbx.?
Why I have to use stored procedures?
Can you use order by when defining a view?
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L
what is a self join? Explain it with an example? : Sql server database administration
What is mean by dml?
What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
