User Profile

Collapse

Profile Sidebar

Collapse
kiss07
kiss07
Banned
Last Activity: May 15 '08, 06:02 AM
Joined: Jan 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • kiss07
    replied to Theory questions
    in Oracle
    Compile Package Body

    Dear Friends,

    My version is 9i.

    I create lot of local procedures in package body,how can i compile that local procedures, any idea ?

    Expecting Your replies..

    Regards,

    Kiss07.
    See more | Go to post

      Leave a comment:

    • kiss07
      replied to Theory questions
      in Oracle
      Sql Basics

      Dear friends,

      I faced one interview question . one table emp contains 10 rows.


      select * from emp;

      10 rows selected

      after that simply display 10 rows ,what are the backround process are done before displaying 10 rows are selected.


      Expecting Your replies..

      Regards,

      Kiss07.
      See more | Go to post

        Leave a comment:

      • kiss07
        replied to Theory questions
        in Oracle
        Cursors

        Dear friends,

        My version is 9i.

        What is difference between week typed cursor and strong typed cursor?

        Expecting Your replies..

        Regards,

        Kiss07
        See more | Go to post

          Leave a comment:

        • kiss07
          replied to Theory questions
          in Oracle
          Packages Related.

          Dear friends,

          My Oracle version is 9i.

          what are the disadvantages in packages? and also anysize or limit in (number of)procedure and function in used in package specification and body.

          and

          also in program side which situation use in procedure and which situation use in functions tell me about briefly.please

          Expecting Your repies...
          See more | Go to post

            Leave a comment:

          • kiss07
            replied to Theory questions
            in Oracle
            IN or EXISTS

            Dear friends,

            My oracle version is 9i.

            Anybody send reply which one is Faster IN or EXISTS in Sql Tuning Operation

            Expecting Your Replies ..

            Regards,

            Kiss07.
            See more | Go to post

              Leave a comment:

            • kiss07
              replied to Theory questions
              in Oracle
              Theory questions

              Dear Friends,

              What is performanceTuni ng?

              why we are using performance tuning and also what is expain plan ?

              same as what is sql tuning?


              Regards,

              kiss07.
              See more | Go to post

                Leave a comment:

              • kiss07
                replied to Theory questions
                in Oracle
                Materialised View.

                Dear friends,

                What is the purpose of using Materialised View?
                Why we are Using M.view in oracle 9i.?
                Any advantages compare to normal view?

                Expecting Your replies..

                Regards,

                Kiss07
                See more | Go to post

                  Leave a comment:

                • kiss07
                  replied to Theory questions
                  in Oracle
                  Dear Debas,

                  Thanku Very much..

                  Regards,

                  Kiss07
                  See more | Go to post

                    Leave a comment:

                  • kiss07
                    replied to Theory questions
                    in Oracle
                    increase elapsed time in oracle

                    Dear friends,

                    My basic requirements is mention below:

                    I maintained a table emp it contains all employee details and salary details etc..after one month insert lot of records in day by day order nearly lakhs..
                    that period execution time is very very low .What can i do improve query performance , please send reply..

                    Regards,

                    Kiss07.
                    See more | Go to post

                      Leave a comment:

                    • kiss07
                      replied to Theory questions
                      in Oracle
                      Package body.

                      Dear Friends,

                      How can i compile package body?In my requirements lot of local procedures
                      in package body so i face some problems in package body occur errors in local procedures.

                      Expecting Your Replies...

                      Regards,

                      Kiss07.
                      See more | Go to post

                        Leave a comment:

                      • kiss07
                        started a topic Theory questions
                        in Oracle

                        Theory questions

                        Dear Friends,

                        My oracle Version is 9i.my doubts is trigger related question.Anybod y clear my doubts.Is possible to create DDL OR TCL OR DML inside trigger use execute immediate statements?

                        Expecting Your replies..

                        Regards,

                        Kiss07.
                        See more | Go to post
                        • kiss07
                          replied to PL/SQL theoretical questions
                          in Oracle
                          Bind Variables?

                          Dear friends,

                          In oracle version 9i.What is the use of Bind variables and Host variables?
                          expecting ypur replies..

                          Arun..
                          See more | Go to post

                            Leave a comment:

                          • kiss07
                            replied to PL/SQL theoretical questions
                            in Oracle
                            Joins

                            Dear Friends,

                            Now i atttend Oracle interviews.I want to learn queries in left outer join
                            and right outer joins ,full outer joins in oracle 9i.Any body Help to me..any notes or send any links ..please help..

                            Expecting Your Replies..

                            Arun..
                            See more | Go to post

                              Leave a comment:

                            • kiss07
                              replied to PL/SQL theoretical questions
                              in Oracle
                              BulkInsert

                              Dear Debas,

                              Almost my posting all are improving...

                              oracle version:9i

                              what is difference between for loop and forall loop in plsql.
                              any relationship from Bulk insert and forall .please explain clear..

                              Expecting Replies..

                              Arunkumar..
                              See more | Go to post

                                Leave a comment:

                              • kiss07
                                started a topic Indexes
                                in Oracle

                                Indexes

                                Hi,

                                what is the use of Function based indexes.?
                                compare to revere index ,which index is better? .

                                Expecting replies..


                                Arun..
                                See more | Go to post
                                • kiss07
                                  started a topic Back up contents in table data
                                  in Oracle

                                  Back up contents in table data

                                  Hello every one ,

                                  how to write an (procedure (or) trigger) which would enable me to copy the contents of one table to an another

                                  Table structure: oracle version is 9i:

                                  orginal table:

                                  create table temp(
                                  empno varchar2(5),
                                  name varchar2(40));


                                  back up table:

                                  create table temp_bakup(
                                  empno varchar2(5),
                                  name varchar2(40);...
                                  See more | Go to post
                                  • kiss07
                                    started a topic Oracle table Maintainance.
                                    in Oracle

                                    Oracle table Maintainance.

                                    Hi,

                                    In a table had one lakh records are there.it contains lot of null values

                                    and duplicate values , retrieve records time is very slow . what are steps

                                    are doing now that table is efficent and any more process are there?

                                    any body help to me..


                                    Regards,

                                    Arun..
                                    See more | Go to post
                                    • kiss07
                                      started a topic cursor is open or not?
                                      in Oracle

                                      cursor is open or not?

                                      Dear friends,

                                      I write a program using oracle version 9i. in cursor .How can i find out

                                      is a cursor is open or not? after that what is bind variable ? what is the use of

                                      Bind variable in plsql?

                                      Expecting your replies...


                                      Arun..
                                      See more | Go to post
                                      • kiss07
                                        started a topic Rollup and Cube..
                                        in Oracle

                                        Rollup and Cube..

                                        Dear Friends,

                                        I have an some question please clarify .

                                        1)what's the difference between rollup and cube in sql?
                                        2) what are ome restriction on procedure and function?
                                        3)is possible calling an sql from plsql?

                                        Expecting your reply..

                                        Regards,

                                        Arun..
                                        See more | Go to post
                                        • kiss07
                                          replied to PL/SQL theoretical questions
                                          in Oracle
                                          Can't understand debas,

                                          pls update my error ( correct coding..)


                                          Arun..
                                          See more | Go to post

                                            Leave a comment:

                                          No activity results to display
                                          Show More
                                          Working...