User Profile

Collapse

Profile Sidebar

Collapse
richasaraf
richasaraf
Last Activity: Jun 22 '07, 06:35 AM
Joined: Aug 26 '05
Location: Pune, India
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • richasaraf
    replied to Procedure Vs Function
    in Oracle
    Hi Radhi,
    Function computes a value and returns that value. It should always return one value.
    Procedure excutes certain queries. It does have return but it returns to the program from where it has been called.

    Thanks...
    See more | Go to post

      Leave a comment:

    • richasaraf
      replied to Oracle PL/SQL question
      in Oracle
      Thanks .. That will be a great help to me to prepare for interview....
      See more | Go to post

        Leave a comment:

      • richasaraf
        started a topic Query in connection
        in ASP Classic

        Query in connection

        Hi all,
        I have a query in ASP. I'm a beginner in ASP, and i have to solve a problem.
        Well it is as below:
        While making Connection in ASP to the Oracle Database, there is hardcoding done for schema, password... but i want to know whether does ASP has any such facility in which we can declare soem variable or similar like tht and accept the connection at runtime, so there is no need to change the password / username ... everytime...
        See more | Go to post
        • richasaraf
          started a topic Oracle PL/SQL question
          in Oracle

          Oracle PL/SQL question

          Hi All,
          Please .. can anyone suggest me where i shud hunt for Interview questions in Oracle.... i need them.. or else can anyone give me questions?

          That will be a great help....

          Thanks
          See more | Go to post
          • richasaraf
            started a topic PL/SQL - Can function have OUT, IN OUT parameter ?
            in Oracle

            PL/SQL - Can function have OUT, IN OUT parameter ?

            Hi guys,
            Can someone help me...
            I want to know... can we have OUT, IN OUT parameters in function? :confused:
            And can we use it in select statement ?

            Thanks a lot !
            Take Care

            Richa :)
            See more | Go to post
            • richasaraf
              started a topic Conversion of to_char into number format!
              in General

              Conversion of to_char into number format!

              Hi all,
              Please help me out... i want to convert the to_char into number format....
              please let em know how to do it...
              for eg:
              i have a statement : to_char(p_numbe r, 'S000000')
              this converts the number into proper format....
              now i want to convert tht 'S000000' char back to the original number p_number.....
              Can anyone tell me how to do it please :confused:

              Thanks a lot...
              See more | Go to post
              • richasaraf
                started a topic Java Examples !
                in Java

                Java Examples !

                Hi All !
                Please help me out... :confused: i'm a beginner in Java, and i need to practice it ... so i need a site or some source where i can find some good exercises in java programming for logic building !

                Please Help me !

                Thanks a lot :)
                See more | Go to post
                • richasaraf
                  replied to to_date
                  in General
                  to_date format

                  use the following pattern.... suppose you want date and not time then write query as :

                  select to_date(column_ name, 'DD-Mon-YYYY') from table_name;

                  Enjoy !!! :)...
                  See more | Go to post

                    Leave a comment:

                  • richasaraf
                    replied to SQL Codings for Insert, Update, Delete
                    in General
                    Ur site !




                    -------------------------------

                    Hello !
                    got o following site.... it is of great help........... .

                    http://www.techonthenet.com/sql/index.php

                    Thanks :)...
                    See more | Go to post

                      Leave a comment:

                    • richasaraf
                      replied to relational algebra query
                      in General
                      ur query !



                      ----------------------------------
                      Hello !
                      Query is as follows :

                      select hotelNo, hotelName, type, price, city from hotel a, room b
                      where a.hotelNo = b.hotelNo
                      and city = 'Canberra'
                      and type in ('Double', 'Single')

                      Thanks...
                      See more | Go to post

                        Leave a comment:

                      • richasaraf
                        replied to SQL query
                        in General
                        Query !


                        --------------------------------------------------------------------
                        Hello !
                        The query is as follows :

                        select a.*
                        from guest a, booking b, hotel c
                        where a.guestNo = b.guestNo
                        and b.hotelNo = c.hotelNo
                        and hotelName = 'Grosvenor Hotel'

                        Thanks ! :)...
                        See more | Go to post

                          Leave a comment:

                        • richasaraf
                          replied to Joins in MSSQL
                          in SQL Server
                          Query using JOINS


                          -------------------------------------------------------
                          Hello !
                          First consider table 'book' which has columns bookid, book_name and price.. out of which bookid is primary key.
                          Then consider table 'author' which has columns authorid and author_name out of which authorid is primary key.
                          Then consider table bookdetails which has columns bookid, authorid and publication.... ....
                          See more | Go to post

                            Leave a comment:

                          • richasaraf
                            replied to SQL don't work
                            in General
                            -----------------------------------
                            hello there !
                            Do try out the following query..... might work for you ! :rolleyes:

                            SELECT detail_id, de_id, subjectTXT, urlTXT, pictureTXT, priceSaleNUM, decode( parentNUM, 0, lan_id, 0, lanParent_id, 0 )
                            FROM storeProductHom epageDB
                            WHERE de_id = 11245
                            ORDER BY rootTXT...
                            See more | Go to post

                              Leave a comment:

                            • richasaraf
                              replied to Question about INSERT clause.
                              in General
                              INSERT Statement



                              Hello there !
                              The query should be written as follows :

                              insert into table1 values ( select 'abcd', table2.a, table2.b from table2 );

                              In place of 'abcd' you can specify any variable name you want to insert !

                              :)...
                              See more | Go to post
                              Last edited by richasaraf; Dec 6 '05, 08:56 AM.

                                Leave a comment:

                              • richasaraf
                                replied to Calculate Difference Between Dates in SQL*Plus or PL/SQL
                                in General
                                Procedure to find difference between dates !



                                Use following procedure... which i got from one site ....
                                it will help u....

                                Code:
                                 CREATE OR REPLACE 
