473,401 Members | 2,146 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,401 software developers and data experts.

how to insert values into a table

22
Hello Experts,

I have a question on PL SQL. Assuming I have the following table

TestTable (ID, Table_Name, Column_Name)

It is in the form like
Expand|Select|Wrap|Line Numbers
  1. ID, Table_Name, Column_Name
  2. -----------------------------------
  3. 1     TableA      ColA1
  4. 1     TableA      ColA2
  5. 1     TableA      ColA3
  6. 2     TableB      ColB1
  7. 2     TableB      ColB2
  8. 3     TableC      ColC1
  9. 3     TableC      ColC2
  10. 3     TableC      ColC3
  11. 3     TableC      ColC4
  12. .
  13. .
  14. .
  15. ------------------------------------
The columns "Table_Name" and "Column_Name" have been inserted into the table, while ID is NULL before we insert the corresponding values. I wish to know a code to generate the ID and how to insert the ID into TestTable with PL SQL.

Thanks for any help.

Cuq
May 30 '12 #1
1 1750
Rabbit
12,516 Expert Mod 8TB
Why would you need the ID field? It adds no additional information to what you already have.
May 30 '12 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Cliff | last post by:
I'm trying to do multiple insert statements. The table looks like this: CREATE TABLE $table (CNTY_CNTRY_CD char(3),ST char(2), CNTY_CNTRY_DESCR varchar(50),CNTY_CNTRY_IND char(1),...
0
by: Alexander Vlasenko | last post by:
Please CC me, I am not subscribed. An imaginary SQL statement INSERT INTO table FETCH ... FROM cursor; looks almost the same as currently available INSERT INTO table SELECT ...; I tried it...
3
by: indhu | last post by:
Hi all Is it possible to insert 5 table field into single form. all the table has same values except typeof work 11 columns 6 rows i ve to display. totally 72 fields suggesstion and help...
1
by: soahil | last post by:
hello I am facing a problem. i have two tables named "BILL_DETAIL" and "COMPANY" both structure is as follws: --------------------- "BILL_DETAIL" --------------------- BILL_ID ...
6
by: kareemaffan | last post by:
Hello Everyone I want to insert values into MS Access database through VB.NET in Visual Studio 2005 . I have used the following code which is not working. Private Sub Button2_Click(ByVal sender...
1
by: menmysql | last post by:
hi to all, i want to insert data into enum fields but i am not able to insert values. can any one help me regarding this regards
2
by: blitzztriger | last post by:
Hello!! how do i insert values into mysql , after parsing a submiting textbox?? I made the arrays, so this should be a basic insertion of them in the db, but something is missing, or in the wrong...
2
by: jeenajos | last post by:
Hi all, while writing a query to insert values into a database it gave me an error. Query goes like this: Insert into .. ( , ,) Values (<Cargo,Varchar(50),>
2
by: AccessHunter | last post by:
Hi, I am new to ASP, so please bear with me if I am asking something basic. In my asp code I am trying to insert values to a temp table with data entered on the page. When nothing was getting...
7
by: saiindu | last post by:
How to insert values from one jtable to another jtable using arraylist(tokenizer). private void readPreviousValues() { String temps = null; StringTokenizer tokenizer; ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.