How to fill Dataset from Datareader?

Venkat

 Profile Answers by Venkat Questions by Venkat

• Feb 12th, 2008

by using datasetds = new dataset()sqlDbAdapter ad = new sqlDbAdapter(sqlquery,connobject)ad.fill(ds,tablename)DataReaderdr = new sqlDataReader()sqlCommand sqlcmd = new sqlcommand(sqlqry,conObject)dr =...

Answer Question  Select Best Answer

vipsforever

 Profile Answers by vipsforever Questions by vipsforever

• Feb 9th, 2008

Select department_id, m.salary from employees m where m.salary =(select max(salary) from employees where salary in( select max(salary) from employees group by department_id));

bharadh

• Oct 22nd, 2007

Select  deptno,sum(sal) from emp where depno in(select deptno from emp where sal)=(select max(sal) from emp group by deptno)

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

When you drop a table, normally the database does not immediately release the space associated with the table. Rather, the database renames the table and places it in a recycle bin, where it can later...

Suresh

• Aug 4th, 2006

You can use this command to retrieve the dropped table, simply by querying,FLASHBACK TABLE TO BEFORE DROP;you can also query this to view the objects that can be undropped,SHOW RECYCLEBIN

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

An inline view is created by placing a subquery in the FROM clause and giving that subquery an alias. The subquery defines a data source that can be referenced in the main query.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 12th, 2006

When a query is given inplace of tablename in from cluse .  The query becomes a inline view.

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

LEVELYou use LEVEL with the SELECT CONNECT BY statement to organize rows from a database table into a tree structure. LEVEL returns the level number of a node in a tree structure. The root is level 1, children of the root are level 2, grandchildren are level 3, and so on.

Tatyana

• May 5th, 2006

Sorry, sorry, I am wrong. Rowid is a pseudocolumn.

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

Date and character literals must be enclosed within single quotation marks (' ');If a column alias contains a space, it should be enclosed in double quotation marks.

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

