Search DaniWeb - pl-sql

(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 ? PL/SQL 15 Years Ago by sandyzden which version of MYSQL do support PL/SQL pl/sql 15 Years Ago by jeniferandrews from where can i download free e-book of pl/sql?? please reply asap... Regards, Jenifer PL/SQL 15 Years Ago by 1manik Hi, can you help me? I want to load txt file to database (Oracle). But I like to use PL/SQL. Do you have any idea, how I can do it? Thanks pl/sql 11 Years Ago by RainaAnja how to order rows in pl/sql? i have a table of numbers, i want to order in ascending order if id of table is odd and descending if id is even Re: (SQL , PL/SQL) enough for searching jobs in ORACLE ? 18 Years Ago by tech291083 [quote=g.prabu;329171](SQL , PL/SQL) enough for searching jobs in ORACLE ? i have 2.6 years exp with oracle sql, plsql . can i… Re: (SQL , PL/SQL) enough for searching jobs in ORACLE ? 15 Years Ago by slakshmi I got my B.tech(computer science)with first class. i have good knowledge in oracle 9i,sql,pl/sql basics. i am searching for a job.i dont have experience. Please any one help me to have good job to start my career. Re: (SQL , PL/SQL) enough for searching jobs in ORACLE ? 15 Years Ago by peter_budo …)with first class. i have good knowledge in oracle 9i,sql,pl/sql basics. i am searching for a job.i dont have… Re: (SQL , PL/SQL) enough for searching jobs in ORACLE ? 11 Years Ago by Pradeep24 I got my MCA with 74%. i have good knowledge in oracle 9i,sql,pl/sql . i am searching for a job.i have 6 months experience. Please any one help me to have good job to start my career. PL/SQL Triggers 14 Years Ago by Priyanka88 … for TRIGGER ACC_HISTORY: LINE/COL ERROR -------- ----------------------------------------------------------------- 2/1 PL/SQL: SQL Statement ignored 2/13 PL/SQL: ORA-00913: too many values I am unable… PL/SQL: ORA-00922: missing or invalid option 16 Years Ago by culbysl … I am receiving: [code] ORA-06550: line 5, column 5: PL/SQL: ORA-00922: missing or invalid option ORA-06550: line 5…, column 1: PL/SQL: SQL Statement ignored 3. endPos PLS_Integer; 4. begin 5. set startPos… PL SQL in Oracle 10g 13 Years Ago by jeevsmyd I used to write PL/SQL programs in oracle 9i.Since windows 7 doesnt support it, … a single run though. Like insert into many rows. But PL SQL programs are going crazy. Too many errors.Please help me… Re: PL/SQL Unit testing 17 Years Ago by sfeuerstein utPLSQL is a fine semi-automated testing utility for PL/SQL - I should know, I wrote the original version … which automates almost all the work of testing your PL/SQL code. I encourage you to check out Quest Code…commercial product, but definitely the most capable testing tool for PL/SQL out there! Warm regards, Steven Feuerstein [url]www.… pl/sql coding 14 Years Ago by lakshmi4788 Hi i want my formatted output should be in a straight line : 1 2 3 4 5 6. Is this possible in PL/SQL ? declare n number:=0; begin loop n:=n+1; dbms_output.put_line( n ); exit when n>=6; end loop; end; / Output : 1 2 3 4 5 6 PL/SQL procedure successfully completed. Thanx in advance. PL/SQL Procedure Error 9 Years Ago by yash_792 Hi I have written a procedure in PL/SQL to get values from user and then I am updating … user value is still showing blank. I have pasted the PL/SQL code below. CREATE OR REPLACE PROCEDURE input_clpi1599 AS A number… Re: PL SQL in Oracle 10g 13 Years Ago by jeevsmyd The problem was I was using HTML DB ( now called APEX )on Oracle 10g and it does support PL SQL. The program works perfectly on SQL+ commandline. Thank you for your time Re: PL SQL in Oracle 10g 13 Years Ago by jeevsmyd Doesn't support PL SQL I mean * PL/SQL: SQL Statement ignored 13 Years Ago by codex89 Why i am getting this error ERROR at line 5: PL/SQL: SQL Statement ignored Here is my code CREATE OR REPLACE PROCEDURE … pl/sql execution 11 Years Ago by mallikaalokam I wrote a sample program in notepad begin dbms_output.put_line('welcome'); end; / and saved it as p1.sql i opened sql prompt and gave @p1 it didnt worked??? i tried exec p1; still not working?? how to execute a pl/sql program???pls help PL/SQL + Apache2 19 Years Ago by errno Hy, is there in module for Apache2 that I can use to view my web site wroten in PL/SQL. By default It can be found with OAS but it comes with Apache1 version. I have already Apache2 that I use to serve PHP sites, but I would try it with Oracle 10g. What I need everything to solve it? Thnx. Ciao, errno PL/SQL Unit testing 17 Years Ago by Nige Ridd I want to put together a set of packages to help in unit testing PL/SQL code - does anyone know of any software ( commercial or not ) or books which I could look at for some inspiration. Thanks Nige Re: PL/SQL Unit testing 17 Years Ago by Nige Ridd … working on mini projects at home - mainly aimed at Oracle PL/SQL, I recently finished my first project and so was going… Re: PL/SQL Unit testing 17 Years Ago by darrinallen Oracle press has a great set of Pl/sql manuals. Have you ever tried the software called TOAD? It is a really great Oracle application. I think it is downloaded for free pl/sql block ! 15 Years Ago by CSG-SQU …;>> i have worked on Functions and precuders in PL/SQL for alsmost two weeks until now !! ummm i had some… PL/SQL Procedure for GETTING 4 dates: 14 Years Ago by Noorul Ariff … check, HOW MANY DAYS employee IS ABSENT... I need a PL/SQL PROCEDURE to ACCEPT 4 DATES: DATE 1: When he gave… [PL/SQL] select in a procedure 13 Years Ago by hatebin … product_price=500 if product_price > 400 then product_price=300 IN PL/SQL: [CODE] create or replace procedure change_price is begin if (select… Re: [PL/SQL] select in a procedure 13 Years Ago by hatebin … produc_id=777; END IF; end; [/CODE] ERROR at line 10: PL/SQL: Statement ignored Re: Debugger for PL/SQL in sql server 16 Years Ago by Ramy Mahrous PL\SQL just for Oracle and T-SQL for SQL Server, you can't run PL\SQL in SQL Server! except ANSI-SQL runs on both (all) RDBMSs Re: Using PL/SQL in VB.net 17 Years Ago by dadelsen …it be that the file does not only contain PL/SQL? Comments in PL/SQL are [ICODE]/* comment comment */[/ICODE] or […ICODE]-- comment[/ICODE] Calling PL/SQL from VB .NET may basically be performed by executing the PL/SQL text like: [ICODE]…there are traps for example using multiple PL/SQL statements in one call to "Execute...". < and > in PL/SQL 10 Years Ago by gharris55 In writing a Conditional Control Case Statement in PL/SQL, I got this error. My code is below. Is …> continue avg count current exists max min prior sql stddev sum variance execute forall merge time timestamp interval date…> <a number> <a single-quoted SQL string> pipe <an alternatively-quoted string literal with…