What does Toad mean? How it's work?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• May 18th, 2010

Toad is a freeware, powerful, low-overhead tool used by database designer and application developers for faster and easier and simplifies day-to-day administration of various relational databases.

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• May 7th, 2010

It is just a Tool that uses for writing database statements and PL/SQL.

Answer Question  Select Best Answer

If in a table we dont use primary key or any other unique key then how to avoid duplication of data?

PremG

• Aug 10th, 2015

Yes, by creating Unique index on the respective column we can avoid duplicate values into that particular column. But, with this NULL values can not be restricted.

prakash

• Aug 6th, 2015

By creating unique index it is possible

Answer Question  Select Best Answer

What could be the maximum size of a database name in MSQL?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• May 18th, 2010

Max Length in MySql Database 64 Table 64 Column 64 Index 64 Stored Function or Procedure 64 Trigger 64 View 64 Event 64 Tablespace 64 Log File Group 64 Alias 255

Answer Question  Select Best Answer

How to execute DOS Commands from SQL prompt?

vinodsahani

 Profile Answers by vinodsahani Questions by vinodsahani

• Apr 12th, 2008

Either you can type HOST to go into DOS prompt, use DOS commands and then type EXIT to return back.OR, if you want to run only one DOS command you can type HOST  Hope this will work for u.

aravindpurohit

 Profile Answers by aravindpurohit Questions by aravindpurohit

• Apr 8th, 2008

Sql> host (enter)This takes u t dos mode .regardsAravind purohit.

Answer Question  Select Best Answer

Bharathiarun

• Aug 20th, 2015

Even if the Id is varchar, the rows are ordered by rownum.

Anand Prakash Joshi

• Aug 10th, 2015

Code
SELECT * FROM (SELECT A.*, ROW_NUMBER() OVER (ORDER BY EMPNO) ROW_NUM FROM ZZ_EMP A)
WHERE MOD(ROW_NUM,2) =1

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