Monday, October 24, 2016

Equivalent of Dual in Oracle in SQL Server

Hi all here is the conversion for Dual:

 there is no concept called dual in SQL Server..

OracleSQL Server
select 2*3 from dualselect 2*3
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Read data from csv in R Programming

Read a data set from csv file.. x <- read.csv(file.choose(),header=TRUE) here x is the R data set vaiable.

  • CHILD_RECORD_FOUND Equivalent in SQL Server
    HI All..,, for CHILD_RECORD_FOUND in Oracle , in SQL Server is Error_number = 547 begin try --------- ---------- end try  begin ca...
  • NTILE In Oracle
    Hi friends today we will discuss about NTILE in Oracle: Syntax:    SELECT NTILE(NUMBER) OVER (ORDER BY <COLUMN>) FROM TABLE; Ex...
  • Program for Student Log time calculation..
    Hi All, Today we are going to discuss about the log hours in a school , Create table std_logs ( SID    NUMBER, IN_TIME    DATE, OUT_...