Search DaniWeb - pl/sql

Re: School Intranet 16 Hours Ago by simhakidsden A school intranet is like a private website for students, teachers, and staff. It helps them communicate, share resources, and access important information within the school community. It's like a digital hub where everyone can connect and collaborate on school-related matters securely. Re: Using Natural Language to Query SQL Databases with Python LangChain Module 1 Week Ago by aishamushtaq very helpful Re: How to query database using variable and get all results not just one row 4 Weeks Ago by Mikekelvin … // Query database to retrieve records associated with the current user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt = …$conn->prepare($sql); $stmt->bindParam(':variable_name', $currentUser, PDO::PARAM_STR); $stmt->execute… Re: How to query database using variable and get all results not just one row 3 Weeks Ago by Chris_103 …: ```php // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt …= $conn->prepare($sql); $stmt->bindParam(':variable_name', $variable_name, PDO::PARAM_STR); $stmt->execute… Re: How to query database using variable and get all results not just one row 3 Weeks Ago by Biiim … try a `var_dump(str_replace(':variable_name',"'some_value'",$sql));var_dump($records);`? run the sql on whichever way you use to access your… Question Answering with YouTube Videos Using RAG in LangChain 3 Weeks Ago by usmanmalik57 …/paris-olympics-ticket-information-chatbot-with-memory-using-langchain) and [SQL databases](https://www.daniweb.com/programming/computer-science/tutorials/541771…/using-natural-language-to-query-sql-databases-with-python-langchain-module), using the Python [LangChain module… pass data to another asp page 3 Weeks Ago by Fergus_1 … with a gridview on it and it displays rows from sql table. i have also a link assigned to each row… Using Natural Language to Query SQL Databases with Python LangChain Module 1 Month Ago by usmanmalik57 …The LangChain agents convert natural language questions into SQL queries and return the response in natural language.…PostgreSQL Database Generating a response from the LangChain SQL agent is straightforward. First, you must create… This article shows how you can interact with SQL databases using natural language via the Python LangChain agents… How to query database using variable and get all results not just one row 2 Months Ago by nander … guidance? // Query database to retrieve records associated with the user $sql = "SELECT * FROM table_name WHERE variable_name = :variable_name"; $stmt …= $conn->prepare($sql); $stmt->bindParam(':variable_name', $variable_name, PDO::PARAM_STR); $stmt->execute… Re: Improve HAVING BY performance 1 Month Ago by toneewa … // For MySQL Connector/C++ version 8 sql::mysql::MySQL_Driver* driver; sql::Connection* con; sql::Statement* stmt; int ct = 0; …" // Use WHERE here "GROUP BY ProductName"); sql::ResultSet* result1 = stmt->getResultSet(); while (result1->next… Re: Improve HAVING BY performance 1 Month Ago by Reverend Jim … friend who spent the better part of a career doing SQL. I wrote up your question and sent it off to… the HAVING clause and optimize the overall performance of your SQL queries. He also said it was scary Re: How do you use LLM AI tools in your daily programming workflow ? 2 Months Ago by rproffitt … and they use it for many things. Examples such a SQL queries and regular expressions. He tells me they saved mid… Re: Improve HAVING BY performance 1 Month Ago by Dani … sending it over the wire. That means all PHP interpreted, SQL queries executed, etc. Everything we need to build the HTML… pl/sql 10 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 (SQL , PL/SQL) enough for searching jobs in ORACLE ? 17 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 14 Years Ago by sandyzden which version of MYSQL do support PL/SQL pl/sql 14 Years Ago by jeniferandrews from where can i download free e-book of pl/sql?? please reply asap... Regards, Jenifer PL/SQL 14 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 Re: (SQL , PL/SQL) enough for searching jobs in ORACLE ? 17 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 ? 14 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 ? 14 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 ? 10 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 13 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 14 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 12 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 16 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 13 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 8 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 12 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 12 Years Ago by jeevsmyd Doesn't support PL SQL I mean *