I am using Teradata SQL Assistant.I have a table in SQL server whose table structure I wanna see through SQL assistant.....So please help me out...

Priya Aggarwal

• Nov 27th, 2012

I think sphelp stored procedure provided by sql server should of your help here. try sp_help

Answer Question  Select Best Answer

Union operator in structured query lanhuage

Ashwini

• Jan 25th, 2018

Union combines the results of two or more SELECT statements and eliminates the duplicate rows

Answer Question  Select Best Answer

Difference b/w client server and web based applications?

divya

• Mar 9th, 2013

Client server application refers to an application which has client and its own server. Client can be an employee of an organisation and server of that organisation. For example: College SERVER HAS ...

Answer Question  Select Best Answer

Hi friends,
I m 2012 pass out in CSE discipline. And recently joined Cybage Software as Production Support Engineer. But my ultimate goal lies in Database System. So joining Cybage was merely to keep relatives shut up and parents happy as well as prepare for my goal. But right now I have gone through various sites stating that jobs in DBA is tough to get, for freshers. And also...

DBA

• Feb 15th, 2013

Hope you are aware that being a DBA means working odd hours , indiscriminate routines , erratic week-offs ,etc (occupational hazards ! ) Even then if you wish to take this career option ,here is the w...

Answer Question  Select Best Answer

santosh varma

• Mar 21st, 2013

Check in v$dba_datafiles where the datafiles will start with prefix + are asm data bases

Answer Question  Select Best Answer

Im trying to create a traceable database for work using Access, and im finding that even though i have all the data i need and everything to trace where everything goes i cant seem to get my queries to work. I need to have Table A, B, and C connect to D and connect to E with a query at E to go backwards to the other tables. A, B,and C dont have any relationships that connect them but they all connect...

ritam mitra

• Aug 30th, 2014

First try to check the join or connection between all the tables are proper, then create a view and then run query. it will work

Answer Question  Select Best Answer

Create the flowchart and algorithm for a module that will prompt the user to enter their height in feet and inches (two separate input values). The program should output “Guard” if the user is under 6’4”, “Forward” if the user is between 6’4” and 6’10”, and “Center” is the user is over 6’10”.

Nupur

• Apr 25th, 2015

1.declare variables ft and inch.
2. Enter the values.
3. Check for validity using case statement .
4. Print on screen using dbms_output.put_line

Answer Question  Select Best Answer

Visual  attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.

pankaj_gauba

 Profile Answers by pankaj_gauba Questions by pankaj_gauba

• Jan 10th, 2006

Visual  attributes are the font, color, pattern proprieties that you set for form and menu objects that appear in your application interface.

Answer Question  Select Best Answer

Get_view_property, Set_view_property

Venkat80

 Profile Answers by Venkat80 Questions by Venkat80

• Mar 23rd, 2006

For setting the canvas properties you can use any one of the followingSET_CANVAS_PROPERTY  (canvas_id  CANVAS,   property   NUMBER,   value   &nb...

Answer Question  Select Best Answer

A way in which to pass control (and possibly arguments ) form Oracle report to another Oracle products of 3 GL and then return control ( and ) back to Oracle reports.

Phani

• May 13th, 2006

A user Exit is the program that can be written and linked into the Report builder Executable. We normally get information from the Multi Organization Views ( in Reports). We have 5 different types o...

Answer Question  Select Best Answer

Issues dynamic Sql statements at run time, including server side pl/SQl and DDL

Venkat80

 Profile Answers by Venkat80 Questions by Venkat80

• Mar 23rd, 2006

This is used in form builder.To develope sql statements at run time, it may be DDL or DML statement also.

Answer Question  Select Best Answer

RATIKANTA MOHANTY

• May 13th, 2006

ImmediateDifferred->Yes  Autoquery->YesDifferred->Yes  Autoquery->No

Answer Question  Select Best Answer

Record group column names cannot exceed 30 characters.

srinu

• May 8th, 2006

Hi,your answer is wrong because the maximum column length is 1024 character.srinu.T

Answer Question  Select Best Answer

.fmb - form module binary .fmx - form module executable

pankaj gauba

• Nov 24th, 2005

FMB-Form Module BinaryFmx-form module executablefmt-form module text

Answer Question  Select Best Answer

In Pl/Sql, You can reference and set the values of form parameters using bind variables syntax. Ex. PARAMETER name = '' or :block.item = PARAMETER Parameter name

sithusithu

 Profile Answers by sithusithu Questions by sithusithu

• Jan 19th, 2006

When you start a workflow, you can optionally enter the directory and name of a parameter file. The Informatica Server runs the workflow using the parameters in the file you specify. For UNIX shell us...

Answer Question  Select Best Answer

Text ParametersData Parameters

Pradip

• Feb 20th, 2006

Parameter type are in two typeFormal parameterActual Parameter.

Answer Question  Select Best Answer

When flex mode is on, reports automatically resizes the parent when the child is resized.

Prashanth

• Jan 30th, 2006

 When Fleximode is ON : When the objects present on child is moved against the parent the parent body also moves.When Fleximode is OFF : When the objects on child is moved against parent it doesnt allow to move outside the parent body.Thanks Prashanth

Answer Question  Select Best Answer

After the query is executed but before the report is executed and the records are displayed.

krishna631

 Profile Answers by krishna631 Questions by krishna631

• May 31st, 2006

HaiBefore report trigger fires after, the parameter trigger raises and before data fetch for that query.Krishna Mohan

Answer Question  Select Best Answer

A combo box style list item combines the features found in list and text item. Unlike the pop list or the text list style list items, the combo box style list item will both display fixed values and accept one operator entered value.

HiTen Kotak

• Sep 20th, 2006

It's like pre-defined box having a list of value & operator can select any of them...for an example "Sex:" or "State" here you can use combo box..as you can pre-define these values.

Answer Question  Select Best Answer

kollati

 Profile Answers by kollati Questions by kollati

• Apr 21st, 2011

What exactly you are looking for....you can delete?complete row in a table by using delete statement using where clause.you can make it null value in the attribute in a row.

Answer Question  Select Best Answer