Search DaniWeb - plsql

plsql mathematical function 16 Years Ago by RatanKumar Does oracle plsql has PROBIT function inbuilt? is there any way i can implement it in plsql? this function is related to probability theory PLSQL Debugging Help 14 Years Ago by DishevldPeasant Hello, I am fairly new to SQL and PLSQL and am having a problem debugging some code for triggers, … PLSQL Multiple row insertion with the exists condition 10 Years Ago by Azii Hello All, I want to write the plsql stored procedure to insert multiple rows in a table. Table … oracle to plsql 13 Years Ago by shapam please convert this below query to plsql format select (select count(*) from cadastredefunct t where t.areacode= '… = 'H') AS CurrentOUTOFSCOPE from dual convert the above query to plsql. Re: oracle to plsql 13 Years Ago by hfx642 I'm sorry, but... [I]"please convert this below query to plsql format"[/I] and [I]"convert the above query to plsql."[/I] is NOT asking for help. It's asking for someone to do YOUR work [B]for[/B] you. Please abide by the forum rules. Thank-You! Creatting web pages using Plsql 16 Years Ago by manish.nankar Can anyone suggest me how to create web pages using PlSql?? Covert TSL code to PLSQL code 11 Years Ago by murthykk … where in I have to convert the TSQL code to PLSQL procedure. For the purpose of better understanding, I have created… shell script running plsql sodes 10 Years Ago by Achref_1 i have created my plsql script but i need to run it with shell script but i can get to it please help Re: plsql mathematical function 16 Years Ago by debasisdas There is no such function in Oracle. Re: PLSQL Debugging Help 14 Years Ago by debasisdas You need to mention which block of the code is causing the problem. plsql cartridge 19 Years Ago by oracle_dev Hi, I want to create a button which, when pressed, calls a procedure passing certain parameters to it. How do i do this? htp.formsubmit...? Thanks plsql as anonymous block in c# 8 Years Ago by kamilacbe string query = "DECLARE l_cursor SYS_REFCURSOR;ServiceName la_service_provider_detail.service_name%TYPE;Surname people.surname%TYPE;Forename people.forename%Type;"+ "Action Varchar(50);Rate ey_pupil_premium_log.rate%Type;"+… Re: plsql as anonymous block in c# 8 Years Ago by rproffitt A quick look. Remove that block comment from lines 8 to 14 to avoid something I ran into years ago. > Except within a character constant, a string literal, or a comment, the characters /* introduce a comment. http://en.cppreference.com/w/c/comment Re: plsql as anonymous block in c# 8 Years Ago by kamilacbe Hi , Its working for me , now after getting the ouput list what i want to incoporate is DBMS_OUTPUTLINE if the result is empty or doesnt satisfy the where clause inside my sp.can I add as below or should I need write seperate query with just DBMS_OUPTUT?please advice .. TIA string query = "DECLARE l_cursor SYS_REFCURSOR;status … Re: plsql as anonymous block in c# 8 Years Ago by rproffitt @OP, it appears your topic has changed. Maybe that's a new discussion since discussion is marked as solved? Re: oracle to plsql 13 Years Ago by hfx642 And how much are you willing to pay for someone to convert this? I don't come cheap! Re: oracle to plsql 13 Years Ago by shapam okay then i don't need your suggestion.. Re: oracle to plsql 13 Years Ago by hfx642 Sorry... But we are members of this forum to provide help... Not a service. Re: oracle to plsql 13 Years Ago by shapam hey i didn't ask service.. even i asked help only Re: Creatting web pages using Plsql 16 Years Ago by debasisdas PL/SQL is not desinged to create web pages. you need to use some scripting language for that. Re: Creatting web pages using Plsql 16 Years Ago by manish.nankar ya..Debasis...Absoulty right...but for creating that web page we can make use of PL SQL ..... i have created one psp file . which compiled using loadpsp function but what after that ,i really dont getting... Re: Creatting web pages using Plsql 16 Years Ago by debasisdas if you want to use database then definately yo can use sql ,pl/sql but not for designing the page. Re: Creatting web pages using Plsql 16 Years Ago by Trevisolli [QUOTE=debasisdas;779661]PL/SQL is not desinged to create web pages. you need to use some scripting language for that.[/QUOTE] You can use ORACLE WEBTOOLKIT to create web-pages. Re: Creatting web pages using Plsql 15 Years Ago by manuhar Ya they are all right Pl/Sql is a back end tool which is meant to deal with the data storage and retrieval ya u can create a front end tool not excatly all kinds of web pages u want but one of the web pages with ORACLE FORMS with which we can enter data to be stored (actually in many cases we use Java or .det )bbut we can also with ORACLE … PHP Session and MySQL Problem 13 Years Ago by TheHaxx0r1215 …;>PL/I</option><option value=\"plsql\">PL/SQL</option><option value…;>PL/I</option><option value=\"plsql\">PL/SQL</option><option value… Urgent help needed 20 Years Ago by Dounia :rolleyes: Hi, I am new to PLSQL and I have to answer three questions to which I … (SQL , PL/SQL) enough for searching jobs in ORACLE ? 18 Years Ago by g.prabu (SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ? Re: (SQL , PL/SQL) enough for searching jobs in ORACLE ? 18 Years Ago by tech291083 … ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i get better JOB ?[/quote] Yes you can. If… G'day 17 Years Ago by Gimmick … am a noob regarding 'real' programming. Started on Oracle SQL/PLSQL just 1,5 years ago for my work. Before that… learning lanuages (when I'm 54 (Not 64)) 17 Years Ago by MARY RABINDRAN Hi jack of unix commands,oracle plsql and php, wanting to clarify silly doubts and to look for support when stuck