PROCEDURE PRINT_DATE_DIFF(p_dte1 IN DATE, p_dte2 IN DATE)
IS
v_diff NUMBER := 0;
v_hrs NUMBER := 0;
v_min NUMBER := 0;
v_sec NUMBER := 0;
BEGIN
v_diff := ABS(p_dte2 - p_dte1);
v_hrs := TRUNC(v_diff, 0)*24;
                                ...
                                See more | Go to post
                                Last edited by Niheel; Dec 6 '05, 07:07 AM.

                                  Leave a comment:

                                • richasaraf
                                  replied to Papers of OCP
                                  in General
                                  i need developer ones

                                  i need papers for developer one ....
                                  can u plz help me out ....

                                  thanks
                                  See more | Go to post

                                    Leave a comment:

                                  • richasaraf
                                    started a topic Papers of OCP
                                    in General

                                    Papers of OCP

                                    [FONT=Palatino Linotype]Hi there ! :)
                                    Can anyone of you provide me some links for preparation of OCP sql... i'm plannin to give the exam very soon ! :confused:

                                    Please if anyone can help me out here !!!! :)

                                    Thanks a lot in advance !!!![/FONT]
                                    See more | Go to post
                                    • richasaraf
                                      replied to Null Value in NOT IN condition.
                                      in General
                                      Not Null

                                      :) Please type the query as follows:

                                      SQL> SELECT * FROM TESTIN WHERE NAME NOT IN('GABBIE','GL ADIA') and NAME NOT NULL;

                                      NULL is the value which cannot be included as IN..... so always use it as given above.....


                                      :)
                                      See more | Go to post

                                        Leave a comment:

                                      • richasaraf
                                        started a topic Varrays !!!!
                                        in General

                                        Varrays !!!!

                                        Hey Guys !!!!

                                        Please help me out.......

                                        i have to make a small application using VARRAYS in Oracle 9i....
                                        Can you guys suggest me something good.......

                                        Thanks in advance...
                                        and hoping for a quick suggestion from all you guys ! :)
                                        See more | Go to post
                                        • richasaraf
                                          replied to Help: Problems with ALTER TABLE
                                          in Oracle
                                          Alter Table Solution !!!!!




                                          ------
                                          [FONT=Palatino Linotype][COLOR=Red]hey... even i use to face this problem.....
                                          this error occurs when from apps u are inserting or transacting with one table and while that is going on you acces that table from back end maybe from SQL Navigator or so...
                                          the solution to this is .... which i did... i asked my DBA to unlock the table or kill the session of...
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...