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

An LOV is a scrollable popup window that provides the operator with either a single or multi column selection list.

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Feb 3rd, 2007

Lists of Values (LOVs) enable end users to choose entry field values in a form or database portlet customization form.

E.gomathi

• Feb 7th, 2006

LOV is list of values, used to popup the single or multiple values at run time

Answer Question  Select Best Answer

Before report, Before form, After form , Between page, After report.

Prasant

• Nov 23rd, 2006

There are 3types of trigger available in report1.Report triggerbefore parameter formAfter parameter formBefore reportBetween pageAfter report2.Data Model TriggerFormula triggerGroup filter3.Layout TriggerFormat Trigger

imran zaher

• May 23rd, 2006

sequence of execution of the various report triggersBefore form , After form , Before report, Between page, After report.

Answer Question  Select Best Answer

Piyush Pathak

• Feb 1st, 2018

$$DBDATE$$ retrieves the current database or the server you using date
$$date$$ retrieves the current operating system or the current system you are working date.

palani

• Apr 26th, 2006

$$date$$ displaying local system date $$dbdate$$ displaying server date.

Answer Question  Select Best Answer

Connect as sydba Write a LOGON trigger like this� � �CREATE OR REPLACE TRIGGER RESTRICT_TOOL�AFTER LOGON ON DATABASEDECLARE� �L_TOOL �V$SESSION.PROGRAM%TYPE;BEGIN�SELECT PROGRAM�INTO L_TOOL�FROM V$SESSION�WHERE �AUDSID = USERENV('SESSIONID')� �AND �AUDSID != (SELECT AUDSID� � � � � � � � � �FROM V$SESSION� � � � � � � � � �WHERE USERNAME='SYS');�IF UPPER(L_TOOL) LIKE '%TOAD%'�OR UPPER(L_TOOL) LIKE...

Laxmi Kant Sharma

• Aug 30th, 2007

This solution is not working properly.. because it is not raised after logon. so there is no use of raise_application_error after login. Is there any other method for that?

Dinesh G

• Aug 6th, 2005

Above shown trigger won't work if user system. Same will happen if any use opts the as sysdba option.  Is there any way to close these loop holes ?

Answer Question  Select Best Answer

Three types,they are object-based logic models,record-based logic models,and physical models.

anushandilya123

 Profile Answers by anushandilya123 Questions by anushandilya123

• May 8th, 2009

Data Models:
Object based
Record based

Object Based:
Object Oriented
Entity Relationship Model

Record Based:
Relational
Network
Hierarchical

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

There are no standards in this area. Authors and theorists make it up as they go. The entity-relationship model (ER) has hundreds of derivitives (bachman, chen, ibm, IDEF1x etc.). the most popular of ...

Answer Question  Select Best Answer

durga4578

 Profile Answers by durga4578 Questions by durga4578

• Mar 11th, 2006

Select count(empid),d.deptname from emp, dept d where d.deptno=emp.deptno group by deptno

madhu

• Feb 23rd, 2006

the query isselect d.dname,count(*)from emp e, dept dwhere e.deptno = d.deptnogroup by d.dname

Answer Question  Select Best Answer

Laxmi Prasad

• Apr 2nd, 2007

U can call that data using database name.tablename.fields

Culver_lake

 Profile Answers by Culver_lake Questions by Culver_lake

• Mar 22nd, 2006

since the data is in two different tables you have two different choices, JOIN or UNION.  In this case you would probably use UNION. However you can make it much simpler by just leaving the data ...

Answer Question  Select Best Answer

Ramasamy PL

• Jul 24th, 2006

The trigger followed by a DML Operation is called dml triggers.Here the constraint is table used by the DML operation cant be used by trigger.Voiding this will to runtime error.

missoracle

• Jul 18th, 2006

Wrap :- this is used to encript the PL/SQL .sql file.

Answer Question  Select Best Answer

sanjeev

• Aug 6th, 2007

In session properties we have the target commit interval. There we need to mention the commit interval as 1000.Sanjeev

Rajesh

• Oct 10th, 2006

Yes, we have different logic to accomplish this thing in Informatica. You use either sequence generator and Filter transformation or Expresion and Fileter transformation. If you are sorting and loadin...

Answer Question  Select Best Answer

sweetytrivedi

 Profile Answers by sweetytrivedi Questions by sweetytrivedi

• Jun 25th, 2008

B-Tree indexes are usually associated with the index that stores a list of ROWIDs for each key.While Bitmap is also organized as B tree , but the leaf node stores a bitmap for each value instead of a list of ROWIDs. B tree can be used for OLTP while bitmap is used for data warehousing system.

hemshikha

• Sep 1st, 2006

Conventional wisdom holds that bitmap indexes are most appropriate for columns having low distinct values?such as GENDER, MARITAL_STATUS, and RELATION. This assumption is not completely accurate, howe...

Answer Question  Select Best Answer

singapore_li

 Profile Answers by singapore_li Questions by singapore_li

• Sep 15th, 2006

Subject AreasParty,Party Asset,Location,Campaign,product .................

singapore_li

 Profile Answers by singapore_li Questions by singapore_li

• Sep 15th, 2006

FSLDM COnsists of 10 Subject Areasparty,party asset,address,compaign.......

Answer Question  Select Best Answer

Chiranjeevi Manne

• Mar 30th, 2007

You can store the images in oracle database as BLOBS (Binary Large OBjetcS).

Priya

• Oct 15th, 2006

S, u can upload the image in data base,by taking datatype as Image.

Answer Question  Select Best Answer

aju_mech

 Profile Answers by aju_mech Questions by aju_mech

• Jul 25th, 2007

Prompts in MicroStrategy are used for Manipulating data in report while executing it. For Ex. If there is a report with attribute region and Profit Metrics and having a prompt on region attr...

S

• Oct 25th, 2006

A prompt is a MicroStrategy object that allows userinteraction at report run time. The user is asked during the report execution to provide an answer tocomplete the information.Uses:Prompts are useful...

Answer Question  Select Best Answer

padmanabham

• Jul 28th, 2007

Non primary column direclty depended on the primarykey column is called a 3rd narmalization form

rajesh

• Oct 17th, 2005

In order to be in Third Normal Form, a relation must first fulfill the requirements to be in Second Normal Form. Additionally, all attributes that are not dependent upon the primary key must be eliminated.

Answer Question  Select Best Answer