-
How cluster index works?
sampra
- Mar 6th, 2012
Cluster index stores the data ordering wise Ascendingly.
suppose u have inserted the data started on A,B, and D and now if any person will enter the data started from C then the entries for D data would be changed to next locations
It would changes the whole structure of the tabelSanjay Agrawal
- May 30th, 2006
Cluster index just changes the whole physical structure of the Tablethe data of table is stored in the data pages they are 8 kb pages.Cluster index stores the data ordering wise Ascendingly.suppose u ...
-
In the real world, where do we use Savepoint command.
dmadhusudhanarao
- Aug 2nd, 2006
good question.remember... you are doing huge work. means assume that you have execute 100 queties. ok . you already finished 50 queries. after executing the 51 query you thaught there is a mistic. wha...
-
How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with Primary Key. Say for Example Emp and Dept Table. We have deptno in both tables and Deptno in Emp table is the Primary Key and other is foreign Key. How do we control what values we insert in Dept table if both the tables are not in the same instance.
dmadhusudhanarao
- Aug 2nd, 2006
see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.
Prakash Pagam
- Jul 24th, 2006
We can do using databasename.tablename
-
-
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.
Ans