-
How do i execute a query sayselect * from tablename and write reasult to a text file say c: kk.txt
Sarfaraz Ahmad Khan
- Jul 18th, 2006
yeah its very simpleuse the syntax like this:spool <somefilename> (you can give the path also like c:sarfarazxyz.txt)<now your query>and to see that whether the result is actually st...
vssandilya
- Jun 12th, 2006
please give an exampe as to how to do it in SQL SERVERFOR EXAMPLE IAM HAVING A TABLE DEPARTMENT1I WANT TO STORE THE CONTENTS OFSELECT * FROM DEPARTMENT1 INTO C:KK.TXT.
-
Select comm from emp;
The Null column in the output will come in the last i.e at the end. WHY?e.g COMM 1200 1000 1300 1450 ---- (NULL) ---- (NULL)
Anurag Puranik
- Jul 29th, 2006
Nulls are unassigned and unavailable values.i.e. null means "no value".So in order to obtain values the values get preference over the no values(null).
-
How to find last record in a table.
ANURAG PURANIK
- Jul 29th, 2006
Select * from emp where rowid=(select max(rowid) from emp);
-
-
How can i spellout the number. but the number like $24 and output will be twenty four doller
Kranthi Reddy
- Oct 6th, 2006
Please find the sample below.select 24||'$', decode (substr('24$',1,1),1,'One',2,'Two',3,'Three',4,'Four','Others')|| decode (su...
-
What purpose we are using cursors? why you need cursor? why i write into clause when i want to write select statement.when you are using out and inout paramaters mode in procedure......pls explain ...
krishnaindia2007
- Jun 22nd, 2008
>>what purpose we are using cursors? why you need cursor?Whenever we are processing sql statement oracle allots PRIVATE SQL AREA OR WORK AREA to store porcessed information. Cursor is a pointer ...
srinadh
- Sep 9th, 2006
in stored procedure & function we can retrive the data sequentially we use cursor
-
Is there any other option other than desc query to describe the table
sampra
- Mar 6th, 2012
SELECT
column_name "Name",
nullable "Null?",
concat(concat(concat(data_type,(),data_length),)) "Type"
FROM user_tab_columns
WHERE table_name=TABLE_NAME_TO_DESCRIBE;sunildas4U
- Aug 24th, 2006
An alternative to the DESC command is selecting directly from the data dictionary - DESC MY_TABLEis equivalent to SELECT column_name "Name", nullable "Null?",concat(concat(concat(data_type,'('),data_length),')') "Type"FROM user_tab_columnsWHERE table_name='TABLE_NAME_TO_DESCRIBE';
-
-
How to write the CSV command in SQL?
krishnaindia2007
- Jun 22nd, 2008
Spool the out put to text file as follows.SET HEADING OFF;SET FEEDBACK OFF;SPOOL EXAMPLE.TXTSELECT EMPNO || ','||ENAME||','||SAL FROM EMP;SPOOL OFF;SET FEEDBACK ON;SET HEADING ON;
Prashant Amburle
- Nov 4th, 2006
Try below wiil resolve the problemspool c:a.txtselect tname||','||tabtype from tab;spool offopen a.txt
-
Changing Rows into Colums
How to change rows to columns and columns into rows?
Santhoshkandula
- May 11th, 2011
create table #temptable(rowid int,colorname varchar(25),Hexa varchar(7),R tinyint,G tinyint,B tinyint) GO insert into #temptable values(1,'Violet','#8B00FF',139,0,255); insert into #te...
-
Find Base Table of the View
Views are created on the basis of base tablesWhat is the query to know the base table of the view? How to know the details of base table?
Prem_p
- Apr 28th, 2011
Guys,?you don't need a dba privilege for this.Run the query:select * from USER_DEPENDENCIES where ?type='VIEW' and name=''This will give you the dependent object information (name , type of the obje...
Balakrishna12207
- Feb 7th, 2011
SELECT * FROM dba_views WHERE View_name=;Text column can contain "The details of view and table"
-
SQL NULLIF Function
What is the use of NULLIF function in SQL?
sampra
- Mar 6th, 2012
In SQL, NullIf function is used to compare two expressions. There are 3 possible results for NULLIF. 1. If the values are same, NullIf returns NULL. Eg: NULLIF(Prem,Prem) returns NULL 2. If they are...
Prem_p
- Apr 28th, 2011
In SQL, NullIf function is used to compare two expressions. There are 3 possible results for NULLIF.1. If the values are same, NullIf returns NULL. Eg: NULLIF('Prem','Prem') returns NU...
-
Matrix Query
Create a query to display the total number of employees, of that total, the number of employees hired in 1995, 1996, 1997, 1998. Create appropriate column heading from the employees table.
Prem_p
- Apr 28th, 2011
SELECT count(e.empno) Emp_Count,to_char(e.hiredate,'YYYY') hired_On from empoyee ewhere to_char(e.hiredate,'YYYY') in (1995, 1996, 1997, 1998)group by rollup(to_char(e.hiredate,'YYYY')) order by 2
mlodugu
- Apr 10th, 2011
How about this?SELECT SUM(sal) Total_sal, extract(year from hiredate) YrFROM scott.emp GROUP BY Rollup(extract(year from hiredate))
-
What are the advantages of views?
sampra
- Mar 6th, 2012
1) To protect some of the columns of a table from other users.ie for security purpose.
2)To hide the complexity of a query.
3)To hide the complexity of calculations.vivekrajece
- May 19th, 2011
1) To protect some of the columns of a table from other users.ie for security purpose.2)To hide the complexity of a query.3)To hide the complexity of calculations.
-
Reversing String in Oracle without using reverse function
How do I reverse a string using only Oracle SQL without using the reverse function??
How do you find the numbert of rows in a Table ?
A bad answer is count them (SELECT COUNT(*) FROM table_name)A good answer is :-'By generating SQL to ANALYZE TABLE table_name COUNT STATISTICS by querying Oracle System Catalogues (e.g. USER_TABLES or ALL_TABLES).The best answer is to refer to the utility which Oracle released which makes it unnecessary to do ANALYZE TABLE for each Table individually.
How you open and close a cursor variable.Why it is required?
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
- 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
What is OCI. What are its uses?
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
- 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,...
What is an UTL_FILE.What are different procedures and functions associated with it?
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
- 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.
Ans