-
-
-
In Mysql, which one character is used to complete the query and get the input. In other words, we can write the query in multiple lines. How to terminate the query?
Semicolon ' ; '
C.A.MURALI MOHAN
- Feb 28th, 2006
By using semicolon we can terminate the query.
-
How to find errors of PROCEDURE at run time( not complie time) ?
satyam_Ora
- May 16th, 2008
Hi,what nachs has written is correct.Show error is use to find the compilation error not run time error.For runtime error of procedure we need to take help of exception Handling and that error may be ...
nachs
- Aug 22nd, 2006
Use the exception handlers in run timeuse sqlerrm, sqlcode functionsshow erroris used to find errors during compile time
-
Difference between case expresssion and case statement
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
- 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...
-
Giving two tables:EmpCustEmpName, CustID, EmpIDApril, 1, AApril, 3, AApril, 2, ABruce, 4, BBruce, 5, BCarson, 2, CCarson, 1, CCarson, 3, CDavid, 2, DCustReviewCustID, ReviewDate, EmpID1, 01-05-06, A1, 12-13-05, C2, 07-04-04, A2, 05-21-03, C2, 04-02-03, D3, 10-10-02, A3, 02-01-06, C4, 01-01-06, B5, 12-12-04, BWrite a SQL statement that return each EmpName and LATEST ReviewDate. Result should look like this:EmpName, ReviewDateApril, 01-05-06Bruce, 01-01-06...
vishalb
- Apr 27th, 2008
Tested!SELECT E.EmpName, Max(C.Reviewdate) from EmpCust E Join CustReview C on e.Empid=c.empid group by c.empid, E.EmpName
ratna_ponnapalli
- Apr 11th, 2006
Select a.empname,max(b.reviewdate) from empcust a,custreview b where a.custid=b.custid group by a.empname;
-
My problem is i have a two tablestable1customercustid custnametable2custaddrcustaddrid custaddrstr custid datei have different records for each custid in custaddr table. say for example for the first customer we have 6 records in custaddr table. so i want the latest dated record from the custaddr table. ie to find the maximum date. pls somebody can write the query for this, i have tried but not able to find the max of the dates.thanks in advance
rk
- Apr 24th, 2006
select c.*, ca.custaddrstr,ca.custdate from customer c, custaddr cawhere c.CUSTID = ca.CUSTIDand ca.CUSTDATE in (select max(custdate) from custaddrgroup by custid)
-
How do i get the dates of a particular month using the SQL query statement?
rashok1983
- May 24th, 2010
SELECT TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1,rownum,TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1 + rownum from all_objectsWHERE TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1 + rownum <= TO_DATE('12/30/2003', 'MM/DD/YYYY')
MANU
- May 18th, 2006
Hi,You can use date functions available to get the dates of a particular monthEx: SELECT col1 FROM TABLE A WHERE TO_CHAR(DATECOLUMN,'MONYY') = 'JUN05'ORSELECT * FROM TABLE A WHERE TO_CHAR(DATECOLUMN,'MON') = 'FEB'Hope this was useful.....
-
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';
-
Oracle SQL Interview Questions
Ans