User Profile

Collapse

Profile Sidebar

Collapse
bharthi
bharthi
Last Activity: Sep 19 '13, 04:06 AM
Joined: Jun 29 '12
Location: Chennai, Tamil, NAdu,India.
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • bharthi
    started a topic Need SQL Query: produce output of 100s, 1000s, etc. based on table data
    in Oracle

    Need SQL Query: produce output of 100s, 1000s, etc. based on table data

    Hi Everyone,
    Here i need your help, and this is my table


    Code:
    CREATE TABLE cont (contnumber VARCHAR2(10), rcptnum NUMBER, rcptamount NUMBER);

INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
     VALUES ('a123', 1, 120
            );
INSERT INTO cont
            (contnum, rcptnum, rcptamt
            )
    ...
    See more | Go to post
    Last edited by Rabbit; Apr 29 '13, 03:31 PM. Reason: Please use code tags when posting code.
    • bharthi
      replied to Web application not updating datas properly on some systems..?
      in Software Development
      Hi Frinny ,
      We used VS 2010 and SQL server database, we having problem when we updating the datas into the application. some dats updating and we can see the datas in Database after update button click, some times it wont.or else it will be browser problem?, what is the standard browser to use the web application? please help, thanks in advance.
      See more | Go to post

        Leave a comment:

      • bharthi
        started a topic Web application not updating datas properly on some systems..?
        in Software Development

        Web application not updating datas properly on some systems..?

        Hi every one.
        I have a big problem, i have developed a web application , when i started to use the application and updating the datas using that web application, but its updating datas in some system but its not updating dats in other systems, what wolud be a problem, please help in this issue, your time will be appreciated, Thank You.
        See more | Go to post
        • bharthi
          replied to How do I Create a Comma-Separated List using a PL/SQL Query?
          in Oracle
          Hi, rajujrk,
          Your Code was awesome , thanks for your solution, Thanks , thanks a lot. :)
          See more | Go to post

            Leave a comment:

          • bharthi
            replied to How do I Create a Comma-Separated List using a PL/SQL Query?
            in Oracle
            Hi ... i have one doubt in the above query can you please explain it.. WHAT IS THAT "v_txns".. i getting the error due to this "v_txns"... help me.. please . thanks again...
            See more | Go to post

              Leave a comment:

            • bharthi
              replied to How to restore the Oracle 10g XE database.
              in Oracle
              Hi Rski, i backed up using RMAN command line like this,

              sqlplus


              > connect test as sysdba
              password test

              >shutdown immediate

              >startup mount

              >alter database archivelog

              >alter database open

              >$rman

              >connect target

              > backup database.
              See more | Go to post

                Leave a comment:

              • bharthi
                replied to how to get present time and date?
                in Oracle
                use this query to see present data and time,

                select systimestamp from dual;
                See more | Go to post

                  Leave a comment:

                • bharthi
                  started a topic How to restore the Oracle 10g XE database.
                  in Oracle

                  How to restore the Oracle 10g XE database.

                  HI all,
                  I had to change my OS in WINDOWS desktop, before that i backed up my Oracle 10g xe database and saved the whole file into separate drive in my system and changed my OS, now any one can assist me how to restore the backed up database in my newly changed OS system?
                  kindly provide the solution for my problem, your time will be highly appreciated .
                  Thank You.
                  See more | Go to post
                  • bharthi
                    replied to how to take full database backup using toad
                    in Oracle
                    Hi Sir,
                    please verify this link, http://docs.oracle.com/cd/E11882_01/...2/rcmbckba.htm. or i saw some videos to take online and offline backups in YouTube.
                    See more | Go to post

                      Leave a comment:

                    • bharthi
                      started a topic How do I Create a Comma-Separated List using a PL/SQL Query?
                      in Oracle

                      How do I Create a Comma-Separated List using a PL/SQL Query?

                      Hi experts,
                      I have T-SQL funtion, here the query is used to list the data separated by comma.how can we write in PL/SQL.

                      role
                      table for example: -------
                      audit
                      cement
                      mason
                      result should be: audit,cement,ma son.

                      ALTER FUNCTION dbo.fnGetRolesB yEmployeeID
                      (
                      @EmployeeID...
                      See more | Go to post
                      • bharthi
                        replied to how to execute this PL/SQL procedure?
                        in Oracle
                        Hi all , Thanks for your reply to my doubt.
                        but i got the answer for my procedure .Answer is ,
                        variable io_pro;
                        execute pro_name ('emailid','pas sword',:io_pro) ;
                        print io_pro;

                        Thanks to every one again.
                        See more | Go to post

                          Leave a comment:

                        • bharthi
                          replied to how to execute this PL/SQL procedure?
                          in Oracle
                          yes i declared as out number ,but its not working , what to do i don know, actually i have one login page ,for that they coded in .CS page inthat page they used four stored procedure in T-SQL, for that i have to convert into pl/SQL, but searched a lot but no founded a solution.
                          See more | Go to post

                            Leave a comment:

                          • bharthi
                            replied to how to execute this PL/SQL procedure?
                            in Oracle
                            Error starting at line 21 in command:
                            execute PRO_GET_SYSTEM_ IsValidUser ('velu@gmail.co m','demo',null)
                            Error report:
                            ORA-06550: line 1, column 60:
                            PLS-00363: expression ' NULL' cannot be used as an assignment target
                            ORA-06550: line 1, column 8:
                            PL/SQL: Statement ignored
                            06550. 00000 - "line %s, column %s:\n%s"
                            *Cause: Usually a PL/SQL compilation error.
                            *Action:
                            See more | Go to post

                              Leave a comment:

                            • bharthi
                              replied to how to execute this PL/SQL procedure?
                              in Oracle
                              Hi, no its not executing, i getting error only.
                              See more | Go to post

                                Leave a comment:

                              • bharthi
                                replied to how to execute this PL/SQL procedure?
                                in Oracle
                                oh I see! ...Then Ok , so i need to declare that "P_exist" as OUT . am i right sir?. if i executed after i declared as "OUT" for that third argument, i got error,
                                ORA-06550: line 1, column 7:
                                PLS-00306: wrong number or types of arguments in call to 'PRO_GET_SYSTEM _ISVALIDUSER'
                                ORA-06550: line 1, column 7:
                                PL/SQL: Statement ignored.

                                please reply , what i have to do ,how to execute this procedure,...
                                See more | Go to post

                                  Leave a comment:

                                • bharthi
                                  replied to how to execute this PL/SQL procedure?
                                  in Oracle
                                  HI Rabbit,
                                  I executed that procedure like this,
                                  execute pro_name ('emailid','pas sword'), it returns an error, so i need third one , how to declare third one when i executing this procedure? , i storing 1 in p_exist so it should be in out parameter. please help if you know this.
                                  Thanks for reply.
                                  See more | Go to post

                                    Leave a comment:

                                  • bharthi
                                    replied to how to execute this PL/SQL procedure?
                                    in Oracle
                                    Hi raghurocks, I did like that only, but i posted wrongly in my post, eventhough i executing with two parameters, how it will work, im sure that this query needs three parameter, thats y i don know how to pass third one, please provide solution if you know.
                                    Thanks for your reply.
                                    See more | Go to post

                                      Leave a comment:

                                    • bharthi
                                      replied to how to grant sysdba privileges to user
                                      in Oracle
                                      Hi Ramanan sir ,
                                      Try this one,

                                      grant connect ,resource,DBA to USER
                                      See more | Go to post

                                        Leave a comment:

                                      • bharthi
                                        replied to how to execute this PL/SQL procedure?
                                        in Oracle
                                        how to execute this PL/SQL procedure?

                                        Hi all,
                                        I need your help here,

                                        i have pl/sql procedure , this query returns 1 as out put, but how to see that result?. when i execute this procedure,like this,

                                        execute pro_name('email id',password);
                                        it shows
                                        ORA-06550: line 2, column 1:
                                        PLS-00306: wrong number or types of arguments in call to 'PRO_GET_SYSTEM _ISVALIDUSER'
                                        ORA-06550:...
                                        See more | Go to post
                                        Last edited by Rabbit; Jul 2 '12, 03:02 PM. Reason: Please use code tags when posting code.

                                          Leave a comment:

                                        • bharthi
                                          started a topic how to execute this PL/SQL procedure?
                                          in Oracle

                                          how to execute this PL/SQL procedure?

                                          Hi all,
                                          I need your help here,

                                          i have pl/sql procedure , this query returns 1 as out put, but to see that result?, when i execute this procedure,like this,

                                          execute pro_name('email id',password);
                                          it shows only "anonymous block completed",
                                          how to see its output that retrieves, Is there any possibility?
                                          my PLSQL query is,
                                          Code:
                                          CREATE OR REPLACE
  PROCEDURE PRO_GET_SYSTEM_IsValidUser(
                                          ...
                                          See more | Go to post
                                          Last edited by Rabbit; Jul 3 '12, 04:46 PM. Reason: Please do not double post your questions. Please use code tags when posting code.
                                          No activity results to display
                                          Show More
                                          Working...