double quote(") is used to give user defined column alias example:select empno , ename "employee name" from emp;this will print column heading as:  EMPNO       ...

Answer Question  Select Best Answer

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

The CASE statement supported by PL/SQL is very similar to the CASE expression. The main difference is that the statement is finished with an END CASE statement rather than just END. The PL/SQL statements are essentially an alternative to lists of IF .. THEN .. ELSIF statements:

oraappsexp

 Profile Answers by oraappsexp Questions by oraappsexp

• Feb 9th, 2006

CASE Expressions And StatementsThe CASE expression was first added to SQL in Oracle8i. Oracle9i extends its support to PL/SQL to allow CASE to be used as an expression or statement:Value Match CASE Ex...

Answer Question  Select Best Answer

UTL_FILE is a package that adds the ability to read and write to operating system files. Procedures associated with it are FCLOSE, FCLOSE_ALL and 5 procedures to output data to a file PUT, PUT_LINE, NEW_LINE, PUTF, FFLUSH.PUT, FFLUSH.PUT_LINE,FFLUSH.NEW_LINE. Functions associated with it are FOPEN, ISOPEN.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 7th, 2008

With the Oracle-supplied UTL_FILE package, you can read from and write to operating system files. It Provides security for directories on the server through the init.ora file. UTL_FILE Procedures and ...

Rakesh

• Mar 20th, 2007

Utl_file is oracle procedure tht enable file access .You can write ,read to file.Also possible is to del or rename a file.It requires the use of a directory object.

Answer Question  Select Best Answer

Oracle Call Interface is a method of accesing database from a 3GL program. Uses--No precompiler is required,PL/SQL blocks are executed like other DML statements. The OCI library provides-functions to parse SQL statemets-bind input variables-bind output variables-execute statements-fetch the results

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

The Oracle Call Interface (OCI) is a set of low-level APIs (Application Programming Interface Calls) used to interact with Oracle databases. It allows one to use operations like logon, execute, parse,...

subbaraovangalli

 Profile Answers by subbaraovangalli Questions by subbaraovangalli

• Apr 4th, 2007

What is meant by 3GL PGRM

Answer Question  Select Best Answer

OPEN cursor variable FOR SELECT...StatementCLOSE cursor variable In order to associate a cursor variable with a particular SELECT statement OPEN syntax is used. In order to free the resources used for the query CLOSE statement is used.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

• The OPEN-FOR statement associates a cursor variable with a multirow query, executes the query, identifies the result set, and positions the cursor to point to the first row of the result set.&b...

S.Senthil Kumar

• Oct 31st, 2006

Without Open Cursor statement the data which is in the table cannot be load into cursor variable.The Close Cursor statement deallocates the memory occupied by the cursor

Answer Question  Select Best Answer

NO DATA FOUND is an exception raised only for the SELECT....INTO statements when the where clause of the querydoes not match any rows. When the where clause of the explicit cursor does not match any rows the %NOTFOUND attribute is set to TRUE instead.

g_sidhu

 Profile Answers by g_sidhu Questions by g_sidhu

• Feb 6th, 2008

NO DATA FOUND: Is an exception which is raised when no rows are retrieved from the database in a SELECT statement, then PL/SQL raises the exception NO_DATA_FOUND.%NOTFOUND: is a Boolean attribute that evaluates to TRUE if the most recent SQL statement does not affect any rows.

syam sundar

• Aug 17th, 2007

NO DATA FOUND is an exceptionWhen your?SELECT INTO?statement?returns no rows that time an error raised by oracle. The error is ORA-01403 NO DATA FOUNDWhereas %NOTFOUND?is a?cursor attributeIt ret...

Answer Question  Select Best Answer

What is SQL Tuning? How does it work? Thanks

abhi2433

 Profile Answers by abhi2433 Questions by abhi2433

• Feb 6th, 2008

SQL tuning is the process of ensuring that the SQL statements that an application will issue will run in the fastest possible time

Answer Question  Select Best Answer

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

patilpravin_1981

 Profile Answers by patilpravin_1981 Questions by patilpravin_1981

• Jan 30th, 2008

Select * from employees where salary between(1000 and 5000);

LRANI

 Profile Answers by LRANI Questions by LRANI

• Jul 31st, 2007

Hi,minus is used for finding the missing records between 2 tables and not finding the records between the range.It is BETWEEN operator that displays the records between 2 ranges from single table.

Answer Question  Select Best Answer

vanigreat

 Profile Answers by vanigreat Questions by vanigreat

• Jan 17th, 2008

select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) - (select count(days) from (selectto_char(to_date('01/01/2008','dd/mm/rrrr&...

Answer Question  Select Best Answer

Needed a SQL query for this----------I have table with columns firstname, lastname and phone number and we have 2 entries in that table ...now I want to know the persons with this combination firstname of person = lastname of second person? ln phone----------------------------------john cubick 1223sam course 4556output:john course

geminine79

 Profile Answers by geminine79 Questions by geminine79

• Jan 3rd, 2008

I think you can use the cartesian product on the same table and try to get the data out of that. try this and let me know.

naveen.papineni

 Profile Answers by naveen.papineni Questions by naveen.papineni

• Nov 26th, 2007

Select first_name ,last_name ,phone_number from table where first_name in (select last_name from table )I think this will work out.RegardsNaveen.

Answer Question  Select Best Answer

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

Dear Shruti,First query the data dictionary view "USER_CONS_COLUMNS" to find the constraint name.Then instead of dropping the constraint just disable it.step1:--> select constraint_name,c...

Answer Question  Select Best Answer

I cant drop the whole column because that is interlinked with my process? I have declared not null on a column, I have to change it

kishore.giri

 Profile Answers by kishore.giri Questions by kishore.giri

• Dec 10th, 2007

Dear Sarika,Instead dropping the constraint just disable the constarint.The command is:Alter table table_name disable constraint constraint_name;try it and reply me

Answer Question  Select Best Answer

How to know the days or months or years between two employees in emp table.

jbabu

 Profile Answers by jbabu Questions by jbabu

• Dec 10th, 2007

Select hiredate,lead(hiredate,1) over(order by hiredate) next_months, round(months_between(lead(hiredate,1) over(order by hiredate),hiredate),3) months from emp;

Answer Question  Select Best Answer

How to see on what coloumns the indexes have been created?

Waseem Mehmood

 Profile Answers by Waseem Mehmood Questions by Waseem Mehmood

• Nov 29th, 2007

SELECT * FROM ALL_INDEXES WHERE TABLE_NAME = 'table_name'-- It will give u all indexes in required table

Answer Question  Select Best Answer