DESCRIBE TABLE IN ORACLE AND SQL SERVER

   1.ORACLE:

DESCRIBE table;
  OR
DESC table;
OUTPUT:
Name          Null       Type
FIRST_NAME              CHAR(20)
LAST_NAME               CHAR(20)
PHONE                  NUMBER(10)
2.SQL SERVER
EXEC sp_columns Table
TABLE_QUALIFIER   | Employee
TABLE_OWNER       | HRDB
TABLE_NAME        | Emp
COLUMN_NAME       | Salary
DATA_TYPE         | -4
TYPE_NAME         | Salary
PRECISION         | 2147483647
LENGTH            | 2147483647
SCALE             | NULL
RADIX             | NULL
NULLABLE          | 1
REMARKS           | NULL
COLUMN_DEF        | NULL
SQL_DATA_TYPE     | -4
SQL_DATETIME_SUB  | NULL
CHAR_OCTET_LENGTH | 2147483647
ORDINAL_POSITION  | 4
IS_NULLABLE       | YES
SS_DATA_TYPE      | 23
(1 row affected)

Comments

Post a Comment

Popular posts from this blog

SQL SERVER INTERVIEW QUESTION AND ANSWERS PART 1

  SQL Server Query Interview Questions with Answers SQL Server DATEADD() Function 1) Write a Query to display the date after 15 days?   SELECT DATEADD(dd, 15,getdate()) 2) Write a Query to display the date after 12 months? SELECT DATEADD(mm, 2, getdate()) 2) Write a Query to display the date before 15 days?   SELECT DATEADD(dd, -15, getdate()) SQL Server DATEDIFF() Function 3) Write a Query to display employee details along with exp? SELECT * DATEDIFF(yy, doj, getdate()) AS ‘Exp’ FROM employee 4) Write a Query to display employee details who is working in ECE department & who his having more than 3 years of exp? SELECT * DATEDIFF(yy, doj, getdate()) AS ‘Exp’ FROM employee WHERE DATEDIFF(yy, doj, getdate())>3 AND dept_name=’ECE’ 5) Write a Query to display employee details along with age? SELECT * DATEDIFF(yy, dob, getdate()) AS ‘Age’ FROM employee 6) Write a Query to display employee details whose age >18? SELECT * DATEDIFF(yy, dob, getdate()) AS ‘Age’ FROM em...
Read more

Selenium questions

 Introduction, framework explanation.  OOPS application in Selenium project.  Selenium architecture. Parameterization syntaxes. How to capture screen shots? How to handle mouse and keyboard events? Webelement & Webdriver methods. Exceptions in Selenium. What are Locators. TestNG annotations with their sequence.  TestNG keywords.  How to group tests? How to execute tests in parallel?  What are TestNG listners? Core Java basic questions Static vs nonstatic  Polymorphism  Constructor  Main method  Up casting  Wrapper classes Object class, String class methods Differences between String, String buffer, Stringbuilder.  Collection & its subinterfaces and classes their differences.  Cursors : iterator, list iterator, enumeration.  Abstract class, Interface applications. 1 Logical program based on String & collection like hashmap.  Asked to find XPath for some Webelement or list of webelements.  Write PO...
Read more

SQL order of execution

Image
  SQL order of execution is: "FM WG HAVING SOL" 1: from 2: where 3: group by 4: having 5: select 6:order by 7:limit eg: Write an SQL Query find number of Employees with GENDERaccording to gender whose DOB is between '01/01/1996' to '31/12/1999' select count(*) as NO OF EMPLYEES,Gender from Employees WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' GROUP BY GENDER STEPS: 1.FROM  CHOOSE AND JOIN TABLE TO GET BASE DATA Here "EMPLOYEES" is Selected. 2.WHERE  Filters the DATA WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' 3.GROUP BY AGGREGATES THE BASE DATA GROUP BY GENDER MALE,FEMALE MALE: 1 FEMALE: 3,4 4.HAVING FILTERS THE AGGREGATED DATA EG: HAVING  EMPID < 100 5.SELECT : RETURNS FINAL DATA 6.ORDER BY : SORTS THE FINAL DATA EG ORDER BY NO OF EMPLYEES ASC 7.LIMIT : LIMIT THE RETURN DATA TO ROW COUNT select count(*) as NO OF EMPLYEES,Gender from Employees WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' L...
Read more