- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
|
Hello, I am `Inserting` the data into table1 where c1 is new column and data is from table2. but c2 data type is `varchar2` and c1 datatype is `Number format`. ` INSERT INTO table1 (to_number(USER_ID)) SELECT EMP_ID FROM table2 WHERE USER_NAME IN (SELECT UNAME FROM table1); ` Here `USER_NAME` column … 
|
|
|
Hello All, I have a table with column_name as USERNAME where USERNAME is VARCHAR2(20) and I want to display it as **"USERNAME@email.com"**. How to write the select query for this. **QUERY**: SELECT USERNAME AS EMAIL FROM STUDENT Thank you.
|
|
|
Hello All, I want to write the plsql stored procedure to insert multiple rows in a table. Table t1, table t2. Table t1 column names(c1,c2,c3,c4,c5) table t2 column name (c2,c3,c4) column names c2, c3, c4 are same in both tables. BEGIN INSERT into t1(c1,c2,c3,c4,c5) select "a" as c1, c2, c3, … |
|
|
Hello All, I want to write the plsql stored procedure to insert multiple rows in a table. Table t1, table t2. Table t1 column names(c1,c2,c3,c4,c5) table t2 column name (c2,c3,c4) column names c2, c3, c4 are same in both tables. now I want to insert the data into t1 by …
|
|
|
Hello, I have written the basic shell script "myscript.sh", which prints Hello World. I want to call this script using PL/SQL. Please let me know the procedure(steps) for the same. Thank you.
|
|
|
Hi, The question is regarding PHP and Javascript/Jquery. I have a php page which process the form data and displays it on SUBMIT. I need to collect that data into javascript. how should I proceed? **//Php file** <?php @session_start(); $uname = $_SESSION['sessionVar']; ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> … 
|
|
|
Hi, I have php page, 2.php, which collects the data and dispalys it from previous page , 1.php. In 2.php, I also have html and javaScript, which contains a button, and cerresponding onclick script, which opens the OUTLOOk to send the E-mail with given sendername and subject. But for body … 
|
|
|
Hi, I am trying to fetch username from session variable of one php page to another php page. This below code fetch username from login page <?php $uname = $_GET['uname']; @session_start(); if($_SESSION[$uname]) { ?>.... //Remaining Code When I click submit button to go to my next php page I want …
|
|
|
This is regarding the sending E-mail using php and OUTLOOK. I have a "php page" which collect output from previous page. once clicking on send button, it should open my OUTLOOK client, which should have collected data as the body of email.
|