how to see the data (in unix) using dataset in datastage?
What is a subquery?
What is enter substitution variable in oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What is the maximum limit on the number of columns in a table?
How to create a new table by selecting rows from another table?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
you are sorting a table using "order by"(descending) clause of a column which contains a null value...whether that row containing null value will come first or last in the output??
Explain the use of show option in imp command.
how to retrieve data from different tables ,place this data in different excel worksheets.
What are the factors causing the reparsing of SQL statements in SGA?
What is an oracle user role?